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 | film_category | 293999907168 | 330000 | 293999907168 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 804637152 | 0 | 0 | 0 | 5 | 16852176 | |
sakila | film | 155714316912 | 308206 | 155714316912 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2110516848 | 0 | 0 | 0 | 5 | 18569760 | |
sakila | payment | 115265680992 | 48132 | 115265680992 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 11507956944 | 0 | 0 | 0 | 5 | 13804032 | |
sakila | film_actor | 58284901488 | 330400 | 58284901488 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1598976192 | 0 | 0 | 0 | 5 | 22066704 | |
sakila | rental | 27900965664 | 61875 | 27900965664 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 376832 | 4744308624 | 0 | 0 | 0 | 5 | 18571872 | |
sakila | category | 5931204048 | 10270 | 5931204048 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1078042416 | 0 | 0 | 0 | 5 | 19705488 | |
sakila | address | 4939941072 | 82 | 4939941072 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4911654000 | 0 | 0 | 0 | 5 | 39856080 | |
sakila | inventory | 4701958272 | 13749 | 4701958272 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 2486712096 | 0 | 0 | 0 | 5 | 21621072 | |
sys | sys_config | 4357807872 | 7 | 4357807872 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4374390768 | 0 | 0 | 0 | 5 | 73742064 | |
sakila | store | 4061904528 | 9 | 4061904528 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4148943744 | 0 | 0 | 0 | 5 | 53062416 | |
vedettfak | megye | 3735109488 | 3 | 3735109488 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3915548208 | 0 | 0 | 0 | 5 | 41793840 | |
sakila | customer | 3553747296 | 54 | 3553747296 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 5380604592 | 0 | 0 | 0 | 5 | 37512288 | |
sakila | city | 1270239696 | 83 | 1270239696 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1042765152 | 0 | 0 | 0 | 5 | 45485616 | |
test19 | voiture | 1209787920 | 1 | 1209787920 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1326712992 | 0 | 0 | 0 | 5 | 55133760 | |
sakila | country | 991713360 | 82 | 991713360 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 734574720 | 0 | 0 | 0 | 5 | 37056624 | |
sakila | language | 838740144 | 50 | 838740144 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 648144288 | 0 | 0 | 0 | 5 | 50772480 | |
sakila | actor | 804547920 | 400 | 804547920 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 826924560 | 0 | 0 | 0 | 5 | 36362832 | |
sakila | staff | 766006032 | 6 | 766006032 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 904572768 | 0 | 0 | 0 | 5 | 22034496 | |
sakila | film_text | 324194640 | 1 | 324194640 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 442 | 1738117920 | 0 | 0 | 0 | 4 | 22037664 | |
bbdms | tblpages | 263785632 | 2 | 263785632 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 2020 | 256126992 | 14 | 1758 | 26405808 | 27 | 14982932448 | |
bbdms | tbladmin | 70983264 | 5 | 70983264 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 401777904 | 6 | 46687816032 | |
bbdms | tblblooddonars | 27272784 | 5 | 27272784 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 885638160 | 9 | 87899430432 | |
world | Country | 20837520 | 2 | 20837520 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 2394587712 | 0 | 0 | 0 | 5 | 31253904 | |
bbdms | tblbloodrequirer | 19234512 | 5 | 19234512 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 141345600 | 9 | 98457088752 | |
bbdms | tblcontactusinfo | 15122448 | 1 | 15122448 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 284609952 | 6 | 54485249280 |
|