I have 4 sites that all use 1 database. But 2 weeks ago mysql started
to use up to %25 of 2GB RAM. And also queries started to run slowly.
So after a few hours server dies as there become lots of unresponded
apache threads. I have indexes etc. for the tables. I cant find why it
uses so much memory and responds so slowly. The tables have 200K~
rows. I need to fix it because they will have 1000K soon. I'll be
happy if you can me to fix that problem. Thanks a lot for your
replies...

On Oct 5, 7:38 pm, ars_oguz <ars_o...@yahoo.com> wrote:
> I have 4 sites that all use 1 database. But 2 weeks ago mysql started
> to use up to %25 of 2GB RAM. And also queries started to run slowly.
> So after a few hours server dies as there become lots of unresponded
> apache threads. I have indexes etc. for the tables. I cant find why it
> uses so much memory and responds so slowly. The tables have 200K~
> rows. I need to fix it because they will have 1000K soon. I'll be
> happy if you can me to fix that problem. Thanks a lot for your
> replies...

It could be a lot of things. Can you try logging slow queries first
to see which queries are running slowly?
http://www.google.com/search?hl=en&s...g+slow+queries

Then, use the EXPLAIN statement to see how MySQL is performing these
slow queries. That should be a good start at least.

Also, it might not be a MySQL problem, it could be an Apache problem.
Just out of curiosity, are there any large Apache log files? I've
gotten bitten a few times by log files reaching 2 GB, which slows
Apache down a lot.