diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/monitor.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/monitor.result | 95 |
1 files changed, 60 insertions, 35 deletions
diff --git a/mysql-test/suite/innodb/r/monitor.result b/mysql-test/suite/innodb/r/monitor.result index 4aea9fb5b0b..d6784a71299 100644 --- a/mysql-test/suite/innodb/r/monitor.result +++ b/mysql-test/suite/innodb/r/monitor.result @@ -1,5 +1,6 @@ set global innodb_monitor_disable = All; -select name, status from information_schema.innodb_metrics; +select name, if(enabled,'enabled','disabled') status +from information_schema.innodb_metrics; name status metadata_table_handles_opened disabled metadata_table_handles_closed disabled @@ -252,22 +253,23 @@ icp_no_match disabled icp_out_of_range disabled icp_match disabled set global innodb_monitor_enable = all; -select name from information_schema.innodb_metrics where status!='enabled'; +select name from information_schema.innodb_metrics where not enabled; name set global innodb_monitor_enable = aaa; ERROR 42000: Variable 'innodb_monitor_enable' can't be set to the value of 'aaa' set global innodb_monitor_disable = All; -select name from information_schema.innodb_metrics where status!='disabled'; +select name from information_schema.innodb_metrics where enabled; name set global innodb_monitor_reset_all = all; select name from information_schema.innodb_metrics where count!=0; name set global innodb_monitor_enable = "%lock%"; select name from information_schema.innodb_metrics -where status != IF(name like "%lock%", 'enabled', 'disabled'); +where enabled != (name like "%lock%"); name set global innodb_monitor_disable = "%lock%"; -select name, status from information_schema.innodb_metrics +select name, if(enabled,'enabled','disabled') status +from information_schema.innodb_metrics where name like "%lock%"; name status lock_deadlocks disabled @@ -298,24 +300,25 @@ innodb_rwlock_sx_os_waits disabled set global innodb_monitor_enable = "%lock*"; ERROR 42000: Variable 'innodb_monitor_enable' can't be set to the value of '%lock*' set global innodb_monitor_enable="%%%%%%%%%%%%%%%%%%%%%%%%%%%"; -select name from information_schema.innodb_metrics where status!='enabled'; +select name from information_schema.innodb_metrics where not enabled; name set global innodb_monitor_disable="%%%%%"; -select name from information_schema.innodb_metrics where status!='disabled'; +select name from information_schema.innodb_metrics where enabled; name set global innodb_monitor_enable="%"; -select name from information_schema.innodb_metrics where status!='enabled'; +select name from information_schema.innodb_metrics where not enabled; name set global innodb_monitor_disable="%_%"; -select name from information_schema.innodb_metrics where status!='disabled'; +select name from information_schema.innodb_metrics where enabled; name set global innodb_monitor_enable="log%%%%"; select name from information_schema.innodb_metrics -where status != IF(name like "log%", 'enabled', 'disabled'); +where enabled != (name like "log%"); name set global innodb_monitor_enable="os_%a_fs_ncs"; set global innodb_monitor_enable="os%pending%"; -select name, status from information_schema.innodb_metrics +select name, if(enabled,'enabled','disabled') status +from information_schema.innodb_metrics where name like "os%"; name status os_data_reads disabled @@ -338,14 +341,16 @@ create table monitor_test(col int) engine = innodb; select * from monitor_test; col select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name = "metadata_table_handles_opened"; name max_count min_count count max_count_reset min_count_reset count_reset status metadata_table_handles_opened 1 NULL 1 1 NULL 1 enabled set global innodb_monitor_reset = metadata_table_handles_opened; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name = "metadata_table_handles_opened"; name max_count min_count count max_count_reset min_count_reset count_reset status @@ -355,14 +360,16 @@ create table monitor_test(col int) engine = innodb; select * from monitor_test; col select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name = "metadata_table_handles_opened"; name max_count min_count count max_count_reset min_count_reset count_reset status metadata_table_handles_opened 2 NULL 2 1 NULL 1 enabled set global innodb_monitor_reset_all = metadata_table_handles_opened; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name = "metadata_table_handles_opened"; name max_count min_count count max_count_reset min_count_reset count_reset status @@ -370,7 +377,8 @@ metadata_table_handles_opened 2 NULL 2 1 NULL 1 enabled set global innodb_monitor_disable = metadata_table_handles_opened; set global innodb_monitor_reset = metadata_table_handles_opened; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name = "metadata_table_handles_opened"; name max_count min_count count max_count_reset min_count_reset count_reset status @@ -380,14 +388,16 @@ create table monitor_test(col int) engine = innodb; select * from monitor_test; col select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name = "metadata_table_handles_opened"; name max_count min_count count max_count_reset min_count_reset count_reset status metadata_table_handles_opened 2 NULL 2 NULL NULL 0 disabled set global innodb_monitor_reset_all = metadata_table_handles_opened; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name = "metadata_table_handles_opened"; name max_count min_count count max_count_reset min_count_reset count_reset status @@ -398,7 +408,8 @@ create table monitor_test(col int) engine = innodb stats_persistent=0; select * from monitor_test; col select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name = "metadata_table_handles_opened"; name max_count min_count count max_count_reset min_count_reset count_reset status @@ -406,32 +417,36 @@ metadata_table_handles_opened 1 NULL 1 1 NULL 1 enabled set global innodb_monitor_enable = metadata_table_handles_closed; create index idx on monitor_test(col); select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name = "metadata_table_handles_closed"; name max_count min_count count max_count_reset min_count_reset count_reset status metadata_table_handles_closed 1 NULL 1 1 NULL 1 enabled select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name like "metadata%"; name max_count min_count count max_count_reset min_count_reset count_reset status -metadata_table_handles_opened 2 NULL 2 2 NULL 2 enabled +metadata_table_handles_opened 1 NULL 1 1 NULL 1 enabled metadata_table_handles_closed 1 NULL 1 1 NULL 1 enabled metadata_table_reference_count NULL NULL 0 NULL NULL 0 disabled set global innodb_monitor_disable = module_metadata; set global innodb_monitor_reset = module_metadata; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name like "metadata%"; name max_count min_count count max_count_reset min_count_reset count_reset status -metadata_table_handles_opened 2 NULL 2 NULL NULL 0 disabled +metadata_table_handles_opened 1 NULL 1 NULL NULL 0 disabled metadata_table_handles_closed 1 NULL 1 NULL NULL 0 disabled metadata_table_reference_count NULL NULL 0 NULL NULL 0 disabled set global innodb_monitor_reset_all = module_metadata; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name like "metadata%"; name max_count min_count count max_count_reset min_count_reset count_reset status @@ -446,7 +461,8 @@ begin; insert into monitor_test values(9); rollback; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name like "trx_rollbacks" or name like "trx_active_transactions"; name max_count min_count count max_count_reset min_count_reset count_reset status @@ -457,7 +473,8 @@ set global innodb_monitor_enable = module_dml; insert into monitor_test values(9); update monitor_test set col = 10 where col = 9; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name like "dml%"; name max_count min_count count max_count_reset min_count_reset count_reset status @@ -471,7 +488,8 @@ dml_system_deletes 0 NULL 0 0 NULL 0 enabled dml_system_updates 0 NULL 0 0 NULL 0 enabled delete from monitor_test; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name like "dml%"; name max_count min_count count max_count_reset min_count_reset count_reset status @@ -485,7 +503,8 @@ dml_system_deletes 0 NULL 0 0 NULL 0 enabled dml_system_updates 0 NULL 0 0 NULL 0 enabled set global innodb_monitor_reset = module_dml; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name like "dml%"; name max_count min_count count max_count_reset min_count_reset count_reset status @@ -501,7 +520,8 @@ insert into monitor_test values(9); insert into monitor_test values(1); delete from monitor_test; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name like "dml%"; name max_count min_count count max_count_reset min_count_reset count_reset status @@ -515,7 +535,8 @@ dml_system_deletes 0 NULL 0 0 NULL 0 enabled dml_system_updates 0 NULL 0 0 NULL 0 enabled set global innodb_monitor_reset_all = module_dml; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name like "dml%"; name max_count min_count count max_count_reset min_count_reset count_reset status @@ -529,7 +550,8 @@ dml_system_deletes 0 NULL 0 0 NULL 0 enabled dml_system_updates 0 NULL 0 0 NULL 0 enabled set global innodb_monitor_disable = module_dml; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name like "dml%"; name max_count min_count count max_count_reset min_count_reset count_reset status @@ -543,7 +565,8 @@ dml_system_deletes 0 NULL 0 0 NULL 0 disabled dml_system_updates 0 NULL 0 0 NULL 0 disabled set global innodb_monitor_reset_all = module_dml; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name like "dml%"; name max_count min_count count max_count_reset min_count_reset count_reset status @@ -560,7 +583,8 @@ insert into monitor_test values(9); insert into monitor_test values(1); delete from monitor_test; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name like "dml%"; name max_count min_count count max_count_reset min_count_reset count_reset status @@ -576,7 +600,8 @@ set global innodb_monitor_disable = module_dml; drop table monitor_test; set global innodb_monitor_enable = file_num_open_files; select name, max_count, min_count, count, -max_count_reset, min_count_reset, count_reset, status +max_count_reset, min_count_reset, count_reset, +if(enabled,'enabled','disabled') status from information_schema.innodb_metrics where name like "file_num_open_files"; name max_count min_count count max_count_reset min_count_reset count_reset status |