SELECT * FROM `x$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 | city | 12251780112 | 31 | 12251780112 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 12530051952 | 0 | 0 | 0 | 5 | 44444928 | |
sakila | country | 12149712432 | 390 | 12149712432 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 11740182432 | 0 | 0 | 0 | 5 | 47865312 | |
sakila | actor | 6299071680 | 18 | 6299071680 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 6207255120 | 0 | 0 | 0 | 5 | 46450800 | |
sakila | rental | 5213389632 | 24 | 5213389632 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 21378372576 | 0 | 0 | 0 | 5 | 51248208 | |
sakila | payment | 4481250048 | 13 | 4481250048 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 8565270912 | 0 | 0 | 0 | 5 | 35870208 | |
sakila | address | 4460121600 | 813 | 4460121600 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 8174711424 | 0 | 0 | 0 | 5 | 40897824 | |
sakila | category | 3859589712 | 13 | 3859589712 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3935305440 | 0 | 0 | 0 | 5 | 46250160 | |
sakila | language | 3042616896 | 311 | 3042616896 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1563645600 | 0 | 0 | 0 | 5 | 112359984 | |
Stefano | vulcano | 2855005824 | 13 | 2855005824 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 982450656 | 0 | 0 | 0 | 5 | 2029623024 | |
test19 | pilote | 2676995376 | 20 | 2676995376 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2631546192 | 0 | 0 | 0 | 5 | 47211120 | |
test19 | ecurie | 2403690432 | 20 | 2403690432 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2410275120 | 0 | 0 | 0 | 5 | 48086544 | |
sakila | store | 2335294896 | 34 | 2335294896 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1775042016 | 0 | 0 | 0 | 5 | 387298560 | |
sakila | film | 2305959744 | 142 | 2305959744 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3571572048 | 0 | 0 | 0 | 5 | 35647392 | |
sakila | film_text | 2185471200 | 38 | 2185471200 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 3415 | 2122560528 | 0 | 0 | 0 | 37 | 116166864 | |
sakila | staff | 1972037232 | 50 | 1972037232 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1577316576 | 0 | 0 | 0 | 5 | 37662240 | |
sakila | inventory | 1470257184 | 464 | 1470257184 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2188692000 | 0 | 0 | 0 | 5 | 35241888 | |
test19 | voiture | 1096565712 | 13 | 1096565712 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 3025652256 | 0 | 0 | 0 | 5 | 32587632 | |
sakila | customer | 924300432 | 413 | 924300432 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1272024864 | 0 | 0 | 0 | 5 | 37312176 | |
sys | sys_config | 698047680 | 8 | 698047680 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 699671808 | 0 | 0 | 0 | 5 | 44965008 | |
world | City | 34532784 | 2 | 34532784 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 1556780544 | 0 | 0 | 0 | 4 | 28777056 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | schemata | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespace_files | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespaces | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | check_constraints | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|