Do you need to find qps for peak hours not avg qps through mysql life.
The MySQL 5.1 offers new GLOBAL_STATUS information schema tables. These can be used to report certain performance metrics, such as the number of queries processed per certain seconds, NOT overall avg queries per second, Its good to know how much qps in peak hours.
http://forge.mysql.com/tools/tool.php?id=217
Database Administrator specialized MySQL. Topics: mysql tutorial, database design, mysql data types, mysql commands, mysql dump, database development, mysql training, mysql scalability, mysql sharding, mysql performance tuning, mysql tools.
Thursday, July 30, 2009
Thursday, July 09, 2009
Threads with "freeing items", "Sending data" and "Locked" never finish
In one of the servers we have an issue that happens to one of the servers that some items
that have the status of "freeing items" and "Sending data" are just stuck there, causing a
lot of locks on the server, and the load of the server drops to almost 0.
The server then wouldn't restart, and the only solution is to kill the mysqld process, and
fix the crashed tables that result from the kill.
How to repeat:
There is no specific knowledge of when does this happens or why, but it happens like once
every 3 days.
Solution:
turn query cache off.
to follow up see: http://bugs.mysql.com/bug.php?id=45544
that have the status of "freeing items" and "Sending data" are just stuck there, causing a
lot of locks on the server, and the load of the server drops to almost 0.
The server then wouldn't restart, and the only solution is to kill the mysqld process, and
fix the crashed tables that result from the kill.
How to repeat:
There is no specific knowledge of when does this happens or why, but it happens like once
every 3 days.
Solution:
turn query cache off.
to follow up see: http://bugs.mysql.com/bug.php?id=45544
Subscribe to:
Posts (Atom)