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 | 159226174272 | 48210 | 159226174272 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 19612683552 | 0 | 0 | 0 | 5 | 34246080 | |
sakila | rental | 37319901696 | 65331 | 37319901696 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 123426578352 | 0 | 0 | 0 | 5 | 33030624 | |
sakila | language | 17008068528 | 6013 | 17008068528 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 956577600 | 0 | 0 | 0 | 5 | 31944000 | |
sakila | film | 16904870400 | 8808 | 16904870400 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4188103392 | 0 | 0 | 0 | 5 | 33481536 | |
sakila | inventory | 12470974560 | 20282 | 12470974560 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 360448 | 5311571232 | 0 | 0 | 0 | 5 | 37785264 | |
sakila | customer | 6425788512 | 7093 | 6425788512 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 2273347296 | 0 | 0 | 0 | 5 | 33770352 | |
sakila | address | 5690952432 | 508 | 5690952432 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1634419248 | 0 | 0 | 0 | 5 | 32472528 | |
sakila | staff | 5490579072 | 484 | 5490579072 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2835714816 | 0 | 0 | 0 | 5 | 35773056 | |
sakila | film_actor | 5159880000 | 92 | 5159880000 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 5250781008 | 0 | 0 | 0 | 5 | 42564192 | |
sakila | actor | 4799893824 | 4317 | 4799893824 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1750214400 | 0 | 0 | 0 | 5 | 55994928 | |
vedettfak | megye | 4072391664 | 24 | 4072391664 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3949117392 | 0 | 0 | 0 | 5 | 44175120 | |
sakila | store | 3708837264 | 4 | 3708837264 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3803488128 | 0 | 0 | 0 | 5 | 30931296 | |
consultorio_medico | paciente | 3404283168 | 416 | 2796571008 | 15 | 607712160 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 196982016 | 6 | 55966370592 | |
consultorio_medico | Medico | 1639136928 | 465 | 1135522080 | 15 | 503614848 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 161996736 | 6 | 68568631824 | |
sakila | category | 1570935168 | 51 | 1570935168 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 792021120 | 0 | 0 | 0 | 5 | 48909168 | |
sakila | film_category | 1491834432 | 3052 | 1491834432 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 886057392 | 0 | 0 | 0 | 5 | 40029264 | |
sakila | country | 1074981072 | 70 | 1074981072 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 771295008 | 0 | 0 | 0 | 5 | 51105120 | |
sakila | city | 1028445792 | 122 | 1028445792 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 936561120 | 0 | 0 | 0 | 5 | 26345088 | |
sys | sys_config | 538711536 | 6 | 538711536 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 635497632 | 0 | 0 | 0 | 5 | 46370544 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 28818768 | 25 | 28818768 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
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 |
|