kieranbarnes these are the things i learnt today

SQLyog Query Profiler

MySQL has always lacked the sophisticated profiling tools shipped with proprietary databases like SQL Server, etc. MySQL developers have largely depended on EXPLAIN for tuning queries. The SHOW PROFILE patch by Jeremy Cole was introduced in the MySQL Community version 5.0.37 and it provided much more insight into where the query spends its time. However, to take advantage of this feature, MySQL developers were supposed to switch on profiling, run their queries and then filter the profiling data from a table that contained the profiling results of the last few profiled queries. A lot of manual book-keeping is required to take advantage of this powerful feature. In an ideal situation, the MySQL developer should execute the queries and the profiling info should be available along with the result-set. Unfortunately, none of the MySQL client tools (desktop or web-based) provide intrinsic support for this feature.

Watch the Screencast on Query Profiler.

Related posts:

1. MySQL Tuning Server Parameters
   These are some of the handy MySQL 5.0 tweaks I do to get the most...
2. Yahoo Term Extractor
   A recent project I was working on cause me to stumble over the Yahoo Term...
3. CubeCart and Wordpress Integration
   Following my 100% CubeCart orientated posts, here's another late night hack. It integrates a Wordpress...
4. Crawl Rate Tracker and Wordpress 2.5 Manual Fix
   A quick update on people that need the Crawl Rate Tracker to work with Wordpress...
5. Really freakin’ simple mysql virtual hosting pure-ftpd
   This article will guide you through installing pure-ftpd configured for virtual hosts using mysql as...

What this article useful to you?

Let me know, buy me a beer!
Alternatively, if you're feeling impecunious, you may like to subscribe to my RSS feed, or see other articles in the MySQL, Windows category.