diff options
Diffstat (limited to 'storage/innobase/mysql-test/innodb-analyze.test')
| -rw-r--r-- | storage/innobase/mysql-test/innodb-analyze.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/storage/innobase/mysql-test/innodb-analyze.test b/storage/innobase/mysql-test/innodb-analyze.test index d5d6d698170..9bdb9db697c 100644 --- a/storage/innobase/mysql-test/innodb-analyze.test +++ b/storage/innobase/mysql-test/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,3 +62,4 @@ SET GLOBAL innodb_stats_sample_pages=16; ANALYZE TABLE innodb_analyze; DROP TABLE innodb_analyze; +EVAL SET GLOBAL innodb_stats_sample_pages=$sample_pages; |