Is there a way/tool to test an SQL query without executing it?

David Makogon · Oct 6, 2016

I found slow queries in slow-query-log file on my hosting and knew where they came on my website cms. I did a search for this on Google search and they showed tutorials on how to fix the problem but the tool or way they used to check with their queries then I don't know.

This is which I mean.

I want to run the SQL query and know how much time will it get? how can I do that without executing it directly on my website cms?

Thanks in advance.
David

UWH-David · Oct 6, 2016

David Makogon said:
I found slow queries in slow-query-log file on my hosting and knew where they came on my website cms. I did a search for this on Google search and they showed tutorials on how to fix the problem but the tool or way they used to check with their queries then I don't know.

This is which I mean.

View attachment 1738

I want to run the SQL query and know how much time will it get? how can I do that without executing it directly on my website cms?

Thanks in advance.
David

Hmmm, I think the profilings command might accomplish this. From a stackoverflow entry:

Code:

mysql> set profiling=1;
mysql> select count(*) from comment;
mysql> select count(*) from message;
mysql> show profiles;

+----------+------------+------------------------------+
| Query_ID | Duration   | Query                        |
+----------+------------+------------------------------+
|        1 | 0.00012700 | select count(*) from comment |
|        2 | 0.00014200 | select count(*) from message |
+----------+------------+------------------------------+
2 rows in set (0.00 sec)

Another thing you can do if you have slow query logging enabled is run the following command for a break down :

Code:

mysqldumpslow -s c -t 10

Is there a way/tool to test an SQL query without executing it?

David Makogon

Member

UWH-David

Member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud