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 | 4370933424 | 64 | 4370933424 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4286630304 | 0 | 0 | 0 | 5 | 38936304 | |
sakila | country | 3814123104 | 26 | 3814123104 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3901814400 | 0 | 0 | 0 | 5 | 41489184 | |
sakila | city | 1380197280 | 50 | 1380197280 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1105202208 | 0 | 0 | 0 | 5 | 47286624 | |
sakila | language | 1362936432 | 364 | 1362936432 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 697014384 | 0 | 0 | 0 | 5 | 83285664 | |
sakila | address | 1333395888 | 79 | 1333395888 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1512157152 | 0 | 0 | 0 | 5 | 32346336 | |
sakila | customer | 1236526368 | 26 | 1236526368 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2433839760 | 0 | 0 | 0 | 5 | 40239936 | |
sakila | film | 1142543952 | 449 | 1142543952 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1405388688 | 0 | 0 | 0 | 5 | 31548000 | |
sys | sys_config | 621045744 | 1 | 621045744 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 868254816 | 0 | 0 | 0 | 5 | 51483168 | |
sakila | film_category | 618572064 | 6 | 618572064 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 713805312 | 0 | 0 | 0 | 5 | 35671680 | |
sakila | category | 586290672 | 128 | 586290672 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 755305056 | 0 | 0 | 0 | 5 | 40210896 | |
mysql | parameter_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Table_insertion | ecurie | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 904582272 | 0 | 0 | 0 | 5 | 29124480 | |
Table_insertion | cours | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 798529776 | 0 | 0 | 0 | 5 | 56531904 | |
performance_schema | status_by_account | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Table_insertion | pilote | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 710268768 | 0 | 0 | 0 | 5 | 32268192 | |
performance_schema | events_transactions_summary_by_user_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Table_insertion | rallye | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 884451744 | 0 | 0 | 0 | 5 | 28369968 | |
Table_insertion | RK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 785203584 | 0 | 0 | 0 | 5 | 25922160 | |
mysql | innodb_table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameters | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | session_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | file_summary_by_instance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_current | 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_io_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|