1set @save_use_stat_tables= @@use_stat_tables; 2set @save_optimizer_use_condition_selectivity=@@optimizer_use_condition_selectivity; 3set @@optimizer_use_condition_selectivity=1; 4set @@use_stat_tables= NEVER; 5set @@session.max_heap_table_size=16*1024*1024; 6create table t1 select * from information_schema.session_status where variable_name like 'Opened%'; 7create temporary table t2 (a int) engine=memory; 8select variable_name, session_status.variable_value - t1.variable_value 9from information_schema.session_status join t1 using (variable_name); 10variable_name session_status.variable_value - t1.variable_value 11OPENED_FILES 0 12OPENED_PLUGIN_LIBRARIES 0 13OPENED_TABLE_DEFINITIONS 2 14OPENED_TABLES 1 15OPENED_VIEWS 0 16truncate table t2; 17select variable_name, session_status.variable_value - t1.variable_value 18from information_schema.session_status join t1 using (variable_name); 19variable_name session_status.variable_value - t1.variable_value 20OPENED_FILES 0 21OPENED_PLUGIN_LIBRARIES 0 22OPENED_TABLE_DEFINITIONS 2 23OPENED_TABLES 1 24OPENED_VIEWS 0 25set @@use_stat_tables= @save_use_stat_tables; 26set @@optimizer_use_condition_selectivity=@save_optimizer_use_condition_selectivity; 27drop table t1; 28