MariaDB [test]> set profiling = 1;
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [test]> select 'with profiling';
|
+----------------+
|
| with profiling |
|
+----------------+
|
| with profiling |
|
+----------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> set statement profiling=0 for select 'with one-statement profiling turned off';
|
+-----------------------------------------+
|
| with one-statement profiling turned off |
|
+-----------------------------------------+
|
| with one-statement profiling turned off |
|
+-----------------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> set profiling = 0;
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [test]> show profiles;
|
+----------+------------+--------------------------------------------------------------------------------+
|
| Query_ID | Duration | Query |
|
+----------+------------+--------------------------------------------------------------------------------+
|
| 1 | 0.00073110 | select 'with profiling' |
|
| 2 | 0.00060901 | set statement profiling=0 for select 'with one-statement profiling turned off' |
|
+----------+------------+--------------------------------------------------------------------------------+
|
2 rows in set (0.00 sec)
|