Syntax statement
BENCHMARK(count,expr)
Description
The BENCHMARK() function repeatedly executes the expression expr for count times and returns 0. It returns NULL for inappropriate parameters, such as a NULL value or a negative count.
expr must be a scalar expression. BENCHMARK() can be used to measure the performance of scalar expressions. The reported runtime is the client-side execution time, not the server-side CPU time.
Examples
obclient> SELECT BENCHMARK(100,AES_ENCRYPT('hello','world'));
+---------------------------------------------+
| BENCHMARK(100,AES_ENCRYPT('hello','world')) |
+---------------------------------------------+
| 0 |
+---------------------------------------------+