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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Table_insertion | pilote | 2 | 10.74 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 10.91 ms | 0 | 0 bytes | 0 ps | 5 | 47.48 us | 16.00 KiB | 1.09 KiB | 14.91 KiB | 1 | 0 | 1 | 30 | |
sys | sys_config | 1 | 2.18 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.09 ms | 0 | 0 bytes | 0 ps | 5 | 283.22 us | 16.00 KiB | 338 bytes | 15.67 KiB | 1 | 0 | 1 | 6 | |
vedettfak | megye | 6 | 1.12 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.24 ms | 0 | 0 bytes | 0 ps | 5 | 46.55 us | 16.00 KiB | 655 bytes | 15.36 KiB | 1 | 0 | 0 | 19 | |
Table_insertion | ecurie | 2 | 639.59 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 844.16 us | 0 | 0 bytes | 0 ps | 5 | 34.96 us | 16.00 KiB | 171 bytes | 15.83 KiB | 1 | 0 | 1 | 4 | |
mysql | columns | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1.47 MiB | 1.04 MiB | 438.86 KiB | 94 | 64 | 6 | 3888 | |
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 | 4 | 0 | |
mysql | innodb_index_stats | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 64.00 KiB | 43.52 KiB | 20.48 KiB | 4 | 0 | 0 | 450 | |
mysql | view_table_usage | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 32.00 KiB | 22.42 KiB | 9.58 KiB | 2 | 1 | 0 | 172 | |
mysql | proxies_priv | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 32.00 KiB | 1.16 KiB | 30.84 KiB | 2 | 0 | 1 | 1 | |
mysql | time_zone_leap_second | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16.00 KiB | 0 bytes | 16.00 KiB | 1 | 0 | 1 | 0 | |
mysql | servers | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16.00 KiB | 0 bytes | 16.00 KiB | 1 | 0 | 1 | 0 | |
mysql | time_zone_transition_type | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16.00 KiB | 0 bytes | 16.00 KiB | 1 | 0 | 1 | 0 | |
mysql | user | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16.00 KiB | 4.14 KiB | 11.86 KiB | 1 | 0 | 0 | 9 | |
performance_schema | file_summary_by_event_name | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_transactions_summary_by_user_by_event_name | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_waits_summary_by_account_by_event_name | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_summary_by_digest | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_topic | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1.08 MiB | 872.70 KiB | 231.30 KiB | 69 | 0 | 65 | 642 | |
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 | 0 | 0 | 2 | |
mysql | column_statistics | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 48.00 KiB | 0 bytes | 48.00 KiB | 3 | 0 | 0 | 0 | |
mysql | catalogs | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 32.00 KiB | 56 bytes | 31.95 KiB | 2 | 0 | 1 | 1 | |
mysql | resource_groups | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 32.00 KiB | 2.14 KiB | 29.86 KiB | 2 | 0 | 2 | 2 | |
StdMdDB | course | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 3.83 ms | 0 | 0 bytes | 0 ps | 5 | 82.26 us | 16.00 KiB | 0 bytes | 16.00 KiB | 1 | 0 | 1 | 0 | |
mysql | time_zone_transition | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16.00 KiB | 0 bytes | 16.00 KiB | 1 | 0 | 1 | 0 | |
Table_insertion | cours | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.60 ms | 0 | 0 bytes | 0 ps | 5 | 1.76 ms | 16.00 KiB | 0 bytes | 16.00 KiB | 1 | 0 | 1 | 0 |
|