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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys | sys_config | 1 | 680750400 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 991478400 | 0 | 0 | 0 | 5 | 48736512 | 16384 | 338 | 16046 | 1 | 0 | 1 | 6 | |
ALQUEZA_db | Enrollments | 0 | 0 | 2 | 76893168 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 492033696 | 8 | 98364618528 | 49152 | 118 | 49034 | 3 | 0 | 0 | 2 | |
ALQUEZA_db | Students | 0 | 0 | 2 | 50001600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 331553376 | 6 | 90157512720 | 16384 | 66 | 16318 | 1 | 0 | 0 | 2 | |
ALQUEZA_db | Courses | 0 | 0 | 2 | 34066560 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 282797328 | 6 | 62651552832 | 16384 | 81 | 16303 | 1 | 0 | 0 | 2 | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1671168 | 1165352 | 505816 | 102 | 58 | 11 | 4306 | |
mysql | help_topic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1130496 | 888166 | 242330 | 69 | 0 | 64 | 605 | |
mysql | tables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 720896 | 513550 | 207346 | 44 | 39 | 2 | 356 | |
mysql | routines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 294912 | 140982 | 153930 | 18 | 0 | 5 | 50 | |
mysql | index_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 278528 | 135366 | 143162 | 17 | 4 | 3 | 1436 | |
mysql | help_keyword | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 180224 | 105101 | 75123 | 11 | 0 | 9 | 649 | |
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 | indexes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 114688 | 54165 | 60523 | 7 | 5 | 1 | 306 | |
mysql | triggers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 98304 | 1076 | 97228 | 6 | 0 | 4 | 2 | |
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 | 3 | 0 | |
mysql | help_relation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 81920 | 42760 | 39160 | 5 | 0 | 5 | 1646 | |
mysql | global_grants | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 65536 | 26830 | 38706 | 4 | 0 | 4 | 79 | |
mysql | foreign_keys | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 65536 | 11796 | 53740 | 4 | 2 | 0 | 57 | |
mysql | column_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 65536 | 32929 | 32607 | 4 | 0 | 1 | 820 | |
mysql | schemata | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 49152 | 2338 | 46814 | 3 | 2 | 0 | 20 | |
mysql | character_sets | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 49152 | 4296 | 44856 | 3 | 1 | 0 | 41 | |
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 | |
mysql | check_constraints | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 49152 | 0 | 49152 | 3 | 0 | 0 | 0 | |
ventas | proveedor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 509763936 | 10 | 104376877440 | 49152 | 850 | 48302 | 3 | 0 | 0 | 15 | |
mysql | innodb_index_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 49152 | 30139 | 19013 | 3 | 0 | 1 | 300 |
|