Mysql – Measure query execution time in bash

bashMySQLquerytime

I need to measure a query total execution time from inside a bash script.

Somebody told me to submit something like:

mysql --user="someuser" --password="pw" -D "dbname" -e 'your-sql-command;'

Is it right?

But how can I get the timing stats I need?

Best Answer

time

as in

tom.oconnor@charcoal-black:/tmp$ time ls -lah
total 20K
drwxrwxrwt 26 root        root    4.0K 2012-04-11 15:28 .
drwxr-xr-x 23 root        root    4.0K 2012-04-03 15:01 ..


real    0m0.003s
user    0m0.010s
sys     0m0.000s

Cool, huh?

From the time manpage

TIME(1)                                  TIME(1)

NAME
       time - run programs and summarize system resource usage

This:

date +%s

will return the number of seconds since the epoch.

This:

date +%s%N

returns the seconds and current nanoseconds.

So:

date +%s%N | cut -b1-13

will give you the number of milliseconds since the epoch - current seconds plus the left three of the nanoseconds.

and from MikeyB - echo $(($(date +%s%N)/1000000)) (dividing by 1000 only brings to microseconds)

Best Answer

Related Solutions

Bash Scripting – How to Determine if a Bash Variable is Empty

Bash – How to get the current Unix time in milliseconds in Bash

This:

This:

So:

Related Topic