SELECT * FROM `x$schema_table_statistics`
|
table_schema | table_name | total_latency | rows_fetched | fetch_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency | io_read_requests | io_read | io_read_latency | io_write_requests | io_write | io_write_latency | io_misc_requests | io_misc_latency | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sakila | film_category | 48869220576 | 1125 | 48869220576 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 794439888 | 0 | 0 | 0 | 5 | 39934224 | |
sakila | category | 48577930896 | 40 | 48577930896 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 752438016 | 0 | 0 | 0 | 5 | 50520624 | |
sakila | film | 44183073264 | 1144 | 44183073264 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 43655416992 | 0 | 0 | 0 | 5 | 67390752 | |
sys | sys_config | 3444093312 | 2 | 3444093312 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1069292400 | 0 | 0 | 0 | 5 | 61676736 | |
sakila | customer | 1872828144 | 225 | 1872828144 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1731952992 | 0 | 0 | 0 | 5 | 43126512 | |
sakila | payment | 1507071984 | 29 | 1507071984 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 5462468352 | 0 | 0 | 0 | 5 | 258996144 | |
sakila | language | 1035261744 | 176 | 1035261744 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 606666720 | 0 | 0 | 0 | 5 | 39114240 | |
sakila | staff | 1031232048 | 35 | 1031232048 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 907977840 | 0 | 0 | 0 | 5 | 38244624 | |
sakila | rental | 938128752 | 200 | 938128752 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1133301312 | 0 | 0 | 0 | 5 | 48963552 | |
sakila | address | 808434528 | 2 | 808434528 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1030999728 | 0 | 0 | 0 | 5 | 36774672 | |
sakila | store | 790446624 | 3 | 790446624 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 881692944 | 0 | 0 | 0 | 5 | 34146816 | |
mysql | help_topic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | routines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameters | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameter_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | file_summary_by_instance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_category | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | general_log | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 35 | 170334384 | 0 | 0 | 0 | 4 | 8161312896 | |
test19 | speciale | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 65536 | 397119360 | 0 | 0 | 0 | 2 | 6719856 | |
performance_schema | table_lock_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | table_io_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_summary_by_digest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|