MySQL Forums
Forum List  »  Performance

Linear MySQL Slow Downs Over Time
Posted by: Shawn Hogan
Date: September 10, 2005 02:12PM

My MySQL database server runs about 120 queries per second, none of which should ever be "slow queries" (or take more than a second), but the more queries there have been since mysqld started, the slower they take. It's to the point now that the mysqld process has to be restarted every 24 hours (after 24 hours, identical queries are ~10x faster after you restart the mysqld process).

If you let mysqld run long enough (I don't let it get to that point, because I restart the process every day now), the simplest SQL query will take 90 seconds to run. Restart the mysqld process and it's back to (0.00 secs).

Another odd thing is the normal script you can use to stop/start/restart mysqld is not able to stop mysqld when it's slow enough it requires the restart. Instead I have to stop mysqld with "mysqladmin shutdown", then use the normal startup script to start it again.

The server itself is not overloaded (even when mysqld is so slow it needs to be restarted), typically with a load average around 0.50. The machine itself is a dual 2.3Ghz G5 Xserve with 5GB RAM running Mac OS X Server 10.3.8 and mysql 4.1.14 (upgraded from 4.1.10 to try and solve the problem), and runs nothing else besides MySQL.

Does anyone have any insight? Because this is starting to drive me crazy and terribly impractical for the db server to get slower and slower each hour.

Edited 1 time(s). Last edit at 09/10/2005 02:15PM by Shawn Hogan.

Options: ReplyQuote

Written By
Linear MySQL Slow Downs Over Time
September 10, 2005 02:12PM
September 11, 2005 11:42AM
September 11, 2005 03:52PM
September 13, 2005 04:03PM
September 14, 2005 01:22PM
September 14, 2005 01:35PM
September 14, 2005 05:23PM
September 14, 2005 06:35PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.