Page 1 of 1

mysql is using the memory too much

Posted: Mon Aug 22, 2005 9:56 am
by innosys
Hi

i have a news website and suddenly my site is starting to hang and going to be slow

the hosting company answer me that the problem is in my site programming also the site was running perfect 4 month ago

they say that website mysql is using the memory too much

any one can help

note: I have 350000 hit per day

Posted: Mon Aug 22, 2005 10:09 am
by feyd
with that many hits, it's quite possible to nuke the memory core. If you post some of your code, we may be able to help pair down the usage or give some pointers to help speed execution.

Posted: Wed Aug 24, 2005 11:00 am
by bg
you probably need to optimize your queries. Learn how to use the explain statement on your queries.

http://www.devshed.com/c/a/MySQL/MySQL- ... -part-1/2/