diff options
Diffstat (limited to 'mysql-test/suite/innodb/t/innodb-analyze.test')
| -rw-r--r-- | mysql-test/suite/innodb/t/innodb-analyze.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/suite/innodb/t/innodb-analyze.test b/mysql-test/suite/innodb/t/innodb-analyze.test index 32eef7e742c..9bdb9db697c 100644 --- a/mysql-test/suite/innodb/t/innodb-analyze.test +++ b/mysql-test/suite/innodb/t/innodb-analyze.test @@ -11,6 +11,7 @@ -- disable_result_log -- enable_warnings +let $sample_pages=`select @@innodb_stats_sample_pages`; SET GLOBAL innodb_stats_sample_pages=0; # check that the value has been adjusted to 1 @@ -61,5 +62,4 @@ SET GLOBAL innodb_stats_sample_pages=16; ANALYZE TABLE innodb_analyze; DROP TABLE innodb_analyze; - -SET GLOBAL innodb_stats_sample_pages=DEFAULT; +EVAL SET GLOBAL innodb_stats_sample_pages=$sample_pages; |