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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sakila | film_category | 660052 | 524.78 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 176.00 KiB | 2.88 ms | 0 | 0 bytes | 0 ps | 5 | 382.91 us | 80.00 KiB | 32.26 KiB | 47.74 KiB | 5 | 0 | 0 | 1002 | |
sakila | film | 616379 | 286.89 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 15 | 288.00 KiB | 1.82 ms | 0 | 0 bytes | 0 ps | 5 | 48.84 us | 192.00 KiB | 143.76 KiB | 48.24 KiB | 12 | 11 | 0 | 1011 | |
sakila | film_actor | 660826 | 104.58 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 17 | 320.00 KiB | 1.63 ms | 0 | 0 bytes | 0 ps | 5 | 27.72 us | 224.00 KiB | 150.54 KiB | 73.46 KiB | 14 | 10 | 2 | 3402 | |
sakila | category | 20590 | 10.30 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.02 ms | 0 | 0 bytes | 0 ps | 5 | 47.55 us | 16.00 KiB | 487 bytes | 15.52 KiB | 1 | 1 | 0 | 16 | |
Movies | movies | 176 | 2.65 ms | 7 | 80.74 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 8 | 224.00 KiB | 488.02 us | 7 | 69.13 ms | 16.00 KiB | 521 bytes | 15.49 KiB | 1 | 0 | 0 | 7 | |
sakila | address | 25 | 1.67 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 176.00 KiB | 2.62 ms | 0 | 0 bytes | 0 ps | 5 | 63.50 us | 80.00 KiB | 45.34 KiB | 34.66 KiB | 5 | 0 | 5 | 607 | |
Movies | user_rating | 64 | 522.30 us | 5 | 907.71 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 10 | 256.00 KiB | 565.49 us | 8 | 80.95 ms | 32.00 KiB | 392 bytes | 31.62 KiB | 2 | 0 | 0 | 5 | |
sakila | customer | 26 | 1.26 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 1.86 ms | 0 | 0 bytes | 0 ps | 5 | 44.55 us | 96.00 KiB | 51.96 KiB | 44.04 KiB | 6 | 0 | 6 | 601 | |
sakila | actor | 825 | 1.23 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 979.39 us | 0 | 0 bytes | 0 ps | 5 | 41.74 us | 16.00 KiB | 7.33 KiB | 8.67 KiB | 1 | 0 | 0 | 200 | |
Table_insertion | ecurie | 8 | 1.15 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 971.28 us | 0 | 0 bytes | 0 ps | 5 | 364.43 us | 16.00 KiB | 171 bytes | 15.83 KiB | 1 | 0 | 0 | 4 | |
sakila | staff | 2 | 54.92 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.03 ms | 0 | 0 bytes | 0 ps | 5 | 33.35 us | 32.00 KiB | 267 bytes | 31.74 KiB | 2 | 0 | 2 | 2 | |
mysql | columns | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1.44 MiB | 1.07 MiB | 379.50 KiB | 92 | 56 | 22 | 4038 | |
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 | 880.43 KiB | 239.57 KiB | 70 | 0 | 66 | 695 | |
sakila | rental | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 51 | 864.00 KiB | 6.33 ms | 0 | 0 bytes | 0 ps | 5 | 34.15 us | 768.00 KiB | 673.47 KiB | 94.53 KiB | 48 | 0 | 48 | 16091 | |
mysql | tables | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 736.00 KiB | 520.31 KiB | 215.69 KiB | 46 | 26 | 0 | 411 | |
sakila | payment | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 48 | 816.00 KiB | 6.87 ms | 0 | 0 bytes | 0 ps | 5 | 12.45 ms | 720.00 KiB | 627.41 KiB | 92.59 KiB | 45 | 0 | 45 | 16093 | |
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 | 145.31 KiB | 142.69 KiB | 18 | 0 | 4 | 56 | |
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 | 145.40 KiB | 126.60 KiB | 17 | 6 | 6 | 1595 | |
sakila | inventory | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 14 | 272.00 KiB | 3.27 ms | 0 | 0 bytes | 0 ps | 5 | 40.04 us | 176.00 KiB | 125.38 KiB | 50.62 KiB | 11 | 0 | 11 | 4591 | |
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 | 11 | 664 | |
mysql | indexes | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 112.00 KiB | 59.00 KiB | 53.00 KiB | 7 | 5 | 0 | 363 | |
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 | 5 | 0 | |
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 | 3.55 KiB | 92.45 KiB | 6 | 0 | 4 | 8 | |
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 |
|