Measuring actual MySQL query time

by

Start the profiler with 

SET profiling = 1;

Then execute your Query.

With

SHOW PROFILES;

you see a list of queries the profiler has statistics for. And finally you choose which query to examine with

SHOW PROFILE FOR QUERY 1;

or whatever number your query has.

What you get is a list where exactly how much time was spent during the query.

More info in the manual.

More Related Contents:

  1. MYSQL OR vs IN performance
  2. How do I add indexes to MySQL tables?
  3. Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)
  4. Storing JSON in database vs. having a new column for each key
  5. Does adding ‘LIMIT 1’ to MySQL queries make them faster when you know there will only be 1 result?
  6. a count for each join – optimisation
  7. Speeding up row counting in MySQL
  8. MySql views performance [closed]
  9. “SELECT COUNT(*)” is slow, even with where clause
  10. Optimization of MySQL search using “like” and wildcards
  11. Using index, using temporary, using filesort – how to fix this?
  12. Should I normalize my DB or not?
  13. How to speed up sql queries ? Indexes?
  14. Are table names in MySQL case sensitive?
  15. 1114 (HY000): The table is full
  16. Get table names using SELECT statement in MySQL
  17. UPDATE multiple tables in MySQL using LEFT JOIN
  18. How to raise an error within a MySQL function
  19. What is maximum query size for mysql?
  20. Finding all parents in mysql table with single query (Recursive Query)
  21. MySQL join query using like?
  22. MySql Query: Select top 3 rows from table for each category
  23. MySQL: How to select records for this week?
  24. Split a string and loop through values in MySQL stored procedure
  25. MySQL Select Query – Get only first 10 characters of a value
  26. Create an index on a huge MySQL production table without table locking
  27. MySQL concurrency, how does it work and do I need to handle it in my application
  28. mysql select id and name from other table and join query
  29. GRANT with database name wildcard in MySQL?
  30. Composite Primary Key performance drawback in MySQL

Leave a Comment