SELECT * FROM `schema_table_statistics`
|
table_schema | table_name | total_latency | 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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sakila | rental | 57.21 ms | 396 | 57.21 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 53 | 896.00 KiB | 63.61 ms | 0 | 0 bytes | 0 ps | 5 | 66.50 us | |
sakila | film_actor | 9.13 ms | 6119 | 9.13 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 17 | 320.00 KiB | 5.44 ms | 0 | 0 bytes | 0 ps | 5 | 43.23 us | |
sakila | film | 6.22 ms | 2401 | 6.22 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 2.95 ms | 0 | 0 bytes | 0 ps | 5 | 38.26 us | |
sakila | inventory | 5.84 ms | 2713 | 5.84 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 5.32 ms | 0 | 0 bytes | 0 ps | 5 | 38.73 us | |
sakila | language | 5.35 ms | 1986 | 5.35 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 734.67 us | 0 | 0 bytes | 0 ps | 5 | 58.08 us | |
sakila | customer | 4.57 ms | 3070 | 4.57 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 1.61 ms | 0 | 0 bytes | 0 ps | 5 | 56.75 us | |
sakila | address | 4.52 ms | 968 | 4.52 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 2.05 ms | 0 | 0 bytes | 0 ps | 5 | 47.27 us | |
sakila | payment | 4.22 ms | 3 | 4.22 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 4.27 ms | 0 | 0 bytes | 0 ps | 5 | 35.25 us | |
sakila | country | 4.10 ms | 81 | 4.10 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 3.89 ms | 0 | 0 bytes | 0 ps | 5 | 48.74 us | |
test19 | ecurie | 4.04 ms | 4 | 4.04 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.47 ms | 0 | 0 bytes | 0 ps | 5 | 1.74 ms | |
sakila | staff | 3.81 ms | 277 | 3.81 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 176.00 KiB | 1.88 ms | 0 | 0 bytes | 0 ps | 5 | 55.72 us | |
vedettfak | megye | 2.88 ms | 44 | 2.88 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 699.44 us | 0 | 0 bytes | 0 ps | 5 | 197.05 us | |
test19 | voiture | 2.18 ms | 3 | 2.18 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.38 ms | 0 | 0 bytes | 0 ps | 5 | 59.36 us | |
sakila | city | 1.82 ms | 76 | 1.82 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 1.28 ms | 0 | 0 bytes | 0 ps | 5 | 64.57 us | |
vedettfak | fa | 1.55 ms | 6 | 1.55 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 12 | 240.00 KiB | 2.32 ms | 0 | 0 bytes | 0 ps | 5 | 303.00 us | |
sakila | actor | 1.40 ms | 339 | 1.40 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.02 ms | 0 | 0 bytes | 0 ps | 5 | 77.62 us | |
sakila | store | 1.22 ms | 107 | 1.22 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 697.00 us | 0 | 0 bytes | 0 ps | 5 | 35.82 us | |
world | City | 793.55 us | 27 | 793.55 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 27 | 2.02 KiB | 906.53 us | 0 | 0 bytes | 0 ps | 6 | 41.92 us | |
test19 | pilote | 726.97 us | 4 | 726.97 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 881.22 us | 0 | 0 bytes | 0 ps | 5 | 50.02 us | |
Table_insertion | pilote | 639.04 us | 27 | 639.04 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 849.75 us | 0 | 0 bytes | 0 ps | 5 | 39.41 us | |
world | Country | 334.81 us | 4 | 334.81 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 2 | 462 bytes | 172.30 us | 0 | 0 bytes | 0 ps | 6 | 41.27 us | |
mysql | dd_properties | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | schemata | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespace_files | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespaces | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|