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 | staff | 51126719952 | 2 | 51126719952 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4784744448 | 0 | 0 | 0 | 5 | 57428448 | |
sakila | film | 2990527056 | 78 | 2990527056 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4312243056 | 0 | 0 | 0 | 5 | 40865616 | |
sakila | inventory | 2883151392 | 26 | 2883151392 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4284044688 | 0 | 0 | 0 | 5 | 40939008 | |
sakila | city | 2515704048 | 26 | 2515704048 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 2603767584 | 0 | 0 | 0 | 5 | 33691680 | |
sakila | store | 2265168048 | 3 | 2265168048 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2400590544 | 0 | 0 | 0 | 5 | 41725728 | |
sys | sys_config | 2149593600 | 22 | 2149593600 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1851136320 | 0 | 0 | 0 | 5 | 63938160 | |
sakila | country | 2065146336 | 129 | 2065146336 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1721481168 | 0 | 0 | 0 | 5 | 156399408 | |
sakila | address | 1193888784 | 2 | 1193888784 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1333089648 | 0 | 0 | 0 | 5 | 33634128 | |
sakila | language | 939397536 | 50 | 939397536 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 688673040 | 0 | 0 | 0 | 5 | 64827312 | |
db_pkl | pembimbing | 771334080 | 47 | 715046640 | 3 | 56287440 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 133358016 | 7 | 58912324944 | |
db_pkl | siswa | 206853504 | 11 | 91502400 | 8 | 115351104 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 182523264 | 7 | 75234290208 | |
krina098 | client_mstr | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 106499712 | 6 | 56853777552 | |
performance_schema | session_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
jay096 | Product_mstr | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 105644352 | 6 | 95656345488 | |
mysql | routines | 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 | 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_current | 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 | |
mysql | index_stats | 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 | column_statistics | 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 | |
mysql | catalogs | 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 |
|