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 | 1 | 2164462608 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 12444966336 | 0 | 0 | 0 | 5 | 25279056 | 770048 | 650236 | 119812 | 47 | 0 | 47 | 8530 | |
sakila | actor | 53 | 2142963504 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4069736352 | 0 | 0 | 0 | 5 | 35875488 | 32768 | 10353 | 22415 | 2 | 0 | 0 | 200 | |
sakila | film | 232 | 1343601600 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1930337376 | 0 | 0 | 0 | 5 | 30586512 | 212992 | 155213 | 57779 | 13 | 0 | 10 | 1006 | |
sakila | language | 175 | 1082166096 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1465140336 | 0 | 0 | 0 | 5 | 45258048 | 16384 | 264 | 16120 | 1 | 1 | 0 | 6 | |
test19 | ecurie | 13 | 118838544 | 0 | 0 | 0 | 0 | 1 | 874120896 | 4 | 114688 | 1459368768 | 1 | 16384 | 933589008 | 6 | 6653915136 | 16384 | 131 | 16253 | 1 | 0 | 0 | 3 | |
world | City | 2 | 836774928 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 771152448 | 0 | 0 | 0 | 5 | 116440896 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Stefano | vulcano | 2 | 819910608 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1082089008 | 0 | 0 | 0 | 5 | 37112064 | 16384 | 344 | 16040 | 1 | 0 | 1 | 4 | |
Table_insertion | pilote | 26 | 733677120 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 881444784 | 0 | 0 | 0 | 5 | 41576304 | 16384 | 1119 | 15265 | 1 | 0 | 1 | 30 | |
sakila | address | 26 | 466736160 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3897497472 | 0 | 0 | 0 | 5 | 36893472 | 98304 | 51858 | 46446 | 6 | 0 | 6 | 605 | |
sakila | category | 107 | 461605584 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3705764304 | 0 | 0 | 0 | 5 | 33688512 | 16384 | 487 | 15897 | 1 | 0 | 0 | 16 | |
sakila | film_category | 52 | 418022880 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1539192864 | 0 | 0 | 0 | 5 | 21777888 | 81920 | 33036 | 48884 | 5 | 0 | 2 | 1002 | |
students | employees | 22 | 117761952 | 5 | 296030064 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 9517596000 | 6 | 72747306192 | 16384 | 214 | 16170 | 1 | 0 | 0 | 5 | |
sakila | city | 25 | 195314592 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 2773826880 | 0 | 0 | 0 | 5 | 36810576 | 49152 | 21240 | 27912 | 3 | 0 | 3 | 602 | |
login | login table | 4 | 56880384 | 1 | 32545392 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 44 | 16340 | 1 | 0 | 0 | 1 | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1540096 | 1136649 | 403447 | 94 | 54 | 14 | 4207 | |
mysql | help_topic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1114112 | 884762 | 229350 | 68 | 0 | 68 | 582 | |
sakila | rental | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 51 | 884736 | 7089506160 | 0 | 0 | 0 | 5 | 51712848 | 786432 | 689635 | 96797 | 48 | 0 | 48 | 16091 | |
mysql | tables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 753664 | 535198 | 218466 | 46 | 35 | 0 | 417 | |
mysql | routines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 294912 | 148799 | 146113 | 18 | 0 | 4 | 56 | |
mysql | index_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 278528 | 151288 | 127240 | 17 | 6 | 6 | 1621 | |
sakila | film_actor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1867740336 | 0 | 0 | 0 | 5 | 28757520 | 196608 | 142155 | 54453 | 12 | 0 | 12 | 5473 | |
sakila | inventory | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 278528 | 4734230160 | 0 | 0 | 0 | 5 | 28910112 | 180224 | 128388 | 51836 | 11 | 0 | 11 | 4591 | |
mysql | help_keyword | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 163840 | 90153 | 73687 | 10 | 0 | 10 | 548 | |
mysql | indexes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 114688 | 61122 | 53566 | 7 | 4 | 0 | 367 | |
mysql | table_partitions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 114688 | 0 | 114688 | 7 | 0 | 4 | 0 |
|