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 | 301323266112 | 334064 | 301323266112 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 3050345760 | 0 | 0 | 0 | 5 | 26513520 | |
sakila | payment | 203812670160 | 64177 | 203812670160 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 12322670448 | 0 | 0 | 0 | 5 | 22037664 | |
sakila | film | 154278129456 | 312230 | 154278129456 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2580078864 | 0 | 0 | 0 | 5 | 30611856 | |
sakila | city | 67207642656 | 89 | 67207642656 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 65423581872 | 0 | 0 | 0 | 5 | 1439533920 | |
sakila | film_actor | 59560656144 | 330400 | 59560656144 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1656542448 | 0 | 0 | 0 | 5 | 20637936 | |
sakila | rental | 40610344368 | 82527 | 40610344368 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 22829128608 | 0 | 0 | 0 | 5 | 39416256 | |
sakila | inventory | 14894865744 | 22324 | 14894865744 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 3928723392 | 0 | 0 | 0 | 5 | 36256704 | |
vedettfak | megye | 6183725328 | 116 | 6183725328 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2428061328 | 0 | 0 | 0 | 5 | 1915877040 | |
sakila | category | 5872731216 | 10338 | 5872731216 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 793296768 | 0 | 0 | 0 | 5 | 17608800 | |
sakila | staff | 4347126432 | 40 | 4347126432 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4249118016 | 0 | 0 | 0 | 5 | 46488816 | |
test19 | ecurie | 3862829520 | 3 | 3862829520 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4049678160 | 0 | 0 | 0 | 5 | 34355904 | |
vedettfak | fa | 3189752016 | 29 | 3189752016 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 4188843648 | 0 | 0 | 0 | 5 | 39337584 | |
sakila | customer | 1714176288 | 25 | 1714176288 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1564373184 | 0 | 0 | 0 | 5 | 51801024 | |
sakila | country | 1541529792 | 115 | 1541529792 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1084593840 | 0 | 0 | 0 | 5 | 71566704 | |
sakila | language | 1392874560 | 75 | 1392874560 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1026864960 | 0 | 0 | 0 | 5 | 63767088 | |
sakila | address | 1253667360 | 39 | 1253667360 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1931739216 | 0 | 0 | 0 | 5 | 39299040 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 1074486864 | 12 | 1074486864 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | actor | 891442992 | 400 | 891442992 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 949818144 | 0 | 0 | 0 | 5 | 35302080 | |
test19 | voiture | 44475024 | 1 | 44475024 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1021619280 | 0 | 0 | 0 | 5 | 55257840 | |
world | Country | 32022144 | 1 | 32022144 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 507167760 | 0 | 0 | 0 | 4 | 27365712 | |
sys | sys_config | 15775056 | 1 | 15775056 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 895309008 | 0 | 0 | 0 | 5 | 52994304 | |
test19 | pilote | 12606000 | 1 | 12606000 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 906020016 | 0 | 0 | 0 | 5 | 48398592 | |
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 |
|