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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys | sys_config | 17888079264 | 1 | 17888079264 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 627453552 | 0 | 0 | 0 | 5 | 47878512 | |
sakila | inventory | 4221393792 | 26 | 4221393792 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4948538496 | 0 | 0 | 0 | 5 | 36348048 | |
sakila | language | 2658669024 | 758 | 2658669024 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 435707184 | 0 | 0 | 0 | 5 | 40367184 | |
sakila | film | 2645954256 | 643 | 2645954256 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5484530304 | 0 | 0 | 0 | 5 | 65778240 | |
sakila | country | 2164186464 | 75 | 2164186464 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1411425840 | 0 | 0 | 0 | 5 | 66379632 | |
sakila | film_actor | 2105411088 | 8 | 2105411088 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1734507984 | 0 | 0 | 0 | 5 | 44413248 | |
sakila | city | 1724465952 | 128 | 1724465952 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1109955792 | 0 | 0 | 0 | 5 | 43661904 | |
UniversityDB | assignment | 1600330512 | 0 | 0 | 22 | 1600330512 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 290242128 | 6 | 56635060944 | |
vedettfak | megye | 1469901840 | 18 | 1469901840 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 373679328 | 0 | 0 | 0 | 5 | 832082064 | |
UniversityDB | enrolment | 1454189616 | 0 | 0 | 17 | 1454189616 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 6068278656 | 8 | 109404236304 | |
UniversityDB | tutors | 1444519296 | 0 | 0 | 17 | 1444519296 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 226701024 | 7 | 92102024256 | |
sakila | actor | 1353849552 | 400 | 1353849552 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 734971776 | 0 | 0 | 0 | 5 | 34283568 | |
sakila | address | 1235145648 | 77 | 1235145648 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1091377584 | 0 | 0 | 0 | 5 | 40492320 | |
HospitalDB | treatment | 1215060000 | 0 | 0 | 15 | 1215060000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 124744752 | 8 | 97243218864 | |
UniversityDB | student | 1081690896 | 0 | 0 | 11 | 1081690896 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 278528 | 290197776 | 9 | 78511076160 | |
sakila | customer | 1028358144 | 26 | 1028358144 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1253359536 | 0 | 0 | 0 | 5 | 39847104 | |
HospitalDB | patient | 941681664 | 0 | 0 | 18 | 941681664 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 294912 | 249403440 | 9 | 83197895088 | |
UniversityDB | examination | 892042800 | 0 | 0 | 6 | 892042800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 5900543616 | 6 | 56856336240 | |
HospitalDB | nurse | 731034480 | 0 | 0 | 12 | 731034480 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 296551728 | 8 | 76944376080 | |
HospitalDB | prescription | 724408080 | 0 | 0 | 13 | 724408080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 240602736 | 9 | 90470045424 | |
UniversityDB | quota | 693050160 | 0 | 0 | 3 | 693050160 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 158323440 | 6 | 47373778320 | |
HospitalDB | drug | 661882848 | 0 | 0 | 12 | 661882848 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 263890176 | 7 | 72800878656 | |
UniversityDB | assignment_includes | 591119760 | 0 | 0 | 2 | 591119760 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 374834064 | 7 | 82872127008 | |
HospitalDB | ward | 441364176 | 0 | 0 | 5 | 441364176 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 302096784 | 7 | 53239278048 | |
HospitalDB | consists_of | 380035920 | 0 | 0 | 8 | 380035920 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 114739152 | 7 | 63990624720 |
|