469,128 Members | 1,611 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,128 developers. It's quick & easy.

Mysql High usage Problem (help)

1
Hi people i need serious help here..

I have a forum and my hosting company suspended it cuz of the high usage of sql.
We did everything to make lower the usage but its still high.

it was

Generated in 2.0792990 seconds (18.30% PHP / 50-80 % MySQL)
MySQL Queries:152 / Global Parsing Time: 0.4743950 / Memory Usage: 4.01 MB
PHP version: 4.4.4 / Server Load: Bilinmeyen / GZip Compression: Enabled


after i go back to default settings

Generated in 2.0792990 seconds (18.30% PHP / 25-60 (smtms 70-80)% MySQL)
MySQL Queries: 22-25 / Global Parsing Time: 0.4743950 / Memory Usage: 4.01 MB
PHP version: 4.4.4 / Server Load: Bilinmeyen / GZip Compression: Enabled

what can i do any more..

thanks..
May 24 '07 #1
2 1425
pbmods
5,821 Expert 4TB
Check your queries. Really slow or (to be honest, and nothing personal) poorly-written queries tend to eat up memory and CPU time.

I'd check your slow queries log and try EXPLAINing them.

Make sure your tables are well-indexed; that really helps cut down on the number of rows MySQL has to search.
May 25 '07 #2
Atli
5,058 Expert 4TB
I'd also try to avoid the LIMIT clause where possible. It has an annoying habit of scanning entire tables even if you only ask for a couple of rows.
May 25 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by JP | last post: by
39 posts views Thread by Mairhtin O'Feannag | last post: by
1 post views Thread by Damien | last post: by
2 posts views Thread by O.L. | last post: by
3 posts views Thread by kanna | last post: by
reply views Thread by Learning.Net | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.