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 | 429649727760 | 208581 | 429649727760 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 9244977984 | 0 | 0 | 0 | 5 | 12246053952 | |
sakila | rental | 93314273184 | 268438 | 93314273184 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 10424951328 | 0 | 0 | 0 | 5 | 42596928 | |
sakila | city | 56879437824 | 49 | 56879437824 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 6429077952 | 0 | 0 | 0 | 5 | 51337955328 | |
sakila | inventory | 29977322496 | 66885 | 29977322496 | 0 | 0 | 0 | 0 | 0 | 0 | 26 | 475136 | 12199152240 | 0 | 0 | 0 | 5 | 45536832 | |
sakila | film | 9503448240 | 7568 | 9503448240 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 11520066624 | 0 | 0 | 0 | 5 | 61650864 | |
sakila | category | 4235248512 | 120 | 4235248512 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4200396816 | 0 | 0 | 0 | 5 | 42147600 | |
sakila | actor | 3433151568 | 7 | 3433151568 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1942711584 | 0 | 0 | 0 | 5 | 41884656 | |
sakila | film_text | 3355529232 | 46 | 3355529232 | 0 | 0 | 0 | 0 | 0 | 0 | 54 | 3538 | 986922288 | 0 | 0 | 0 | 39 | 96466128 | |
sakila | country | 3314383776 | 205 | 3314383776 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2743065072 | 0 | 0 | 0 | 5 | 41139120 | |
sakila | store | 2482701408 | 79 | 2482701408 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2105796528 | 0 | 0 | 0 | 5 | 48554352 | |
sakila | staff | 2389215312 | 65 | 2389215312 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1454671680 | 0 | 0 | 0 | 5 | 38553504 | |
sakila | customer | 2385124368 | 667 | 2385124368 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 1650756096 | 0 | 0 | 0 | 5 | 34585056 | |
sakila | film_category | 1905066240 | 7122 | 1905066240 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 796683360 | 0 | 0 | 0 | 5 | 24376704 | |
online_shopping_management_system | supplier | 1798454064 | 31 | 653975520 | 2 | 1144478544 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 233924592 | 7 | 59088095088 | |
sakila | language | 1755527664 | 166 | 1755527664 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 701815488 | 0 | 0 | 0 | 5 | 84141552 | |
sakila | address | 1603536000 | 1069 | 1603536000 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 5118355968 | 0 | 0 | 0 | 5 | 47607120 | |
sakila | film_actor | 1187867472 | 10 | 1187867472 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 2114182752 | 0 | 0 | 0 | 5 | 53104128 | |
online_shopping_management_system | Product | 618642816 | 30 | 584711424 | 1 | 33931392 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 248840064 | 7 | 76987090224 | |
sys | sys_config | 507821424 | 2 | 507821424 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 647954208 | 0 | 0 | 0 | 5 | 52593024 | |
online_shopping_management_system | Administrator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 4654789920 | 6 | 59423551440 | |
performance_schema | events_waits_summary_by_user_by_event_name | 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 | |
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 | |
performance_schema | events_statements_current | 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 |
|