用于EagleEye3.0 规则集漏报和误报测试的示例项目,项目收集于github和gitee
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 

45 lines
1.1 KiB

SET @old_log_output= @@global.log_output;
SET @old_slow_query_log= @@global.slow_query_log;
SET @old_slow_query_log_file= @@global.slow_query_log_file;
SET GLOBAL slow_query_log_file= '.../log/slow_query_temp.log';
SET GLOBAL log_output= 'FILE';
SET GLOBAL slow_query_log= 'ON';
SET SESSION long_query_time= 0;
SHOW VARIABLES LIKE "%long_query_time%";
Variable_name Value
long_query_time 0.000000
SHOW VARIABLES LIKE "%long_query_time%";
Variable_name Value
long_query_time 0.000000
SHOW VARIABLES LIKE "%long_query_time%";
Variable_name Value
long_query_time 0.000000
SHOW VARIABLES LIKE "%long_query_time%";
Variable_name Value
long_query_time 0.000000
SHOW VARIABLES LIKE "%long_query_time%";
Variable_name Value
long_query_time 0.000000
SELECT 1;
1
1
SELECT 1;
1
1
SELECT 1;
1
1
SELECT 1;
1
1
"Running mysqldumpslow on the slow-query-log"
Count: 5 SHOW VARIABLES LIKE "%long_query_time%"
Count: 4 SELECT 1
Count: 1 SET SESSION long_query_time= 0
SET GLOBAL log_output= @old_log_output;
SET GLOBAL slow_query_log= @old_slow_query_log;
SET GLOBAL slow_query_log_file=@old_slow_query_log_file;
End of test!