1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
SET GLOBAL query_log_file="DRIZZLETEST_VARDIR/query.log";
SET GLOBAL query_log_file_enabled=TRUE;
SHOW VARIABLES LIKE 'query_log_threshold%';
Variable_name Value
query_log_threshold_execution_time 0
query_log_threshold_lock_time 0
query_log_threshold_rows_examined 0
query_log_threshold_rows_sent 0
query_log_threshold_session_time 0
query_log_threshold_tmp_tables 0
query_log_threshold_warnings 0
SET GLOBAL query_log_threshold_execution_time=500000;
SELECT @@query_log_threshold_execution_time;
@@query_log_threshold_execution_time
500000
SELECT SLEEP(0.4);
SLEEP(0.4)
0
SELECT SLEEP(0.5);
SLEEP(0.5)
0
Checking attributes and values of query SELECT SLEEP(0.5);
execution_time value between 0.5 and 0.59 OK
Checking attributes and values of query SELECT SLEEP(0.5);
arg value equals SELECT SLEEP(0.5); OK
# start_ts=0-00-00T00:00:00.000000
# session_id=0 query_id=0 rows_examined=0 rows_sent=0 tmp_tables=0 warnings=0
# execution_time=0.000000 lock_time=0.000000 session_time=0.000000
# error=false
# schema="test"
SELECT SLEEP(0.0);
#
SET GLOBAL query_log_file_enabled=FALSE;
SET GLOBAL query_log_file_enabled=TRUE;
SET GLOBAL query_log_threshold_execution_time=0;
SELECT @@query_log_threshold_execution_time;
@@query_log_threshold_execution_time
0
SELECT 'one';
one
one
Checking attributes and values of query SELECT 'one';
arg value equals SELECT 'one'; OK
# start_ts=0-00-00T00:00:00.000000
# session_id=0 query_id=0 rows_examined=0 rows_sent=0 tmp_tables=0 warnings=0
# execution_time=0.000000 lock_time=0.000000 session_time=0.000000
# error=false
# schema="test"
SELECT 'one';
#
|