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 | payment | 102018348432 | 32088 | 102018348432 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 16447196304 | 0 | 0 | 0 | 5 | 16913424 | |
sakila | rental | 61980157008 | 41250 | 61980157008 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 376832 | 44218663632 | 0 | 0 | 0 | 5 | 19725024 | |
sakila | inventory | 5383972176 | 9166 | 5383972176 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 2839716528 | 0 | 0 | 0 | 5 | 22796400 | |
Table_insertion | pilote | 3941006784 | 4 | 3941006784 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3790749072 | 0 | 0 | 0 | 5 | 42377280 | |
sakila | store | 3707635008 | 6 | 3707635008 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3622878864 | 0 | 0 | 0 | 5 | 35810016 | |
sakila | film | 2870574960 | 1150 | 2870574960 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3252265632 | 0 | 0 | 0 | 5 | 31819920 | |
sakila | country | 2572855296 | 57 | 2572855296 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2365845504 | 0 | 0 | 0 | 5 | 35583504 | |
sakila | language | 2280894528 | 461 | 2280894528 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 573098064 | 0 | 0 | 0 | 5 | 49042752 | |
sakila | film_category | 1622894064 | 1026 | 1622894064 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1239467328 | 0 | 0 | 0 | 5 | 64103424 | |
INFS1200_RELEASE | Vehicle | 1249708944 | 0 | 0 | 33 | 1249708944 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 7302509280 | 10 | 76721959248 | |
sakila | staff | 1191225024 | 5 | 1191225024 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1090442496 | 0 | 0 | 0 | 5 | 34631520 | |
INFS1200_RELEASE | Policy | 986955552 | 0 | 0 | 48 | 986955552 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 205460640 | 10 | 101111649936 | |
sys | sys_config | 892919280 | 13 | 892919280 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 560895456 | 0 | 0 | 0 | 5 | 42997680 | |
sakila | address | 759282480 | 5 | 759282480 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 693616176 | 0 | 0 | 0 | 5 | 27429600 | |
sakila | city | 606829872 | 5 | 606829872 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 558376368 | 0 | 0 | 0 | 5 | 17121456 | |
INFS1200_RELEASE | VehicleCodeMapping | 491559552 | 0 | 0 | 19 | 491559552 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 161906448 | 8 | 85930983600 | |
INFS1200_RELEASE | Customer | 309947088 | 0 | 0 | 14 | 309947088 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 300867600 | 10 | 89220602592 | |
INFS1200_RELEASE | VehicleExcessRange | 184050240 | 0 | 0 | 19 | 184050240 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 119439408 | 6 | 61803904272 | |
INFS1200_RELEASE | VehicleValue | 146342592 | 0 | 0 | 19 | 146342592 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 120171216 | 6 | 50134026624 | |
INFS1200_RELEASE | Address | 91603248 | 0 | 0 | 14 | 91603248 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 180316752 | 7 | 68351565216 | |
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 |
|