mysql is extremely slow

hi everyone . i have bought dedicated server with 256 MB ram i have run some static pages . speed is good . but when i have installed phpfox and run with my server's mysql . it has been taking ages to execute the query . however when i have used one of my sharing hosting 's mysql which alow remote connections my queer's are executing very fast . site running very smooth .

now i have realized my server's mysql perfomance is extremely poor . even when 3/4 user is online its just take ages to load .

is there any way to boost mysql perfomance .

please advice

 

upgrade memory to 512mb at least.

how much did you pay for that server?

 

Depending on how complex the DB structure and the queries are, you need CPU performance as well as much RAM.
But 256MB is definitly to less especially you have many differenz processes running (probably), that need memory (apache, postfix/sendmail, ftp, mysql...)

You could also activate the slow log of mysql and then check (in case of select statemens) with
explain select ...
if keys and indexes are set correct...

 

what are your system specs?
what is your config?
how big is the database?

 

my server configurations

space 40 GB .
ram 256

apache 2.2.2

php 5.2.2

mysql version 5.0.27

ISP config

and webmin

plz suggest now what should i do to make mysql faster

Thanks

Niz

 

Are there any MySQL-related errors in your logs?

Also take a look here: http://dev.mysql.com/doc/refman/5.0/en/optimizing-the-server.html

 

thank you falko

thank you falko . you are so kind . once again thanks for the link .

I cant see any error . but query executing very slowly . is ther any command to check mysql log ?

cheers

Niz

 

You should check all logs in the /var/log directory.
To open a log file, you can use a text editor such as vi, or use cat to display the entire contents at once (can be long!). You can also use tail. For example, to display the last 100 lines of /var/log/syslog, you'd do it as follows:

Code:

tail -n100 /var/log/syslog