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 | 1075729811376 | 1320000 | 1075729811376 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1278319680 | 0 | 0 | 0 | 5 | 29751216 | |
sakila | film | 580268723232 | 1232711 | 580268723232 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2057103840 | 0 | 0 | 0 | 5 | 23365584 | |
sakila | film_actor | 212490775728 | 1321600 | 212490775728 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1899241872 | 0 | 0 | 0 | 5 | 18222864 | |
sakila | category | 19165592688 | 41080 | 19165592688 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1022334720 | 0 | 0 | 0 | 5 | 30495168 | |
vedettfak | megye | 3963580368 | 3 | 3963580368 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 973996848 | 0 | 0 | 0 | 5 | 3207097872 | |
apple | agent_table | 3358565760 | 184 | 1927291872 | 11 | 429608784 | 5 | 902522544 | 4 | 99142560 | 0 | 0 | 0 | 18 | 393216 | 11139656880 | 17 | 98614451760 | |
sakila | city | 2352413184 | 178 | 2352413184 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1461679296 | 0 | 0 | 0 | 5 | 51318960 | |
sys | sys_config | 2001935760 | 5 | 2001935760 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1162435296 | 0 | 0 | 0 | 5 | 996781632 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 1759572144 | 28 | 1759572144 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | country | 1574449536 | 101 | 1574449536 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1106337408 | 0 | 0 | 0 | 5 | 54796368 | |
db_stefani | mahasiswa | 1539548736 | 85 | 1112012880 | 5 | 427535856 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 397205424 | 9 | 97312063728 | |
sakila | address | 1245088416 | 106 | 1245088416 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2058714240 | 0 | 0 | 0 | 5 | 41827632 | |
sakila | rental | 1086090192 | 28 | 1086090192 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 9251110176 | 0 | 0 | 0 | 5 | 31957728 | |
sakila | inventory | 661278288 | 26 | 661278288 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2675191728 | 0 | 0 | 0 | 5 | 31058544 | |
sakila | actor | 650188176 | 1600 | 650188176 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1939657632 | 0 | 0 | 0 | 5 | 33309408 | |
sakila | language | 543204288 | 82 | 543204288 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 806009952 | 0 | 0 | 0 | 5 | 33615648 | |
world | Country | 483964272 | 29 | 483964272 | 0 | 0 | 0 | 0 | 0 | 0 | 28 | 7248 | 1149536256 | 0 | 0 | 0 | 7 | 43150800 | |
sakila | store | 356785968 | 3 | 356785968 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1174327440 | 0 | 0 | 0 | 5 | 21164352 | |
sakila | staff | 198985248 | 27 | 198985248 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1081248432 | 0 | 0 | 0 | 5 | 23983344 | |
sakila | customer | 178612368 | 25 | 178612368 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1733176368 | 0 | 0 | 0 | 5 | 24179232 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | schemata | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespace_files | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespaces | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | check_constraints | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|