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 | 804121219440 | 990000 | 804121219440 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1278319680 | 0 | 0 | 0 | 5 | 29751216 | |
sakila | film | 432567071904 | 924533 | 432567071904 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2057103840 | 0 | 0 | 0 | 5 | 23365584 | |
sakila | film_actor | 158513136672 | 991200 | 158513136672 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1899241872 | 0 | 0 | 0 | 5 | 18222864 | |
sakila | category | 13996065072 | 30810 | 13996065072 | 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 | |
sakila | city | 2352413184 | 178 | 2352413184 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1461679296 | 0 | 0 | 0 | 5 | 51318960 | |
apple | agent_table | 2144607696 | 142 | 1481736432 | 11 | 429608784 | 1 | 134119920 | 4 | 99142560 | 0 | 0 | 0 | 14 | 327680 | 11052939216 | 13 | 89030122896 | |
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 | 1460650224 | 80 | 1033114368 | 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 | 508275504 | 1200 | 508275504 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1939657632 | 0 | 0 | 0 | 5 | 33309408 | |
world | Country | 483964272 | 29 | 483964272 | 0 | 0 | 0 | 0 | 0 | 0 | 28 | 7248 | 1149536256 | 0 | 0 | 0 | 7 | 43150800 | |
sakila | language | 386748912 | 57 | 386748912 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 806009952 | 0 | 0 | 0 | 5 | 33615648 | |
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 |
|