From the course: Learning phpMyAdmin

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Profiling and explaining queries

Profiling and explaining queries

From the course: Learning phpMyAdmin

Start my 1-month free trial

Profiling and explaining queries

- In chapter six we saw how to analyze the performance of queries using the phpMyAdmin console. However, you can run the same analysis in the Browse tab or after running a query. This is helpful if you're using an older version of phpMyAdmin that doesn't have the console, or if you find working in the console inconvenient. Let's browse the cars table in the up_and_running database by selecting it from the column on the left. At the top it says it's showing rows 0 - 24 of 35, and that's how long the query took. This one took only a few milliseconds, but if you've got a more complex query on a large database it could take considerably longer. To analyze how long each part of the query takes, select this Profiling checkbox under the SQL query. So if I select that, phpMyAdmin immediately runs the profile, the Detailed profile is shown on the left. This shows each state of the database in the order that it happened and Summary by state, on the right, shows the states in descending order of…

Contents