CODEWITHSUNDEEP
mysqlbashshell
Danosaure
Danosaure

Reputation: 3655

MySQL statistics output

I have a SQL file with temporary tables creation, some load data infile, some selects and some updates.

I would like to know the time spent on each statement, through the CLI on the shell. If my file contains:

SELECT "Step 1" AS '';
SELECT col1, col2 FROM t1 ORDER BY col3;

And I run:

mysql -h host db < file

The output I would like to get is:

Step 1
1 row in set (0.00 sec)
col1 col2
20073 0724081
20073 0724685
20073 0726347
20073 0726932
20073 0733623
5 rows in set (0.00 sec)

Tne 1 row in set (0.00 sec) and 5 rows in set (0.00 sec) are the information i'm looking for, NOT the Un*x time for the process.

I've tryied different mysql options, even --show-warnings --i-am-a-dummy to no avail. Is there a way to get the requested info?

Thanks,

EDIT: Added missing time for first select.

Upvotes: 0

Views: 352

Answers (2)

Luke Peterson
Luke Peterson

Reputation: 8871

My guess is you are losing the timing data due to rounding. (eg, your query is taking A LOT less than 0.001 seconds.

Upvotes: 0

ajreal
ajreal

Reputation: 47321

try mysql profiler - http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html

Upvotes: 1

Related Questions