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 | 59215778160 | 32088 | 59215778160 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 6519622032 | 0 | 0 | 0 | 5 | 32451408 | |
sakila | rental | 14520286176 | 41276 | 14520286176 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 6082834560 | 0 | 0 | 0 | 5 | 46291872 | |
sakila | city | 9153105456 | 470 | 9153105456 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 8117849520 | 0 | 0 | 0 | 5 | 48958800 | |
sakila | inventory | 6533400192 | 9194 | 6533400192 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 425984 | 7138752720 | 0 | 0 | 0 | 5 | 37162752 | |
sakila | actor | 3266144112 | 1683 | 3266144112 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 845106240 | 0 | 0 | 0 | 5 | 34920864 | |
sakila | country | 3089816928 | 613 | 3089816928 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1126272048 | 0 | 0 | 0 | 5 | 63828336 | |
sakila | store | 2889699120 | 13 | 2889699120 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2881133376 | 0 | 0 | 0 | 5 | 46919664 | |
sakila | language | 2520462912 | 157 | 2520462912 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1471007472 | 0 | 0 | 0 | 5 | 66777744 | |
sakila | customer | 2089312896 | 53 | 2089312896 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 3466067616 | 0 | 0 | 0 | 5 | 34995840 | |
sakila | film_category | 2048192784 | 26 | 2048192784 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 3494399568 | 0 | 0 | 0 | 5 | 45565344 | |
sakila | film | 1960060608 | 306 | 1960060608 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1492491792 | 0 | 0 | 0 | 5 | 34879152 | |
sakila | address | 1690568352 | 665 | 1690568352 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1849757712 | 0 | 0 | 0 | 5 | 21112080 | |
test19 | pilote | 1504199664 | 52 | 1504199664 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1643865696 | 0 | 0 | 0 | 5 | 48443472 | |
sakila | staff | 1099006656 | 31 | 1099006656 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1038889104 | 0 | 0 | 0 | 5 | 45144000 | |
sys | sys_config | 984847248 | 3 | 984847248 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1130429520 | 0 | 0 | 0 | 5 | 55858176 | |
sakila | category | 850683504 | 42 | 850683504 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 888996240 | 0 | 0 | 0 | 5 | 42902112 | |
sku | Attore | 556896912 | 8 | 556896912 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 841419744 | 0 | 0 | 0 | 5 | 50145744 | |
test19 | ecurie | 18315264 | 1 | 18315264 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1146393072 | 0 | 0 | 0 | 5 | 52920384 | |
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 | |
mysql | column_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|