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 | 1074098961408 | 1155056 | 1074098961408 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1231413744 | 0 | 0 | 0 | 5 | 29029968 | |
sakila | film | 608172087072 | 1079249 | 608172087072 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2216505456 | 0 | 0 | 0 | 5 | 32157312 | |
sakila | film_actor | 218932201488 | 1156433 | 218932201488 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 3653726208 | 0 | 0 | 0 | 5 | 26690400 | |
sys | sys_config | 52654757232 | 5 | 52654757232 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 807152016 | 0 | 0 | 0 | 5 | 53350704 | |
sakila | category | 21572240976 | 36012 | 21572240976 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 697782096 | 0 | 0 | 0 | 5 | 34270368 | |
sku | Attore | 3724687296 | 2 | 3724687296 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3862035936 | 0 | 0 | 0 | 5 | 35392368 | |
sakila | actor | 3307500768 | 2153 | 3307500768 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2823107760 | 0 | 0 | 0 | 5 | 30617136 | |
sakila | language | 2990971104 | 299 | 2990971104 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1131790704 | 0 | 0 | 0 | 5 | 64106064 | |
sakila | inventory | 2579173872 | 52 | 2579173872 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4746906912 | 0 | 0 | 0 | 5 | 32699040 | |
vedettfak | fa | 2547667056 | 4 | 2547667056 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 4281199824 | 0 | 0 | 0 | 5 | 35420880 | |
sakila | rental | 2412462624 | 3 | 2412462624 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 8900395680 | 0 | 0 | 0 | 5 | 42564192 | |
sakila | address | 1970952192 | 218 | 1970952192 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1687409328 | 0 | 0 | 0 | 5 | 36358608 | |
sakila | store | 1895806176 | 4 | 1895806176 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2688269232 | 0 | 0 | 0 | 5 | 31447152 | |
sakila | customer | 1247625984 | 158 | 1247625984 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 1748281920 | 0 | 0 | 0 | 5 | 33984192 | |
sakila | payment | 872939232 | 2 | 872939232 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 5539394784 | 0 | 0 | 0 | 5 | 34079232 | |
sakila | staff | 820249584 | 13 | 820249584 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 3053047008 | 0 | 0 | 0 | 5 | 33761376 | |
test19 | voiture | 790482528 | 2 | 790482528 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1049844048 | 0 | 0 | 0 | 5 | 42053616 | |
sakila | city | 710180592 | 112 | 710180592 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1165407408 | 0 | 0 | 0 | 5 | 62796624 | |
sakila | country | 338989728 | 183 | 338989728 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 800899440 | 0 | 0 | 0 | 5 | 31376928 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 107249472 | 50 | 107249472 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
world | Country | 42691968 | 3 | 42691968 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 1430237424 | 0 | 0 | 0 | 6 | 53667504 | |
world | City | 33682704 | 2 | 33682704 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 956928192 | 0 | 0 | 0 | 4 | 28680960 | |
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 |
|