diff options
Diffstat (limited to 'mysql-test/suite/percona/percona_query_response_time-stored.test')
| -rw-r--r-- | mysql-test/suite/percona/percona_query_response_time-stored.test | 42 |
1 files changed, 20 insertions, 22 deletions
diff --git a/mysql-test/suite/percona/percona_query_response_time-stored.test b/mysql-test/suite/percona/percona_query_response_time-stored.test index f761dd7d01c..e80fc3dd3c0 100644 --- a/mysql-test/suite/percona/percona_query_response_time-stored.test +++ b/mysql-test/suite/percona/percona_query_response_time-stored.test @@ -1,18 +1,14 @@ -source include/have_innodb.inc; +--source include/have_response_time_distribution.inc +--source include/have_debug.inc + +SET GLOBAL debug="d,query_exec_time_debug"; delimiter /; CREATE FUNCTION test_f() RETURNS CHAR(30) DETERMINISTIC BEGIN - DECLARE first VARCHAR(5); - DECLARE second VARCHAR(5); - DECLARE result VARCHAR(20); - SELECT SLEEP(1.11) INTO first; - SET first= 'Hello'; - SET second=', '; - SET result= CONCAT(first,second); - SET result= CONCAT(result,'world!'); - RETURN result; + SET SESSION debug="+d,query_exec_time_1.1"; + RETURN 'Hello, world!'; END/ delimiter ;/ @@ -24,12 +20,12 @@ SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; source include/percona_query_response_time_flush.inc; source include/percona_query_response_time_show.inc; -SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=1; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; SELECT test_f(); SELECT test_f(); SELECT test_f(); SELECT test_f(); -SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; source include/percona_query_response_time_show.inc; @@ -38,9 +34,9 @@ SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 10; SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; source include/percona_query_response_time_flush.inc; -SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=1; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; SELECT test_f(); -SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; source include/percona_query_response_time_show.inc; @@ -49,9 +45,9 @@ SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 7; SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; source include/percona_query_response_time_flush.inc; -SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=1; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; SELECT test_f(); -SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; source include/percona_query_response_time_show.inc; @@ -60,9 +56,9 @@ SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 156; SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; source include/percona_query_response_time_flush.inc; -SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=1; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; SELECT test_f(); -SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; source include/percona_query_response_time_show.inc; @@ -71,9 +67,9 @@ SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 1000; SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; source include/percona_query_response_time_flush.inc; -SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=1; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; SELECT test_f(); -SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; source include/percona_query_response_time_show.inc; @@ -81,7 +77,9 @@ SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 1001; SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; -SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE =10; -DROP FUNCTION test_f;
\ No newline at end of file +DROP FUNCTION test_f; + +SET GLOBAL debug=default; |