Poor man's query profiling

Posted on 2008/05/22 by

There is one very easy way to find database queries that might be performance bottlenecks on properly running servers, without using any sophisticated tools or using precision slowlogs,

Just overload your server, and spam ‘SHOW FULL PROCESSLIST’. :)

Advertisement
This entry was posted in mysql and tagged , . Bookmark the permalink.

3 Responses to Poor man's query profiling

  1. Alexey Zakhlestin says:
    2008/05/22 at 14:16

    LOL :-D

    looks like method of Dr.House ;)
    smth. like: He is ill, but we are not sure what’s wrong. Let’s stress him until he almost dies and recheck the symptoms

  2. Mark Callaghan says:
    2008/05/22 at 16:50

    This works great, and prior to having SHOW USER_STATISTICS, it was our best tool for profiling server load. It works better when you have code that archives the sampled statements and a tool to query the archive. In addition to profiling, the archive helps when debugging crashes, long lock waits and query pileups.

  3. Pingback: Poor man’s contention profiling « domas mituzas: vaporware, inc.

Comments are closed.