diff options
Diffstat (limited to 'mysql-test/main/fast_prefix_index_fetch_innodb.test')
-rw-r--r-- | mysql-test/main/fast_prefix_index_fetch_innodb.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/main/fast_prefix_index_fetch_innodb.test b/mysql-test/main/fast_prefix_index_fetch_innodb.test index 68d3dc0648d..52066e96117 100644 --- a/mysql-test/main/fast_prefix_index_fetch_innodb.test +++ b/mysql-test/main/fast_prefix_index_fetch_innodb.test @@ -5,6 +5,9 @@ SET @save_opt= @@GLOBAL.innodb_prefix_index_cluster_optimization; set global innodb_prefix_index_cluster_optimization = ON; show variables like 'innodb_prefix_index_cluster_optimization'; +SET @save_innodb_stats_persistent=@@GLOBAL.innodb_stats_persistent; +SET GLOBAL innodb_stats_persistent = OFF; + --echo # Create a table with a large varchar field that we index the prefix --echo # of and ensure we only trigger cluster lookups when we expect it. create table prefixinno ( @@ -718,4 +721,5 @@ AND path IN ( '/fondsinvesteringer/', '/' ); DROP TABLE wp_blogs; SET GLOBAL innodb_prefix_index_cluster_optimization = @save_opt; +SET GLOBAL innodb_stats_persistent = @save_innodb_stats_persistent; --enable_service_connection |