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 | city | 4467721104 | 77 | 4467721104 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4205016816 | 0 | 0 | 0 | 5 | 99539088 | |
sakila | address | 3373642272 | 53 | 3373642272 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3866989632 | 0 | 0 | 0 | 5 | 52640544 | |
sakila | language | 2958005952 | 100 | 2958005952 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2243201664 | 0 | 0 | 0 | 5 | 51504816 | |
sakila | staff | 1523680752 | 3 | 1523680752 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1520007456 | 0 | 0 | 0 | 5 | 53228208 | |
sakila | film | 1349154048 | 104 | 1349154048 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1493810208 | 0 | 0 | 0 | 5 | 232726032 | |
sakila | inventory | 1178321760 | 2 | 1178321760 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1299238512 | 0 | 0 | 0 | 5 | 38896704 | |
sakila | country | 1024137312 | 76 | 1024137312 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 773881152 | 0 | 0 | 0 | 5 | 62885328 | |
sakila | customer | 1003325136 | 26 | 1003325136 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1521048672 | 0 | 0 | 0 | 5 | 45936528 | |
sys | sys_config | 654176688 | 7 | 654176688 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 804016224 | 0 | 0 | 0 | 5 | 46204224 | |
mysql | column_statistics | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | global_status | 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 | |
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 | table_lock_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | session_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Login | Login_details | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 222753168 | 6 | 83270034672 | |
mysql | table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | catalogs | 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 | events | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | slave_worker_info | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | slave_relay_log_info | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | slave_master_info | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | func | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|