Benchmark SQL Query

perf stat -r 10 sh -c "mysql > /dev/null < query.sql"
Benchmark a SQL query against MySQL Server. The example runs the query 10 times, and you get the average runtime in the output. To ensure that the query does not get cached, use `RESET QUERY CACHE;` on top in the query file.
Sample Output
          8.244790      task-clock:u (msec)       #    0.033 CPUs utilized            ( +-  1.98% )
                 0      context-switches:u        #    0.000 K/sec                  
                 0      cpu-migrations:u          #    0.000 K/sec                  
               577      page-faults:u             #    0.070 M/sec                    ( +-  0.18% )
         8,363,454      cycles:u                  #    1.014 GHz                      ( +-  1.43% )
         8,053,164      stalled-cycles-frontend:u #   96.29% frontend cycles idle     ( +-  2.43% )
        12,952,085      instructions:u            #    1.55  insn per cycle         
                                                  #    0.62  stalled cycles per insn  ( +-  0.55% )
         2,835,964      branches:u                #  343.970 M/sec                    ( +-  0.73% )
            75,586      branch-misses:u           #    2.67% of all branches          ( +-  4.21% )

       0.247575641 seconds time elapsed                                          ( +- 28.79% )

1
2018-05-03 12:20:03

What Others Think

Wonderful! I have been facing the same kind of error while compiling my program. Thanks for correcting my mistake and teaching the new command for compiling the program successfully. One of my friends told me to click here to enjoy online games after competing this program. I have bookmarked this website to learn more commands in order to become a programmer.
HayleyRice · 49 weeks and 1 day ago
Consider what things from a general point of view attract you and what you love to do should be from an overall perspective idea to be going prior to picking any availability program. Visit http://www.copychecker.org/copy-plagiarism-checker-detection-copied-content/ for more details. consider what sort of calling course you plan on after and what your full scale work battles are.
Ahmed74 · 32 weeks and 2 days ago
A parent should be creative and as careful as could be depended resulting to thinking about the current condition to make learning an enchanting development for his youthfulness. Visit home for checking mistakes in work. He ought to guarantee that his young adult is learning while at the same time making some puzzle encounters.
Ahmed74 · 32 weeks and 2 days ago
?Close to pulling in the youths, enlightening toys can proportionately give meddles with some essential setting up that they will need in their school. Visit https://www.checkmysentence.com/how-to-check-sentence-grammar-online/ for getting wonderful info, you from a general point of view need to change your adolescents with such enlightening toys.?
Ahmed74 · 32 weeks and 2 days ago
Our religion urges us to learn new things. Click article for getting more info. Course is the essential wellspring of learning and looking at new things.
tinakutch · 27 weeks and 2 days ago
I'm amped up for exist close by the HPMP London victor gathering. Click https://www.punctuationapp.com/8-reasons-to-use-sentence-check-app-to-proofread-your-text/ for more info. These individuals were amazing all through the resistance. They have amazed me.
tinakutch · 27 weeks and 2 days ago

What do you think?

Any thoughts on this command? Does it work on your machine? Can you do the same thing with only 14 characters?

You must be signed in to comment.

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands



Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for: