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 | 8215625088 | 54 | 8215625088 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1115756400 | 0 | 0 | 0 | 5 | 45678864 | |
sakila | address | 5336310672 | 26 | 5336310672 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4900339488 | 0 | 0 | 0 | 5 | 53314800 | |
sakila | inventory | 2547961680 | 78 | 2547961680 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2706382800 | 0 | 0 | 0 | 5 | 74236272 | |
sakila | film | 2121306528 | 231 | 2121306528 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1806160752 | 0 | 0 | 0 | 5 | 39746256 | |
noob | ashish | 1659295968 | 88 | 1388380224 | 3 | 270915744 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 382206000 | 8 | 73948701024 | |
sakila | language | 1640706672 | 150 | 1640706672 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 743814192 | 0 | 0 | 0 | 5 | 40768992 | |
sakila | country | 1469813664 | 251 | 1469813664 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1294717776 | 0 | 0 | 0 | 5 | 56501808 | |
sakila | film_actor | 1041812640 | 2 | 1041812640 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 2787542736 | 0 | 0 | 0 | 5 | 33134112 | |
pelanggan | pelanggan | 701048832 | 36 | 479929824 | 3 | 221119008 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 134970000 | 7 | 74395545840 | |
sakila | actor | 425579088 | 559 | 425579088 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1042212336 | 0 | 0 | 0 | 5 | 44503008 | |
mysql | column_statistics | 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_summary_by_program | 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 | |
test19 | cours | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 755648784 | 0 | 0 | 0 | 5 | 40590528 | |
mysql | general_log | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 35 | 491765472 | 0 | 0 | 0 | 6 | 131569152 | |
performance_schema | events_stages_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_summary_by_digest | 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 | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_stages_summary_by_account_by_event_name | 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 | |
mysql | index_stats | 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 | events_statements_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|