Oh for the wait interface, part 2

A while back I wrote a post expressing a longing for wait-interface tuning like we have for Oracle (and now SQL Server, I hear). Since then I have found out that the MySQL community server (since 5.0.37) has something starting along those lines: the query profiler.

Using the query profiler, you can get at wait times for a particular query, to help you tune it. There is the official documentation, and, even better, an article by Robin Schumacher that explains and gives examples.

From here it would probably be a “simple” matter to start collecting all this data system-wide, into a repository, to gather global information on wait-event times.   In the meantime, this is certainly a step in the right direction.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: