Testing speed of mysql query

[FreebieGuy]

I have been seeing people posting about the speed of various mysql queries that they have and I'm curious how do I find the speed? Could someone show me an example?

[ptolemy]

I have been seeing people posting about the speed of various mysql queries that they have and I'm curious how do I find the speed? Could someone show me an example?

Searches for questions like this often reveal some insightful answers to questions. Here's what I found from google: http://www.phpbuilder.com/lists/php-...02062/0914.php

[FreebieGuy]

Thanks for pointing me to it.

[FreebieGuy]

Just wondering if the time returned for that article is returned in seconds.

[mmj]

If you have phpmyadmin, it's a reasonably good way to test a query. It tells you how long the query took, and it lets you turn a "select" into an "explain" and back so you can see what the query's doing. The only problem is that it always adds a "limit" clause which can affect the query's speed of operation.

[FreebieGuy]

"It tells you how long the query took"
Erm... which version of phpMyAdmin are you using? My webhost does not seem to state the execution time.

[mmj]

I'm running 2.5.5, but I'm pretty sure it's been a feature of phpmyadmin for a long time. When you do an SQL query.

[Son Nguyen]

You could download the latest phpMyAdmin and install it yourself, it should work even on shared hosting environment.
http://www.phpmyadmin.net/

As for the speed of query, it's very fast for most of the cases. To know the details on why it's slow, try use EXPLAIN query
http://www.mysql.com/doc/en/EXPLAIN.html

To have MySQL log slow queries, you could modify my.cnf
log-slow-queries=/var/log/mysqld.slow.log
long_query_time=5 (5 secs)