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 | 4701040608 | 3 | 4701040608 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 4805971632 | 0 | 0 | 0 | 5 | 36151632 | |
sakila | film | 2522704272 | 78 | 2522704272 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1604275200 | 0 | 0 | 0 | 5 | 1384291392 | |
sakila | actor | 2242673136 | 26 | 2242673136 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 910440432 | 0 | 0 | 0 | 5 | 1549029504 | |
sakila | category | 1808657136 | 2 | 1808657136 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1668137856 | 0 | 0 | 0 | 5 | 42254256 | |
sakila | language | 1398530496 | 75 | 1398530496 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 876984768 | 0 | 0 | 0 | 5 | 65496288 | |
sakila | country | 1104977280 | 54 | 1104977280 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1014656544 | 0 | 0 | 0 | 5 | 89872992 | |
sakila | city | 930922608 | 29 | 930922608 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 791068608 | 0 | 0 | 0 | 5 | 38758368 | |
Table_insertion | voiture | 852582720 | 2 | 852582720 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 810616752 | 0 | 0 | 0 | 5 | 301870800 | |
sakila | customer | 615924672 | 3 | 615924672 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 744254544 | 0 | 0 | 0 | 5 | 23938464 | |
sakila | address | 553778016 | 5 | 553778016 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 757886448 | 0 | 0 | 0 | 5 | 26253216 | |
world | CountryLanguage | 27007728 | 2 | 27007728 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 407 | 545049648 | 0 | 0 | 0 | 4 | 32173680 | |
Table_insertion | rallye | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1100422752 | 0 | 0 | 0 | 5 | 44007216 | |
Table_insertion | RK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 820710528 | 0 | 0 | 0 | 5 | 37106256 | |
pw | credenciales | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 932935872 | 0 | 0 | 0 | 5 | 36372336 | |
pw | estudio | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1124544432 | 0 | 0 | 0 | 5 | 46674144 | |
Table_insertion | cours | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1455517008 | 0 | 0 | 0 | 5 | 43020912 | |
mysql | routines | 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 | global_variables | 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 | |
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_io_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 | |
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 |
|