BENCHMARK

Syntax

BENCHMARK(count,expr)

Purpose

The BENCHMARK() function executes the scalar expression expr count times and returns 0. It returns NULL for inappropriate parameters, such as NULL values or a negative count.

expr must be a scalar expression. BENCHMARK() can be used to measure the performance of scalar expressions. The reported time is the client's runtime, not the server's CPU time.

Examples

obclient> SELECT BENCHMARK(100,AES_ENCRYPT('hello','world'));
+---------------------------------------------+
| BENCHMARK(100,AES_ENCRYPT('hello','world')) |
+---------------------------------------------+
|                                           0 |
+---------------------------------------------+