diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/t/innodb_max_dirty_pages_pct_func.test')
-rw-r--r-- | mysql-test/suite/sys_vars/t/innodb_max_dirty_pages_pct_func.test | 17 |
1 files changed, 10 insertions, 7 deletions
diff --git a/mysql-test/suite/sys_vars/t/innodb_max_dirty_pages_pct_func.test b/mysql-test/suite/sys_vars/t/innodb_max_dirty_pages_pct_func.test index c7a9e567e69..0720aca65b9 100644 --- a/mysql-test/suite/sys_vars/t/innodb_max_dirty_pages_pct_func.test +++ b/mysql-test/suite/sys_vars/t/innodb_max_dirty_pages_pct_func.test @@ -25,6 +25,7 @@ --source include/have_innodb.inc # safe initial value +SET @innodb_max_dirty_pages_pct_lwm = @@global.innodb_max_dirty_pages_pct_lwm; SET @innodb_max_dirty_pages_pct = @@global.innodb_max_dirty_pages_pct; --echo '#--------------------FN_DYNVARS_044_02-------------------------#' @@ -32,23 +33,19 @@ SET @innodb_max_dirty_pages_pct = @@global.innodb_max_dirty_pages_pct; # Check if setting innodb_max_dirty_pages_pct is changed in new connection # ############################################################################ +SET @@global.innodb_max_dirty_pages_pct_lwm = 0; SET @@global.innodb_max_dirty_pages_pct = 80; ---echo 'connect (con1,localhost,root,,,,)' +SET @@global.innodb_max_dirty_pages_pct_lwm = 80; connect (con1,localhost,root,,,,); ---echo 'connection con1' connection con1; SELECT @@global.innodb_max_dirty_pages_pct; SET @@global.innodb_max_dirty_pages_pct = 70; ---echo 'connect (con2,localhost,root,,,,)' +SELECT @@global.innodb_max_dirty_pages_pct_lwm; connect (con2,localhost,root,,,,); ---echo 'connection con2' connection con2; SELECT @@global.innodb_max_dirty_pages_pct; ---echo 'connection default' connection default; ---echo 'disconnect con2' disconnect con2; ---echo 'disconnect con1' disconnect con1; # restore initial value SET @@global.innodb_max_dirty_pages_pct = @innodb_max_dirty_pages_pct; @@ -138,6 +135,10 @@ b CHAR(200) #========================================================== SET @@global.innodb_max_dirty_pages_pct = 10; +SELECT @@global.innodb_max_dirty_pages_pct_lwm; +SET GLOBAL innodb_max_dirty_pages_pct_lwm = 15; +SELECT @@global.innodb_max_dirty_pages_pct_lwm; +SELECT @@global.innodb_max_dirty_pages_pct; FLUSH STATUS; @@ -164,7 +165,9 @@ DROP FUNCTION dirty_pct; DROP TABLE t1; # restore initial value +SET GLOBAL innodb_max_dirty_pages_pct_lwm = 0; SET @@global.innodb_max_dirty_pages_pct = @innodb_max_dirty_pages_pct; +SET @@global.innodb_max_dirty_pages_pct_lwm = @innodb_max_dirty_pages_pct_lwm; ################################################################## # End of functionality Testing for innodb_max_dirty_pages_pct # |