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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Table_insertion | ecurie | 7 | 37506224448 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3021221808 | 0 | 0 | 0 | 5 | 32435568 | 16384 | 171 | 16213 | 1 | 0 | 0 | 4 | |
sakila | payment | 26 | 5094321408 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 10487896848 | 0 | 0 | 0 | 5 | 44173008 | 770048 | 650236 | 119812 | 47 | 0 | 47 | 8530 | |
sakila | film | 156 | 4967295168 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5015837904 | 0 | 0 | 0 | 5 | 40848192 | 212992 | 155213 | 57779 | 13 | 0 | 10 | 1006 | |
sakila | country | 27 | 4856605776 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4908304368 | 0 | 0 | 0 | 5 | 59773824 | 16384 | 3739 | 12645 | 1 | 0 | 0 | 110 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 142 | 4526160144 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 949 | 15435 | 1 | 0 | 0 | 24 | |
Stefano | vulcano | 3 | 3109609008 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1287238656 | 0 | 0 | 0 | 5 | 1379242128 | 16384 | 344 | 16040 | 1 | 0 | 0 | 4 | |
sakila | customer | 26 | 2486271744 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 2246038080 | 0 | 0 | 0 | 5 | 60017232 | 49152 | 12964 | 36188 | 3 | 0 | 3 | 348 | |
sakila | film_category | 7 | 2476016400 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 2301811248 | 0 | 0 | 0 | 5 | 134904528 | 49152 | 15486 | 33666 | 3 | 0 | 0 | 651 | |
Table_insertion | pilote | 5 | 1874802864 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1762726416 | 0 | 0 | 0 | 5 | 153801648 | 16384 | 1119 | 15265 | 1 | 0 | 0 | 30 | |
sakila | language | 150 | 1843912224 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 915568368 | 0 | 0 | 0 | 5 | 55247280 | 16384 | 264 | 16120 | 1 | 1 | 0 | 6 | |
sys | sys_config | 51 | 1760174592 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 912070368 | 0 | 0 | 0 | 5 | 44739552 | 16384 | 338 | 16046 | 1 | 0 | 0 | 6 | |
Table_insertion | voiture | 5 | 1514245920 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1515157776 | 0 | 0 | 0 | 5 | 97385904 | 32768 | 842 | 31926 | 2 | 0 | 0 | 14 | |
sakila | staff | 25 | 1324199184 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1176692880 | 0 | 0 | 0 | 5 | 38451072 | 16384 | 253 | 16131 | 1 | 0 | 1 | 2 | |
TlapaleriaMalfoy | Registro | 5 | 1052071152 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 884690928 | 0 | 0 | 0 | 5 | 40313856 | 16384 | 126 | 16258 | 1 | 0 | 0 | 2 | |
sakila | category | 3 | 956737056 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1119348384 | 0 | 0 | 0 | 5 | 46436544 | 16384 | 487 | 15897 | 1 | 0 | 1 | 16 | |
sakila | city | 1 | 801570528 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 896388768 | 0 | 0 | 0 | 5 | 35387616 | 16384 | 5400 | 10984 | 1 | 0 | 1 | 600 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 11 | 798172848 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 195 | 16189 | 1 | 0 | 0 | 3 | |
world | CountryLanguage | 9 | 613275168 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 563 | 812557680 | 0 | 0 | 0 | 9 | 58205664 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | address | 1 | 598649040 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 779119968 | 0 | 0 | 0 | 5 | 33419232 | 16384 | 5427 | 10957 | 1 | 0 | 1 | 603 | |
world | Country | 26 | 513350640 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 6987 | 1058430384 | 0 | 0 | 0 | 6 | 72448464 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
world | wangui | 3 | 38143248 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 834 | 24770592 | 14 | 570 | 31540608 | 18 | 81413376 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
world | admin | 0 | 0 | 1 | 17119872 | 0 | 0 | 0 | 0 | 2 | 321 | 13544784 | 8 | 444 | 45231120 | 8 | 391624992 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1589248 | 1165969 | 423279 | 97 | 72 | 7 | 4128 | |
mysql | tables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 753664 | 533060 | 220604 | 46 | 38 | 0 | 412 | |
mysql | st_spatial_reference_systems | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 327680 | 227713 | 99967 | 20 | 0 | 20 | 1174 |
|