diff options
Diffstat (limited to 'mysql-test/suite/perfschema/include/table_aggregate_setup.inc')
-rw-r--r-- | mysql-test/suite/perfschema/include/table_aggregate_setup.inc | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/mysql-test/suite/perfschema/include/table_aggregate_setup.inc b/mysql-test/suite/perfschema/include/table_aggregate_setup.inc index 79aa5482838..79f7bd70a3f 100644 --- a/mysql-test/suite/perfschema/include/table_aggregate_setup.inc +++ b/mysql-test/suite/perfschema/include/table_aggregate_setup.inc @@ -222,7 +222,9 @@ prepare dump_waits_global from order by event_name;"; prepare dump_waits_history from - "select event_name, count(event_name), object_type, object_schema, object_name + "select event_name, + sum(if(number_of_bytes is null, 1, number_of_bytes)) as 'count(event_name)', + object_type, object_schema, object_name from performance_schema.events_waits_history_long where event_name in (\'wait/io/table/sql/handler\', @@ -254,7 +256,7 @@ prepare dump_waits_table_lock from count_read_normal, count_read_with_shared_locks, count_read_high_priority, count_read_no_insert, count_read_external, - count_write_delayed, count_write_low_priority, + count_write_low_priority, count_write_external from performance_schema.table_lock_waits_summary_by_table where object_type='TABLE' and object_schema='test' |