MariaDB [test]> set statement min_examined_row_limit = 50 for select sleep(0.1) union select sleep(0.1);
|
+------------+
|
| sleep(0.1) |
|
+------------+
|
| 0 |
|
+------------+
|
1 row in set (0.27 sec)
|
|
MariaDB [test]> select * from mysql.slow_log;
|
+----------------------------+------------------------------+-----------------+-----------------+-----------+---------------+------+----------------+-----------+-----------+-----------------------------------------------------------------------------------------+-----------+
|
| start_time | user_host | query_time | lock_time | rows_sent | rows_examined | db | last_insert_id | insert_id | server_id | sql_text | thread_id |
|
+----------------------------+------------------------------+-----------------+-----------------+-----------+---------------+------+----------------+-----------+-----------+-----------------------------------------------------------------------------------------+-----------+
|
| 2014-11-02 13:48:49.526899 | root[root] @ localhost [::1] | 00:00:00.000089 | 00:00:00.000000 | 0 | 0 | test | 0 | 0 | 2 | set long_query_time = 0.000001 | 5 |
|
| 2014-11-02 13:48:49.790968 | root[root] @ localhost [::1] | 00:00:00.201339 | 00:00:00.000000 | 1 | 1 | test | 0 | 0 | 2 | set statement min_examined_row_limit = 50 for select sleep(0.1) union select sleep(0.1) | 5 |
|
+----------------------------+------------------------------+-----------------+-----------------+-----------+---------------+------+----------------+-----------+-----------+-----------------------------------------------------------------------------------------+-----------+
|
2 rows in set (0.00 sec)
|
|
MariaDB [test]> set min_examined_row_limit = 50;
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [test]> select sleep(0.1) union select sleep(0.1);
|
+------------+
|
| sleep(0.1) |
|
+------------+
|
| 0 |
|
+------------+
|
1 row in set (0.20 sec)
|
|
MariaDB [test]> select * from mysql.slow_log;
|
+----------------------------+------------------------------+-----------------+-----------------+-----------+---------------+------+----------------+-----------+-----------+-----------------------------------------------------------------------------------------+-----------+
|
| start_time | user_host | query_time | lock_time | rows_sent | rows_examined | db | last_insert_id | insert_id | server_id | sql_text | thread_id |
|
+----------------------------+------------------------------+-----------------+-----------------+-----------+---------------+------+----------------+-----------+-----------+-----------------------------------------------------------------------------------------+-----------+
|
| 2014-11-02 13:48:49.526899 | root[root] @ localhost [::1] | 00:00:00.000089 | 00:00:00.000000 | 0 | 0 | test | 0 | 0 | 2 | set long_query_time = 0.000001 | 5 |
|
| 2014-11-02 13:48:49.790968 | root[root] @ localhost [::1] | 00:00:00.201339 | 00:00:00.000000 | 1 | 1 | test | 0 | 0 | 2 | set statement min_examined_row_limit = 50 for select sleep(0.1) union select sleep(0.1) | 5 |
|
| 2014-11-02 13:48:49.793186 | root[root] @ localhost [::1] | 00:00:00.000394 | 00:00:00.000112 | 2 | 2 | test | 0 | 0 | 2 | select * from mysql.slow_log | 5 |
|
+----------------------------+------------------------------+-----------------+-----------------+-----------+---------------+------+----------------+-----------+-----------+-----------------------------------------------------------------------------------------+-----------+
|
3 rows in set (0.00 sec)
|