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 | 298149457584 | 330000 | 298149457584 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 892396032 | 0 | 0 | 0 | 5 | 26513520 | |
sakila | film | 150497681664 | 308204 | 150497681664 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2580078864 | 0 | 0 | 0 | 5 | 30611856 | |
sakila | city | 67191516480 | 83 | 67191516480 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 65423581872 | 0 | 0 | 0 | 5 | 1439533920 | |
sakila | film_actor | 59560656144 | 330400 | 59560656144 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1656542448 | 0 | 0 | 0 | 5 | 20637936 | |
sakila | category | 5765637504 | 10270 | 5765637504 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 793296768 | 0 | 0 | 0 | 5 | 17608800 | |
vedettfak | megye | 4433606496 | 37 | 4433606496 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2428061328 | 0 | 0 | 0 | 5 | 1915877040 | |
sakila | staff | 4300624944 | 32 | 4300624944 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4249118016 | 0 | 0 | 0 | 5 | 46488816 | |
vedettfak | fa | 3142796448 | 26 | 3142796448 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 4188843648 | 0 | 0 | 0 | 5 | 39337584 | |
sakila | customer | 1714176288 | 25 | 1714176288 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1564373184 | 0 | 0 | 0 | 5 | 51801024 | |
sakila | rental | 1517912880 | 26 | 1517912880 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 16898393952 | 0 | 0 | 0 | 5 | 39416256 | |
sakila | country | 1468304112 | 82 | 1468304112 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1084593840 | 0 | 0 | 0 | 5 | 71566704 | |
sakila | language | 1229262144 | 50 | 1229262144 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1026864960 | 0 | 0 | 0 | 5 | 63767088 | |
sakila | address | 1207257216 | 32 | 1207257216 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1931739216 | 0 | 0 | 0 | 5 | 39299040 | |
sakila | actor | 891442992 | 400 | 891442992 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 949818144 | 0 | 0 | 0 | 5 | 35302080 | |
performance_schema | file_summary_by_instance | 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 | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_transactions_summary_by_user_by_event_name | 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 | routines | 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 | 1225922016 | 0 | 0 | 0 | 4 | 435105792 | |
performance_schema | status_by_thread | 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_transactions_summary_by_host_by_event_name | 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 |
|