Re: Linear MySQL Slow Downs Over Time
Posted by:
Shawn Hogan
Date: September 14, 2005 01:22PM
As I mentioned previously, this server runs no services other than mysqld. This image shows the CPU usage on the server with the red arrows showing when the mysqld process was restarted on the server (server was not reboot).
Queries (type and QPS) were not changed when the process was restarted.
http://www.digitalpoint.com/mysql_cpu_usage.gif
Every time I restart the process, it amazes me how fast MySQL *can* be. :)
It doesn't appear to be related to time, but related to the total queries (maybe connections) made to mysqld since it was started. Almost like it's doing something weird like counting from 1 to the total queries made since it was started. It just gets slower and slower and slower the more queries you do.
Subject
Views
Written By
Posted
6153
September 10, 2005 02:12PM
2232
September 11, 2005 11:42AM
2023
September 11, 2005 03:52PM
1950
September 13, 2005 04:03PM
Re: Linear MySQL Slow Downs Over Time
2046
September 14, 2005 01:22PM
2024
September 14, 2005 01:35PM
1996
September 14, 2005 05:23PM
2017
September 14, 2005 06:35PM
2082
October 14, 2005 07:43AM
1898
October 19, 2005 03:34PM
2025
May 15, 2007 11:40PM
2412
May 18, 2007 12:46PM
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.
