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 | address | 26 | 15836826720 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2538654624 | 0 | 0 | 0 | 5 | 70825392 | 98304 | 51858 | 46446 | 6 | 0 | 6 | 605 | |
sakila | country | 51 | 2812093152 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2664776400 | 0 | 0 | 0 | 5 | 105098400 | 16384 | 3739 | 12645 | 1 | 0 | 0 | 110 | |
sakila | city | 51 | 1297943328 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1109421456 | 0 | 0 | 0 | 5 | 36637392 | 65536 | 26640 | 38896 | 4 | 0 | 2 | 601 | |
test19 | ecurie | 14 | 1067856240 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1207044960 | 0 | 0 | 0 | 5 | 60403728 | 16384 | 171 | 16213 | 1 | 0 | 1 | 4 | |
test19 | voiture | 15 | 1056591888 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 938586000 | 0 | 0 | 0 | 5 | 397341120 | 32768 | 842 | 31926 | 2 | 0 | 2 | 14 | |
sakila | language | 7 | 879984336 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 924606672 | 0 | 0 | 0 | 5 | 51550752 | 16384 | 264 | 16120 | 1 | 0 | 1 | 6 | |
sakila | actor | 26 | 789682608 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 922973040 | 0 | 0 | 0 | 5 | 35899248 | 32768 | 10353 | 22415 | 2 | 0 | 2 | 200 | |
usuario | usuario | 5 | 113490960 | 2 | 552499200 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 158671920 | 7 | 92480216400 | 16384 | 31 | 16353 | 1 | 0 | 0 | 1 | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1523712 | 1117121 | 406591 | 93 | 46 | 31 | 4060 | |
mysql | tables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 589824 | 397981 | 191843 | 36 | 17 | 8 | 408 | |
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 | 149080 | 129448 | 17 | 3 | 7 | 1597 | |
mysql | indexes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 114688 | 60527 | 54161 | 7 | 5 | 0 | 364 | |
mysql | table_partitions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 114688 | 0 | 114688 | 7 | 0 | 5 | 0 | |
mysql | triggers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 98304 | 3640 | 94664 | 6 | 0 | 4 | 8 | |
mysql | collations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 81920 | 29916 | 52004 | 5 | 3 | 1 | 273 | |
mysql | events | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 81920 | 0 | 81920 | 5 | 0 | 4 | 0 | |
mysql | global_grants | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 65536 | 26830 | 38706 | 4 | 0 | 0 | 79 | |
mysql | foreign_keys | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 65536 | 17487 | 48049 | 4 | 1 | 1 | 86 | |
mysql | column_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 65536 | 33951 | 31585 | 4 | 0 | 0 | 848 | |
mysql | character_sets | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 49152 | 4296 | 44856 | 3 | 2 | 0 | 41 | |
mysql | check_constraints | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 49152 | 2212 | 46940 | 3 | 0 | 1 | 10 | |
mysql | parameters | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 49152 | 12777 | 36375 | 3 | 0 | 3 | 99 | |
mysql | schemata | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 49152 | 4816 | 44336 | 3 | 2 | 0 | 42 | |
mysql | index_partitions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 49152 | 0 | 49152 | 3 | 0 | 3 | 0 |
|