'How to check MySQL query time like "SHOW profiles" on "Source Distribution"?

I tried to check the time the queries take and tried in phpMyAdmin

SET profiling = 1

did some queries and then

SHOW profiles

but there were no results.

Then I found here http://dev.mysql.com/doc/refman/5.0/en/show-profile.html riiight at the bottom, that only the "Community Server" version is supported with this command.

I am using Mamp and have a 5.5.29 "Source Distribution" version.

How can I get ALL query times in the phpMyAdmin console? (I mean, I cannot alter the php code in every place.) Thanks!!

Edit
Found this here of how to evolve on command line and be sure to have the mysql> of MAMPand not the OS X one.

mysqlphpmyadmin


Solution 1:[1]

In phpMyAdmin, when you have the results of a query, just tick the "Profiling" checkbox; the profiling results and chart will show up. Works fine in a source distribution too.

Solution 2:[2]

I have faced the same issue of my profile not showing my actual executed queries. Here is what I have got and it worked like a charm for me.

You might need to login to the MySQL console from the below path F:\wamp64\bin\mysql\mysql8.0.27\bin - This is my folder you can select your path

Here open the cmd line and login to your MySQL console using the below command

mysql -u root[your username] -p

enter password hit enter

You are now login to MySQL, now select the database in which you have to execute the query. Once you execute the query fire the query show profiles; You will get your last executed query in the table with time and all.

Oops, one step we forget to mention that before doing this please enable profiling in MySQL. You can do that from here https://prnt.sc/XprPxgRlP1Jp

Hope this may help you out.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Marc Delisle
Solution 2 Atmiya Kolsawala

Related Questions