SELECT * FROM `x$schema_table_statistics_with_buffer`
|
table_schema | table_name | 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 | innodb_buffer_allocated | innodb_buffer_data | innodb_buffer_free | innodb_buffer_pages | innodb_buffer_pages_hashed | innodb_buffer_pages_old | innodb_buffer_rows_cached | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sakila | payment | 64202 | 153192858720 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 12702598656 | 0 | 0 | 0 | 5 | 38143248 | 1048576 | 843056 | 205520 | 64 | 60 | 2 | 11041 | |
sakila | film_category | 169064 | 139711483296 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 684500784 | 0 | 0 | 0 | 5 | 22825968 | 81920 | 33036 | 48884 | 5 | 0 | 4 | 1002 | |
sakila | film | 158076 | 75074193216 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1381027296 | 0 | 0 | 0 | 5 | 22187088 | 196608 | 147213 | 49395 | 12 | 11 | 12 | 1011 | |
sakila | rental | 82500 | 33500081472 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 376832 | 5602670304 | 0 | 0 | 0 | 5 | 22682352 | 278528 | 192784 | 85744 | 17 | 16 | 0 | 16060 | |
sakila | film_actor | 165200 | 27708729840 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1553942544 | 0 | 0 | 0 | 5 | 29836752 | 196608 | 142155 | 54453 | 12 | 10 | 12 | 5473 | |
sakila | inventory | 22324 | 10130850048 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2140694160 | 0 | 0 | 0 | 5 | 22079904 | 81920 | 45866 | 36054 | 5 | 0 | 0 | 4585 | |
sakila | category | 5203 | 2984854752 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 803559504 | 0 | 0 | 0 | 5 | 64043232 | 16384 | 487 | 15897 | 1 | 1 | 0 | 16 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 11 | 2315149056 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 195 | 16189 | 1 | 0 | 0 | 3 | |
sakila | city | 81 | 1616295648 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1587683856 | 0 | 0 | 0 | 5 | 51586128 | 65536 | 26640 | 38896 | 4 | 0 | 0 | 601 | |
sakila | customer | 51 | 1582949280 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1522396128 | 0 | 0 | 0 | 5 | 38980128 | 49152 | 12964 | 36188 | 3 | 0 | 1 | 348 | |
sakila | staff | 25 | 1340248800 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1231188816 | 0 | 0 | 0 | 5 | 46912272 | 16384 | 253 | 16131 | 1 | 0 | 1 | 2 | |
sakila | country | 276 | 1322333760 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1072031664 | 0 | 0 | 0 | 5 | 57709872 | 16384 | 3739 | 12645 | 1 | 0 | 0 | 110 | |
vedettfak | megye | 6 | 1206174816 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1484844768 | 0 | 0 | 0 | 5 | 36714480 | 16384 | 655 | 15729 | 1 | 0 | 0 | 19 | |
sakila | film_text | 1 | 884442768 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 442 | 293556384 | 0 | 0 | 0 | 4 | 20533392 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | address | 26 | 845078256 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1035099648 | 0 | 0 | 0 | 5 | 20348064 | 32768 | 7505 | 25263 | 2 | 0 | 2 | 102 | |
zoo | Tier | 0 | 0 | 5 | 784856688 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 6084909600 | 8 | 85593230976 | 32768 | 247 | 32521 | 2 | 0 | 0 | 5 | |
sakila | actor | 200 | 740489376 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 993197040 | 0 | 0 | 0 | 5 | 37747776 | 16384 | 7507 | 8877 | 1 | 0 | 1 | 200 | |
sys | sys_config | 1 | 579291504 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 824447184 | 0 | 0 | 0 | 5 | 56154912 | 16384 | 338 | 16046 | 1 | 0 | 1 | 6 | |
zoo | Gehege | 0 | 0 | 5 | 282030672 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 516201840 | 8 | 87651080880 | 32768 | 278 | 32490 | 2 | 0 | 0 | 5 | |
zoo | Art | 0 | 0 | 3 | 201414048 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 603790704 | 7 | 64348702704 | 16384 | 88 | 16296 | 1 | 0 | 0 | 3 | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1572864 | 1157847 | 415017 | 96 | 73 | 15 | 4017 | |
mysql | help_topic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1130496 | 880914 | 249582 | 69 | 0 | 67 | 556 | |
mysql | tables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 753664 | 533206 | 220458 | 46 | 35 | 0 | 412 | |
mysql | st_spatial_reference_systems | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 409600 | 285873 | 123727 | 25 | 0 | 23 | 1376 | |
mysql | routines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 294912 | 148799 | 146113 | 18 | 0 | 7 | 56 |
|