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 | payment | 128392 | 302.32 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 48 | 816.00 KiB | 13.12 ms | 0 | 0 bytes | 0 ps | 5 | 33.07 us | 720.00 KiB | 627.41 KiB | 92.59 KiB | 45 | 0 | 16 | 16093 | |
sakila | rental | 128352 | 210.55 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 51 | 864.00 KiB | 11.40 ms | 0 | 0 bytes | 0 ps | 5 | 36.42 us | 768.00 KiB | 673.47 KiB | 94.53 KiB | 48 | 0 | 17 | 16091 | |
sakila | film_actor | 43696 | 33.82 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 15 | 288.00 KiB | 1.56 ms | 0 | 0 bytes | 0 ps | 5 | 34.14 us | 192.00 KiB | 138.82 KiB | 53.18 KiB | 12 | 0 | 5 | 5473 | |
sakila | film | 9226 | 29.41 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 2.01 ms | 0 | 0 bytes | 0 ps | 5 | 32.77 us | 208.00 KiB | 151.58 KiB | 56.42 KiB | 13 | 0 | 5 | 1006 | |
sakila | inventory | 36651 | 24.95 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 7.07 ms | 0 | 0 bytes | 0 ps | 5 | 33.56 us | 208.00 KiB | 132.98 KiB | 75.02 KiB | 13 | 0 | 5 | 2684 | |
sakila | film_text | 8000 | 23.13 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16002 | 928.93 KiB | 18.48 ms | 0 | 0 bytes | 0 ps | 8012 | 13.84 ms | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
world | City | 8158 | 12.34 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8160 | 534.16 KiB | 19.93 ms | 0 | 0 bytes | 0 ps | 6 | 96.15 us | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | address | 6055 | 8.92 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 176.00 KiB | 1.02 ms | 0 | 0 bytes | 0 ps | 5 | 32.32 us | 80.00 KiB | 45.34 KiB | 34.66 KiB | 5 | 0 | 2 | 607 | |
sakila | customer | 4818 | 8.61 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 3.20 ms | 0 | 0 bytes | 0 ps | 5 | 34.67 us | 96.00 KiB | 51.96 KiB | 44.04 KiB | 6 | 0 | 1 | 601 | |
vedettfak | fa | 2598 | 8.15 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 12 | 240.00 KiB | 3.83 ms | 0 | 0 bytes | 0 ps | 5 | 688.38 us | 144.00 KiB | 85.00 KiB | 59.00 KiB | 9 | 0 | 4 | 944 | |
sakila | film_category | 8000 | 7.91 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 4.87 ms | 0 | 0 bytes | 0 ps | 5 | 31.50 us | 64.00 KiB | 24.45 KiB | 39.55 KiB | 4 | 0 | 0 | 1003 | |
world | CountryLanguage | 1968 | 5.33 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 1970 | 75.35 KiB | 4.43 ms | 0 | 0 bytes | 0 ps | 7 | 137.74 us | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | city | 4800 | 3.74 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 6 | 144.00 KiB | 962.01 us | 0 | 0 bytes | 0 ps | 5 | 33.42 us | 48.00 KiB | 20.74 KiB | 27.26 KiB | 3 | 0 | 0 | 602 | |
sku | Attore | 3 | 3.19 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.43 ms | 0 | 0 bytes | 0 ps | 5 | 836.08 us | 16.00 KiB | 91 bytes | 15.91 KiB | 1 | 0 | 1 | 1 | |
world | Country | 478 | 2.89 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 480 | 122.29 KiB | 4.77 ms | 0 | 0 bytes | 0 ps | 6 | 93.34 us | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 48 | 2.54 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16.00 KiB | 949 bytes | 15.07 KiB | 1 | 0 | 0 | 24 | |
vedettfak | megye | 113 | 1.91 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.55 ms | 0 | 0 bytes | 0 ps | 5 | 122.50 us | 16.00 KiB | 655 bytes | 15.36 KiB | 1 | 0 | 1 | 19 | |
sakila | actor | 1825 | 1.90 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 855.44 us | 0 | 0 bytes | 0 ps | 5 | 36.94 us | 16.00 KiB | 7.33 KiB | 8.67 KiB | 1 | 0 | 0 | 200 | |
TlapaleriaMalfoy | Registro | 4 | 1.82 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.48 ms | 0 | 0 bytes | 0 ps | 5 | 578.28 us | 16.00 KiB | 126 bytes | 15.88 KiB | 1 | 0 | 0 | 2 | |
Table_insertion | pilote | 60 | 1.78 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.72 ms | 0 | 0 bytes | 0 ps | 5 | 98.45 us | 16.00 KiB | 1.09 KiB | 14.91 KiB | 1 | 0 | 1 | 30 | |
test19 | ecurie | 8 | 1.78 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.84 ms | 0 | 0 bytes | 0 ps | 5 | 140.79 us | 16.00 KiB | 171 bytes | 15.83 KiB | 1 | 0 | 1 | 4 | |
Table_insertion | voiture | 28 | 1.76 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.79 ms | 0 | 0 bytes | 0 ps | 5 | 107.16 us | 16.00 KiB | 646 bytes | 15.37 KiB | 1 | 0 | 0 | 14 | |
sakila | staff | 16 | 1.55 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 1.29 ms | 0 | 0 bytes | 0 ps | 5 | 32.54 us | 16.00 KiB | 253 bytes | 15.75 KiB | 1 | 0 | 0 | 2 | |
Table_insertion | ecurie | 8 | 1.47 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.80 ms | 0 | 0 bytes | 0 ps | 5 | 117.65 us | 16.00 KiB | 171 bytes | 15.83 KiB | 1 | 0 | 0 | 4 | |
test19 | pilote | 60 | 1.45 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.48 ms | 0 | 0 bytes | 0 ps | 5 | 82.33 us | 16.00 KiB | 1.09 KiB | 14.91 KiB | 1 | 0 | 0 | 30 |
|