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 | 7023377778912 | 8631842 | 7023377778912 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1907727360 | 0 | 0 | 0 | 5 | 47524224 | |
sakila | film | 3844044247296 | 8063162 | 3844044247296 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2266480128 | 0 | 0 | 0 | 5 | 34363296 | |
sakila | payment | 3013200851760 | 1636514 | 3013200851760 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 13496795664 | 0 | 0 | 0 | 5 | 33285648 | |
sakila | film_actor | 1367858987616 | 8590453 | 1367858987616 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 3452439408 | 0 | 0 | 0 | 5 | 47629824 | |
sakila | rental | 640981559328 | 2103776 | 640981559328 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 7705302528 | 0 | 0 | 0 | 5 | 34276704 | |
sakila | inventory | 137913267888 | 518390 | 137913267888 | 0 | 0 | 0 | 0 | 0 | 0 | 26 | 475136 | 6910977744 | 0 | 0 | 0 | 5 | 30417024 | |
sakila | category | 126025332576 | 267946 | 126025332576 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1197880992 | 0 | 0 | 0 | 5 | 39568320 | |
sakila | film_text | 9369814608 | 186 | 9369814608 | 0 | 0 | 0 | 0 | 0 | 0 | 262 | 15922 | 7160308848 | 0 | 0 | 0 | 147 | 195915984 | |
sakila | customer | 8071172736 | 1444 | 8071172736 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 5184314784 | 0 | 0 | 0 | 5 | 37372896 | |
sakila | actor | 7161841104 | 10478 | 7161841104 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2597798544 | 0 | 0 | 0 | 5 | 65428704 | |
sakila | address | 4500377904 | 2977 | 4500377904 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1506467424 | 0 | 0 | 0 | 5 | 34135200 | |
sakila | city | 3329158800 | 2077 | 3329158800 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1526607984 | 0 | 0 | 0 | 5 | 55601040 | |
sakila | country | 2915953920 | 775 | 2915953920 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1090506384 | 0 | 0 | 0 | 5 | 40562544 | |
sakila | staff | 2811632208 | 220 | 2811632208 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3322375056 | 0 | 0 | 0 | 5 | 30539520 | |
sakila | store | 2782238976 | 156 | 2782238976 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 3308220432 | 0 | 0 | 0 | 5 | 22643280 | |
sakila | language | 1716541200 | 203 | 1716541200 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1073029584 | 0 | 0 | 0 | 5 | 43737936 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 1546731120 | 5 | 1546731120 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 1367274480 | 9 | 1367274480 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sys | sys_config | 822121344 | 1 | 822121344 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1737372384 | 0 | 0 | 0 | 5 | 48376416 | |
Table_insertion | pilote | 661906080 | 2 | 661906080 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 920123952 | 0 | 0 | 0 | 5 | 36621552 | |
Table_insertion | voiture | 633445824 | 2 | 633445824 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 876199632 | 0 | 0 | 0 | 5 | 45835152 | |
world | CountryLanguage | 256295952 | 26 | 256295952 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 1382 | 477153600 | 0 | 0 | 0 | 6 | 31819392 | |
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 |
|