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 | payment | 58979188224 | 16044 | 58979188224 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 18001609296 | 0 | 0 | 0 | 5 | 39802752 | |
sakila | category | 35305823520 | 53 | 35305823520 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 35255730576 | 0 | 0 | 0 | 5 | 70040256 | |
sakila | inventory | 22902324192 | 4583 | 22902324192 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 4444934208 | 0 | 0 | 0 | 5 | 17878627008 | |
sakila | rental | 13264442928 | 20625 | 13264442928 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 376832 | 5960807952 | 0 | 0 | 0 | 5 | 33100320 | |
sakila | customer | 3425474976 | 79 | 3425474976 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 3387538176 | 0 | 0 | 0 | 5 | 37501200 | |
sakila | address | 2334631728 | 138 | 2334631728 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2419452816 | 0 | 0 | 0 | 5 | 34654752 | |
sakila | city | 1659684576 | 81 | 1659684576 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1333141920 | 0 | 0 | 0 | 5 | 21480096 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 1231366224 | 26 | 1231366224 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
vedettfak | fa | 1025614128 | 9 | 1025614128 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 2699790192 | 0 | 0 | 0 | 5 | 254540880 | |
sakila | staff | 910695984 | 2 | 910695984 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1033879440 | 0 | 0 | 0 | 5 | 34250304 | |
sakila | film | 816324432 | 2 | 816324432 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 988090752 | 0 | 0 | 0 | 5 | 46363152 | |
sakila | actor | 763130016 | 2 | 763130016 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 903631344 | 0 | 0 | 0 | 5 | 45063744 | |
sakila | country | 658282944 | 28 | 658282944 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 706753872 | 0 | 0 | 0 | 5 | 20966880 | |
sakila | store | 532155888 | 3 | 532155888 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 718080528 | 0 | 0 | 0 | 5 | 20684928 | |
vedettfak | megye | 67532256 | 5 | 67532256 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1971230976 | 0 | 0 | 0 | 5 | 38235120 | |
sakila | film_category | 41949600 | 1 | 41949600 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1356407712 | 0 | 0 | 0 | 5 | 37472688 | |
Table_insertion | voiture | 37653264 | 1 | 37653264 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1045105776 | 0 | 0 | 0 | 5 | 35850672 | |
world | CountryLanguage | 35385504 | 1 | 35385504 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 407 | 668619072 | 0 | 0 | 0 | 4 | 25653936 | |
TlapaleriaMalfoy | Registro | 19750368 | 1 | 19750368 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2718081696 | 0 | 0 | 0 | 5 | 1922044608 | |
Table_insertion | ecurie | 17293056 | 1 | 17293056 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4464385728 | 0 | 0 | 0 | 5 | 47810400 | |
Table_insertion | pilote | 17232864 | 1 | 17232864 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4254713760 | 0 | 0 | 0 | 5 | 37629504 | |
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 |
|