SELECT * FROM `x$io_global_by_file_by_latency`
|
file | total | total_latency | count_read | read_latency | count_write | write_latency | count_misc | misc_latency | |
---|---|---|---|---|---|---|---|---|---|
/var/lib/mysql/ib_logfile1 | 758 | 4002730075344 | 2 | 880614240 | 477 | 127341119664 | 279 | 3874508341440 | |
/var/lib/mysql/ibdata1 | 150 | 1087487211888 | 20 | 7757605680 | 65 | 10771368960 | 65 | 1068958237248 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 87 | 662106927504 | 0 | 0 | 54 | 2919173136 | 33 | 659187754368 | |
/var/lib/mysql/mysql.ibd | 558 | 467034261408 | 319 | 90409395120 | 198 | 4015084656 | 41 | 372609781632 | |
/var/lib/mysql/ib_logfile0 | 61 | 452506247952 | 6 | 891192720 | 26 | 2761269984 | 29 | 448853785248 | |
/var/lib/mysql/undo_001 | 611 | 388089799152 | 388 | 33289705152 | 188 | 12388509408 | 35 | 342411584592 | |
/var/lib/mysql/binlog.000008 | 42 | 343366925088 | 0 | 0 | 20 | 2782488192 | 22 | 340584436896 | |
/var/lib/mysql/undo_002 | 568 | 305246685216 | 382 | 20209226400 | 152 | 5929716672 | 34 | 279107742144 | |
/var/lib/mysql/ibtmp1 | 147 | 253130493792 | 0 | 0 | 143 | 10319670240 | 4 | 242810823552 | |
/var/lib/mysql/Ristorante/Ordinazione.ibd | 19 | 155332856976 | 0 | 0 | 10 | 5970279216 | 9 | 149362577760 | |
/var/lib/mysql/Ristorante/IngredientiPortata.ibd | 14 | 84429974640 | 0 | 0 | 7 | 613759872 | 7 | 83816214768 | |
/var/lib/mysql/Ristorante/Personale.ibd | 13 | 82492926912 | 0 | 0 | 7 | 5814192912 | 6 | 76678734000 | |
/var/lib/mysql/Ristorante/RecapitoTelefonicoPerson... | 13 | 82275964320 | 0 | 0 | 7 | 513398688 | 6 | 81762565632 | |
/var/lib/mysql/Ristorante/Cliente_Ordinazione.ibd | 15 | 75968281488 | 0 | 0 | 8 | 227339376 | 7 | 75740942112 | |
/var/lib/mysql/Ristorante/Tavolo.ibd | 13 | 72494165568 | 0 | 0 | 7 | 649565136 | 6 | 71844600432 | |
/var/lib/mysql/Ristorante/Portata_Ordinazione.ibd | 15 | 69006992208 | 0 | 0 | 8 | 180608736 | 7 | 68826383472 | |
/var/lib/mysql/Studemts/students.ibd | 13 | 67895475648 | 0 | 0 | 7 | 349806864 | 6 | 67545668784 | |
/var/lib/mysql/Ristorante/Cliente.ibd | 13 | 60847787616 | 0 | 0 | 7 | 214939296 | 6 | 60632848320 | |
/var/lib/mysql/Ristorante/Menu.ibd | 13 | 57160606272 | 0 | 0 | 7 | 471564720 | 6 | 56689041552 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 11 | 55934231760 | 0 | 0 | 5 | 492158304 | 6 | 55442073456 | |
/var/lib/mysql/Ristorante/Portata.ibd | 13 | 52872238320 | 0 | 0 | 7 | 186522864 | 6 | 52685715456 | |
/var/lib/mysql/ray/rrr.ibd | 13 | 50597496048 | 0 | 0 | 7 | 153477984 | 6 | 50444018064 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 44398087008 | 0 | 0 | 3 | 244721136 | 5 | 44153365872 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 8 | 43630560864 | 0 | 0 | 3 | 333099888 | 5 | 43297460976 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 43209198384 | 0 | 0 | 3 | 231195360 | 5 | 42978003024 |
|