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 | 114156714672 | 48132 | 114156714672 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 11349488304 | 0 | 0 | 0 | 5 | 14393808 | |
sakila | rental | 24260280000 | 61875 | 24260280000 | 0 | 0 | 0 | 0 | 0 | 0 | 68 | 1163264 | 17603827296 | 0 | 0 | 0 | 5 | 26839824 | |
sakila | inventory | 8094472320 | 15745 | 8094472320 | 0 | 0 | 0 | 0 | 0 | 0 | 26 | 475136 | 5435892000 | 0 | 0 | 0 | 5 | 45324576 | |
sakila | customer | 5502013440 | 27 | 5502013440 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 6183833568 | 0 | 0 | 0 | 5 | 52212864 | |
sakila | country | 4238127696 | 80 | 4238127696 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2334526656 | 0 | 0 | 0 | 5 | 1815507936 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 3090775776 | 18 | 3090775776 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | film | 2717247456 | 2078 | 2717247456 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1564630320 | 0 | 0 | 0 | 5 | 44030448 | |
sakila | city | 1665918672 | 29 | 1665918672 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1890066288 | 0 | 0 | 0 | 5 | 48957744 | |
sakila | language | 1579757520 | 75 | 1579757520 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1298681472 | 0 | 0 | 0 | 5 | 44527296 | |
sakila | address | 1426296432 | 30 | 1426296432 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 14228570400 | 0 | 0 | 0 | 5 | 35813184 | |
sakila | staff | 1363256928 | 4 | 1363256928 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1430858352 | 0 | 0 | 0 | 5 | 48809376 | |
world | CountryLanguage | 997377744 | 1 | 997377744 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 407 | 192436992 | 0 | 0 | 0 | 4 | 27300240 | |
sys | sys_config | 898893072 | 4 | 898893072 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 793871232 | 0 | 0 | 0 | 5 | 70565088 | |
sakila | store | 726071808 | 6 | 726071808 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 819557376 | 0 | 0 | 0 | 5 | 34411344 | |
sakila | actor | 516867648 | 479 | 516867648 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1650352176 | 0 | 0 | 0 | 5 | 103738800 | |
sakila | film_category | 391348320 | 2033 | 391348320 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1402114032 | 0 | 0 | 0 | 5 | 38346000 | |
Table_insertion | voiture | 62052144 | 1 | 62052144 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 909003744 | 0 | 0 | 0 | 5 | 401123184 | |
sakila | category | 56077824 | 36 | 56077824 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 893983728 | 0 | 0 | 0 | 5 | 42006096 | |
Table_insertion | pilote | 17926656 | 1 | 17926656 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 807239664 | 0 | 0 | 0 | 5 | 49523760 | |
Table_insertion | ecurie | 17581344 | 1 | 17581344 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 969499344 | 0 | 0 | 0 | 5 | 31750224 | |
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 |
|