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 | 80225 | 218127074352 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 6744970848 | 0 | 0 | 0 | 5 | 34249248 | 1015808 | 835288 | 180520 | 62 | 60 | 17 | 16079 | |
sakila | film_category | 170064 | 175497515424 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1259096784 | 0 | 0 | 0 | 5 | 30078576 | 81920 | 33036 | 48884 | 5 | 0 | 1 | 1002 | |
sakila | film | 159128 | 105640770576 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 344064 | 2850213696 | 0 | 0 | 0 | 5 | 40429488 | 245760 | 163368 | 82392 | 15 | 11 | 2 | 790 | |
sakila | rental | 98544 | 46535279472 | 0 | 0 | 0 | 0 | 0 | 0 | 68 | 1163264 | 6884935200 | 0 | 0 | 0 | 5 | 34639968 | 1064960 | 882419 | 182541 | 65 | 16 | 18 | 16076 | |
sakila | film_actor | 170663 | 39219711696 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 1754074080 | 0 | 0 | 0 | 5 | 30998352 | 229376 | 154150 | 75226 | 14 | 10 | 2 | 3402 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 24 | 37266346656 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 949 | 15435 | 1 | 0 | 1 | 24 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 16 | 19033393104 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 195 | 16189 | 1 | 0 | 0 | 3 | |
sakila | inventory | 26906 | 13420044000 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 360448 | 2139413232 | 0 | 0 | 0 | 5 | 28211568 | 262144 | 174254 | 87890 | 16 | 0 | 6 | 4588 | |
vedettfak | megye | 19 | 4443841776 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4973534016 | 0 | 0 | 0 | 5 | 50057568 | 16384 | 655 | 15729 | 1 | 0 | 1 | 19 | |
world | City | 4079 | 3821223120 | 0 | 0 | 0 | 0 | 0 | 0 | 4081 | 273685 | 1864238112 | 0 | 0 | 0 | 4 | 38679168 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | category | 5219 | 3551037072 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 876165840 | 0 | 0 | 0 | 5 | 37127376 | 16384 | 487 | 15897 | 1 | 1 | 0 | 16 | |
sakila | film_text | 1001 | 2703723792 | 0 | 0 | 0 | 0 | 0 | 0 | 2002 | 119290 | 1934848608 | 0 | 0 | 0 | 1005 | 165427152 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
vedettfak | fa | 1258 | 2672498928 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 1712928096 | 0 | 0 | 0 | 5 | 37660656 | 114688 | 78301 | 36387 | 7 | 0 | 7 | 1264 | |
sys | sys_config | 1 | 2076252816 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1287600336 | 0 | 0 | 0 | 5 | 246369552 | 16384 | 338 | 16046 | 1 | 0 | 1 | 6 | |
world | CountryLanguage | 984 | 1672772112 | 0 | 0 | 0 | 0 | 0 | 0 | 986 | 38783 | 1330710480 | 0 | 0 | 0 | 4 | 19808448 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sku | Attore | 1 | 1603523856 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1659814464 | 0 | 0 | 0 | 5 | 112834128 | 16384 | 91 | 16293 | 1 | 0 | 1 | 1 | |
sakila | staff | 8 | 1261302240 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2111257104 | 0 | 0 | 0 | 5 | 39708240 | 32768 | 267 | 32501 | 2 | 0 | 0 | 2 | |
world | Country | 239 | 1194919968 | 0 | 0 | 0 | 0 | 0 | 0 | 241 | 62841 | 1177287408 | 0 | 0 | 0 | 4 | 19622064 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Stefano | vulcano | 4 | 962323824 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 863886144 | 0 | 0 | 0 | 5 | 30526320 | 16384 | 344 | 16040 | 1 | 0 | 1 | 4 | |
sakila | actor | 456 | 864121632 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1192617888 | 0 | 0 | 0 | 5 | 41556240 | 32768 | 10353 | 22415 | 2 | 0 | 0 | 200 | |
test19 | ecurie | 4 | 834867792 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1071275568 | 0 | 0 | 0 | 5 | 50713344 | 16384 | 171 | 16213 | 1 | 0 | 1 | 4 | |
Table_insertion | voiture | 14 | 722224800 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 902998272 | 0 | 0 | 0 | 5 | 35784144 | 16384 | 646 | 15738 | 1 | 0 | 1 | 14 | |
sakila | city | 652 | 715728816 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1990356192 | 0 | 0 | 0 | 5 | 37076160 | 65536 | 26640 | 38896 | 4 | 0 | 0 | 601 | |
Table_insertion | ecurie | 4 | 713880816 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1014178704 | 0 | 0 | 0 | 5 | 33925584 | 16384 | 171 | 16213 | 1 | 0 | 1 | 4 | |
test19 | pilote | 30 | 684727296 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 942549168 | 0 | 0 | 0 | 5 | 36264624 | 16384 | 1119 | 15265 | 1 | 0 | 1 | 30 |
|