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 | 70388875920 | 32114 | 70388875920 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 13415114592 | 0 | 0 | 0 | 5 | 22667568 | |
sakila | rental | 18110602752 | 41250 | 18110602752 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 376832 | 5321566800 | 0 | 0 | 0 | 5 | 24003936 | |
sakila | inventory | 4502634576 | 9166 | 4502634576 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 3543241152 | 0 | 0 | 0 | 5 | 26717328 | |
sakila | country | 4072572240 | 106 | 4072572240 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3844606128 | 0 | 0 | 0 | 5 | 42310752 | |
Stefano | vulcano | 4020213120 | 9 | 4020213120 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4106165712 | 0 | 0 | 0 | 5 | 48032688 | |
Table_insertion | pilote | 3838656624 | 2 | 3838656624 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3962482128 | 0 | 0 | 0 | 5 | 35977392 | |
Table_insertion | voiture | 3703346064 | 4 | 3703346064 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3815919360 | 0 | 0 | 0 | 5 | 47052192 | |
Table_insertion | ecurie | 2970621456 | 4 | 2970621456 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2704055904 | 0 | 0 | 0 | 5 | 471611712 | |
sakila | staff | 2167552992 | 29 | 2167552992 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2196247152 | 0 | 0 | 0 | 5 | 23517648 | |
sakila | customer | 2061682656 | 51 | 2061682656 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2100561408 | 0 | 0 | 0 | 5 | 41600592 | |
TlapaleriaMalfoy | Registro | 1741036704 | 9 | 1741036704 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 772289232 | 0 | 0 | 0 | 5 | 338236272 | |
sakila | city | 1632141456 | 108 | 1632141456 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1220425536 | 0 | 0 | 0 | 5 | 43368336 | |
sakila | store | 1289237664 | 6 | 1289237664 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1233905904 | 0 | 0 | 0 | 5 | 36485856 | |
sakila | address | 1140650016 | 81 | 1140650016 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1292475888 | 0 | 0 | 0 | 5 | 37278384 | |
sakila | film | 1075593552 | 26 | 1075593552 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1524841296 | 0 | 0 | 0 | 5 | 37204992 | |
sakila | actor | 1038056448 | 85 | 1038056448 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 856110288 | 0 | 0 | 0 | 5 | 56857680 | |
sakila | language | 977520720 | 32 | 977520720 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 953344128 | 0 | 0 | 0 | 5 | 33352704 | |
world | CountryLanguage | 745387632 | 1 | 745387632 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 407 | 189469104 | 0 | 0 | 0 | 5 | 35678016 | |
sys | sys_config | 514948368 | 3 | 514948368 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 662115696 | 0 | 0 | 0 | 5 | 50581872 | |
sakila | film_text | 271573632 | 25 | 271573632 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 3415 | 945023904 | 0 | 0 | 0 | 32 | 38458464 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 120889296 | 12 | 120889296 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
vedettfak | fa | 54635856 | 1 | 54635856 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 1579813488 | 0 | 0 | 0 | 5 | 42895776 | |
sku | Attore | 33439824 | 1 | 33439824 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1429571088 | 0 | 0 | 0 | 5 | 101746656 | |
world | City | 22408848 | 1 | 22408848 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 720230016 | 0 | 0 | 0 | 4 | 23397792 | |
world | Country | 14585472 | 1 | 14585472 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 617645424 | 0 | 0 | 0 | 5 | 31563312 |
|