diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/t/delay_key_write_func.test')
-rw-r--r-- | mysql-test/suite/sys_vars/t/delay_key_write_func.test | 34 |
1 files changed, 20 insertions, 14 deletions
diff --git a/mysql-test/suite/sys_vars/t/delay_key_write_func.test b/mysql-test/suite/sys_vars/t/delay_key_write_func.test index 3c0319be427..a44b37653d2 100644 --- a/mysql-test/suite/sys_vars/t/delay_key_write_func.test +++ b/mysql-test/suite/sys_vars/t/delay_key_write_func.test @@ -14,16 +14,17 @@ # Description: Test Cases of Dynamic System Variable delay_key_write # # that checks the behavior of this variable # # # -# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # -# server-system-variables.html # +# Reference: # +# http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html # # # ############################################################################### --echo '#--------------------FN_DYNVARS_023_01-------------------------#' ####################################################################### -# Check if setting delay_key_write is changed in every new connection # +# Check if setting delay_key_write is changed in every new connection # ####################################################################### +SET @start_value= @@global.delay_key_write; SET @@global.delay_key_write = ON; SELECT @@global.delay_key_write; @@ -51,11 +52,11 @@ SELECT @@global.delay_key_write AS res_is_ALL; --disable_query_log DELIMITER //; CREATE PROCEDURE sp_addRecords (IN var1 INT,IN var2 INT) -BEGIN - WHILE (var1 < var2) DO - INSERT INTO t1 VALUES(var1,REPEAT('MYSQL',10),100000.0/var1); - SET var1=var1+1; - END WHILE; +BEGIN + WHILE (var1 < var2) DO + INSERT INTO t1 VALUES(var1,REPEAT('MYSQL',10),100000.0/var1); + SET var1=var1+1; + END WHILE; END// DELIMITER ;// --enable_query_log @@ -77,7 +78,7 @@ CREATE TABLE t1( a INT PRIMARY KEY, b VARCHAR(512), c DOUBLE -)delay_key_write = 1; +) DELAY_KEY_WRITE = 1; --enable_query_log @@ -88,7 +89,7 @@ CALL sp_addRecords(1,10); SHOW STATUS LIKE 'Key_reads'; SHOW STATUS LIKE 'Key_writes'; SHOW STATUS LIKE 'Key_write_requests'; -select count(*) from t1; +SELECT COUNT(*) FROM t1; #============================================================================== --echo '----check when delay_key_write is ON---' @@ -105,7 +106,7 @@ CREATE TABLE t1( a INT PRIMARY KEY, b VARCHAR(512), c DOUBLE -)delay_key_write = 1; +) DELAY_KEY_WRITE = 1; --enable_query_log FLUSH STATUS; @@ -114,7 +115,7 @@ CALL sp_addRecords(1,10); SHOW STATUS LIKE 'Key_reads'; SHOW STATUS LIKE 'Key_writes'; SHOW STATUS LIKE 'Key_write_requests'; -select count(*) from t1; +SELECT COUNT(*) FROM t1; #============================================================================== --echo '----check when delay_key_write is ALL---' @@ -130,7 +131,7 @@ CREATE TABLE t1( a INT PRIMARY KEY, b VARCHAR(512), c DOUBLE -)delay_key_write = 0; +) DELAY_KEY_WRITE = 0; --enable_query_log FLUSH STATUS; @@ -139,11 +140,16 @@ CALL sp_addRecords(1,10); SHOW STATUS LIKE 'Key_reads'; SHOW STATUS LIKE 'Key_writes'; SHOW STATUS LIKE 'Key_write_requests'; -select count(*) from t1; +SELECT COUNT(*) FROM t1; DROP PROCEDURE sp_addRecords; DROP TABLE t1; +disconnect user1; + +connection default; +SET @@global.delay_key_write= @start_value; #################################################### # End of functionality testing for delay_key_write # #################################################### + |