mysql is using the memory too much

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
innosys
Forum Newbie
Posts: 7
Joined: Mon Aug 22, 2005 9:47 am

mysql is using the memory too much

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
bg
Forum Contributor
Posts: 157
Joined: Fri Sep 12, 2003 11:01 am

Post 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/
Post Reply