MySQL: Tracking slow queries

While running performance testing against some web application we should measure not only such metrics as page download time, hits per second and so on, but also those ones that relate to a database. It’s obvious that the time of queries execution has a great impact on the first metrics like page download time.

For such cases MySQL has a very handy ability to track slow queries. For more info please visit http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html

Also there is a simple program called MySQL Proxy that can monitor, analyze or transform communication between application and server. Please go here to get more info.

And it’s useful to know about MySQL Profiles. Here is an article “Using the new MySQL Query Profiler

Advertisements
Explore posts in the same categories: Performance testing

Tags: , , , , ,

You can comment below, or link to this permanent URL from your own site.

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: