MYSQL slow on 1 website. [moved]

[X22]

Hello,

I host quite a database intensive website and the site is allways slow, does cpanel allocate a certain amount of memory or power for accounts in mysql?

If so how do i up the limits?

Thanks.

[cguimont]

I don't think there are. But I would check the tables inside the database to see if they are optimized.

[kris1351]

Depending on the forum there are lots of tweaks you can do in your code. Make sure your server is tuned for optimal performance.

[chirpy]

If this is your own server you should also optimize MySQL for your load distribution. If it isn't your server, you should ask your web hosting provider about it (e.g. enabling MySQL query caching).

[X22]

This is my own server, thing is all other websites work fine apart from this particular site.

Any advise would be appreciated.

Thanks.

[X22]

Just to mention this server is a duel xeon 2.4 with 2GB of ram.

Current load: 2 users, load average: 0.60, 0.66, 0.64

mytop:

MySQL on localhost (4.0.25-standard) up 0+06:56:48 [11:25:00]
Queries: 222.6k qps: 9 Slow: 1.0 Se/In/Up/De(%): 33/03/33/03
qps now: 17 Slow qps: 0.0 Threads: 2 ( 2/ 18) 05/02/02/81
Cache Hits: 13.6k Hits/s: 0.6 Hits now: 0.0 Ratio: 18.4% Ratio now: 0.0%
Key Efficiency: 94.7% Bps in/out: 853.9/ 1.6k Now in/out: 1.4k/948.7