Friday, January 11, 2013

MySQL Performance Analysis

I have been facing mysql database server slowness, application slow response, database cpu load shoot up all of a sudden and sometimes reboot needed to recover from high load. 

How we can analyze database performance and how we can fine tune it. 
Here are few important analysis we need to do to improve database performance:

  • Slow query analysis (
  • Worker thread analysis (
  • Connections usage analysis
  • Innodb status/data size analysis
  • Memory usage analysis
  • Key buffer analysis
  • Query cache analysis
  • Sort/join operation analysis
  • Open file analysis
  • Table cache analysis
  • Temp table analysis
  • Table scan analysis
  • Table locking analysis
  • Queries (insert/select/delete/update) analysis 
  • Storage engine analysis 

No comments:

Post a Comment