| 1 |
# See related script table_io_setup_helper.inc |
| 2 |
|
| 3 |
# Stop table io recording |
| 4 |
update performance_schema.setup_consumers set enabled='NO'; |
| 5 |
--skip_if_hypergraph # Depends on query plan. |
| 6 |
eval select event_name, |
| 7 |
left(source, locate(":", source)) as short_source, |
| 8 |
object_type, object_schema, |
| 9 |
if (locate("#sql-", object_name), "#sql-XXXX", object_name) |
| 10 |
as pretty_name, |
| 11 |
operation, number_of_bytes |
| 12 |
from performance_schema.events_waits_history_long |
| 13 |
where event_name like 'wait/io/table/%' |
| 14 |
and object_schema in ($schema_to_dump) |
| 15 |
order by thread_id, event_id; |
| 16 |
|
| 17 |
# In case of failures, this will tell if table io are lost. |
| 18 |
show global status like 'performance_schema_%_lost'; |
| 19 |
|
| 20 |
# Cleanup |
| 21 |
truncate performance_schema.events_waits_history_long; |
| 22 |
flush status; |
| 23 |
|