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 | actor | 3957743328 | 130 | 3957743328 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 3837476544 | 0 | 0 | 0 | 5 | 45995664 | |
sakila | address | 1600083936 | 26 | 1600083936 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2076802992 | 0 | 0 | 0 | 5 | 66406560 | |
sakila | film | 1542064656 | 77 | 1542064656 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1805867712 | 0 | 0 | 0 | 5 | 41799120 | |
sakila | city | 1426010256 | 103 | 1426010256 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1122749760 | 0 | 0 | 0 | 5 | 50520624 | |
sakila | country | 1306407168 | 75 | 1306407168 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 934650816 | 0 | 0 | 0 | 5 | 48887520 | |
sakila | language | 1167931776 | 50 | 1167931776 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 812814816 | 0 | 0 | 0 | 5 | 43350384 | |
sakila | film_category | 873348432 | 26 | 873348432 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1046554608 | 0 | 0 | 0 | 5 | 32554368 | |
sakila | category | 763269936 | 25 | 763269936 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 853111248 | 0 | 0 | 0 | 5 | 37152720 | |
dockland_bike_db | Staff | 460343136 | 0 | 0 | 10 | 460343136 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 4548225264 | 8 | 70115045616 | |
dockland_bike_db | Address | 326394288 | 0 | 0 | 10 | 326394288 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 215853264 | 7 | 77110313808 | |
dockland_bike_db | Supplier | 307637088 | 0 | 0 | 10 | 307637088 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 197451936 | 8 | 70178157456 | |
dockland_bike_db | Customer | 143445984 | 0 | 0 | 10 | 143445984 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 145894320 | 8 | 67970406768 | |
dockland_bike_db | City | 99918720 | 0 | 0 | 10 | 99918720 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 219354432 | 8 | 105276639072 | |
dockland_bike_db | Bicycle_Brand | 99676368 | 1 | 16664736 | 10 | 83011632 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 196860576 | 7 | 72438812160 | |
dockland_bike_db | Shipping_Method | 67985808 | 0 | 0 | 10 | 67985808 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 209947056 | 7 | 54914877072 | |
mysql | general_log | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 35 | 1268795616 | 0 | 0 | 0 | 4 | 374006160 | |
mysql | slow_log | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 35 | 265993200 | 0 | 0 | 0 | 4 | 1744469760 | |
mysql | help_category | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_keyword | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_relation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | events | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | global_status | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | routines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | table_lock_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|