Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
N/A
-
None
Description
Note: it's all the same in Percona server, but I won't file a bug for Percona, because there the whole 'profiling' logic is deprecated, as it is in MySQL 5.6. In MariaDB 10.1 it's still not deprecated, so it should work.
|
Session profiling is OFF |
MariaDB [test]> set profiling = 0; |
Query OK, 0 rows affected (0.01 sec) |
|
|
MariaDB [test]> select 'without profiling'; |
+-------------------+ |
| without profiling |
|
+-------------------+ |
| without profiling |
|
+-------------------+ |
1 row in set (0.00 sec) |
|
|
MariaDB [test]> set statement profiling=1 for select 'with one-statement profiling'; |
+------------------------------+ |
| with one-statement profiling | |
+------------------------------+ |
| with one-statement profiling | |
+------------------------------+ |
1 row in set (0.00 sec) |
|
|
MariaDB [test]> show profiles;
|
Empty set (0.00 sec) |
|
Session profiling is ON |
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) |
commit e64f5d8f758bcc1a8856ba9fba01780533f80747
|
Author: Oleksandr Byelkin <sanja@mariadb.com>
|
Date: Sun Oct 26 16:27:54 2014 +0100
|
|
|
Fixed test suite global variable saving
|
