SELECT * FROM `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 | 18 | 2.20 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.71 ms | 0 | 0 bytes | 0 ps | 5 | 49.72 us | 16.00 KiB | 338 bytes | 15.67 KiB | 1 | 0 | 0 | 6 | |
Diplom 2023 | Arxiv 2023 | 9 | 670.14 us | 1 | 78.04 us | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16.00 KiB | 78 bytes | 15.92 KiB | 1 | 0 | 0 | 1 | |
Hospital | Doctor data | 1 | 33.80 us | 2 | 78.48 us | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16.00 KiB | 120 bytes | 15.88 KiB | 1 | 0 | 0 | 2 | |
loja | migrations | 0 | 0 ps | 1 | 18.84 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 7 | 208.00 KiB | 175.82 us | 6 | 62.26 ms | 16.00 KiB | 32 bytes | 15.97 KiB | 1 | 0 | 1 | 1 | |
mysql | columns | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1.59 MiB | 1.13 MiB | 479.93 KiB | 102 | 81 | 9 | 4198 | |
mysql | help_topic | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1.09 MiB | 870.75 KiB | 249.25 KiB | 70 | 0 | 65 | 628 | |
mysql | tables | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 752.00 KiB | 542.10 KiB | 209.90 KiB | 47 | 40 | 3 | 462 | |
mysql | st_spatial_reference_systems | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 336.00 KiB | 232.28 KiB | 103.72 KiB | 21 | 0 | 21 | 1168 | |
mysql | routines | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 288.00 KiB | 137.68 KiB | 150.32 KiB | 18 | 10 | 5 | 50 | |
mysql | index_column_usage | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 272.00 KiB | 146.15 KiB | 125.85 KiB | 17 | 10 | 2 | 1598 | |
mysql | help_keyword | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 176.00 KiB | 104.73 KiB | 71.27 KiB | 11 | 0 | 9 | 664 | |
mysql | table_partitions | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 112.00 KiB | 0 bytes | 112.00 KiB | 7 | 0 | 3 | 0 | |
mysql | indexes | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 96.00 KiB | 53.05 KiB | 42.95 KiB | 6 | 5 | 0 | 326 | |
mysql | innodb_index_stats | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 96.00 KiB | 51.76 KiB | 44.24 KiB | 6 | 0 | 3 | 533 | |
mysql | triggers | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 96.00 KiB | 1.05 KiB | 94.95 KiB | 6 | 1 | 4 | 2 | |
loja | os | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 11 | 272.00 KiB | 135.86 us | 12 | 114.24 ms | 80.00 KiB | 0 bytes | 80.00 KiB | 5 | 0 | 0 | 0 | |
mysql | collations | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 80.00 KiB | 29.21 KiB | 50.79 KiB | 5 | 3 | 1 | 273 | |
mysql | events | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 80.00 KiB | 0 bytes | 80.00 KiB | 5 | 0 | 4 | 0 | |
mysql | help_relation | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 80.00 KiB | 41.76 KiB | 38.24 KiB | 5 | 0 | 3 | 1646 | |
loja | lancamentos | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 10 | 256.00 KiB | 190.15 us | 11 | 86.28 ms | 64.00 KiB | 836 bytes | 63.18 KiB | 4 | 0 | 0 | 7 | |
loja | vendas | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 10 | 256.00 KiB | 158.99 us | 11 | 96.33 ms | 64.00 KiB | 309 bytes | 63.70 KiB | 4 | 0 | 0 | 4 | |
mysql | column_type_elements | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 64.00 KiB | 32.30 KiB | 31.70 KiB | 4 | 3 | 0 | 824 | |
mysql | foreign_keys | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 64.00 KiB | 14.86 KiB | 49.14 KiB | 4 | 3 | 0 | 73 | |
mysql | global_grants | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 64.00 KiB | 26.20 KiB | 37.80 KiB | 4 | 0 | 2 | 79 | |
loja | ci_sessions | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 13 | 304.00 KiB | 223.29 us | 10 | 99.64 ms | 48.00 KiB | 10.08 KiB | 37.92 KiB | 3 | 0 | 3 | 80 |
|