O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Benchmarking queries and the server

Suppose you want to find out which of the queries is faster. The explain plan gives you an idea, but sometimes you cannot decide based on it. You can execute them on the server and find which one is faster if the query time is in the order of tens of seconds. However, if the query time is in the order of a few milliseconds, you cannot decide based on a single execution.

You can use the mysqlslap utility (it comes along with MySQL-client installation), which emulates client load for a MySQL server and reports the timing of each stage. It works as if multiple clients are accessing the server. In this section, you will learn about the usage of mysqlslap; in later sections, you will learn about the power of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required