Server: mysql wampserver »Database: performance_schema »Table: file_summary_by_instance
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.
Showing rows 0 - 24 (140 total, Query took 0.0006 sec)
SELECT * FROM `file_summary_by_instance`
[ Inline ] [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]
|
|
|
Number of rows:

FILE_NAME EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
c:\wamp\bin\mysql\mysql5.6.17\share\french\errmsg.... wait/io/file/sql/ERRMSG 313778240 5 471310048 23211936 94261728 245521760 3 295625792 23211936 98541696 245521760 60783 0 0 0 0 0 0 2 175684256 43497696 87841952 132186560
c:\wamp\bin\mysql\mysql5.6.17\share\charsets\Index... wait/io/file/mysys/charset 313778944 3 316116768 43593440 105372256 189914208 1 189914208 189914208 189914208 189914208 18305 0 0 0 0 0 0 2 126202560 43593440 63101280 82609120
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.fr... wait/io/file/sql/FRM 313781056 13 503337824 708928 38718240 295370240 7 153306912 5355680 21900736 78357312 1104 0 0 0 0 0 0 6 350030912 708928 58338368 295370240
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.MY... wait/io/file/myisam/kfile 313781760 9 284443456 1065152 31604672 80158848 4 113046560 5771744 28261376 78399200 728 0 0 0 0 0 0 5 171396896 1065152 34279168 80158848
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.MY... wait/io/file/myisam/dfile 313782464 32296 909251125728 2289056 28153664 415277632 0 0 0 0 0 0 0 0 0 0 0 0 32296 909251125728 2289056 28153664 415277632
c:\wamp\bin\mysql\mysql5.6.17\data\auto.cnf wait/io/file/mysys/cnf 313783168 5 372200576 376992 74439904 239526496 3 85532128 376992 28510592 77758912 56 0 0 0 0 0 0 2 286668448 47141952 143334048 239526496
c:\wamp\bin\mysql\mysql5.6.17\data\Server.pid wait/io/file/sql/pid 313783872 3 339508928 47432000 113169408 219850048 0 0 0 0 0 0 1 72226880 72226880 72226880 72226880 5 2 267282048 47432000 133641024 219850048
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.frm wait/io/file/sql/FRM 313784576 13 421745632 673024 32441728 216562720 7 157646368 5553152 22520608 79596000 3222 0 0 0 0 0 0 6 264099264 673024 44016544 216562720
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.MYI wait/io/file/myisam/kfile 313785280 4 152947872 969408 38236704 74656384 2 80541472 5885088 40270560 74656384 680 0 0 0 0 0 0 2 72406400 969408 36203200 71436992
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.MYD wait/io/file/myisam/dfile 313785984 364411 2223942154720 457600 6102624 4087113888 181049 884289795488 3324288 4884000 412536960 8959119 0 0 0 0 0 0 183362 1339652359232 457600 7305760 4087113888
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.frm wait/io/file/sql/FRM 313786688 13 404434624 652256 31110112 182513056 7 177173216 5427488 25310208 101775872 2021 0 0 0 0 0 0 6 227261408 652256 37876608 182513056
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.MYI wait/io/file/myisam/kfile 313787392 4 157286272 1101056 39321568 73776736 2 82408480 9978144 41204064 72430336 605 0 0 0 0 0 0 2 74877792 1101056 37438720 73776736
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.MYD wait/io/file/myisam/dfile 313788096 32539 941234505024 460768 28926304 4516190624 35 4930981088 9056960 140884832 4516190624 30800 0 0 0 0 0 0 32504 936303523936 460768 28805568 3397140736
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/sql/FRM 313788800 13 256343648 673024 19718688 66877184 7 146196160 5185312 20884864 66877184 1489 0 0 0 0 0 0 6 110147488 673024 18357856 58433760
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/myisam/kfile 313789504 4 165218240 1103872 41304384 81134240 2 91301056 10166816 45650528 81134240 522 0 0 0 0 0 0 2 73917184 1103872 36958592 72813312
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/myisam/dfile 313790208 32436 917526747456 484704 28287072 11115542240 32 3172286304 12323872 99133760 2667619328 22176 0 0 0 0 0 0 32404 914354461152 484704 28217024 11115542240
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 313790912 13 382810208 718080 29446912 185347360 7 146473184 5298656 20924640 71613696 576 0 0 0 0 0 0 6 236337024 718080 39389504 185347360
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 313791616 9 296429056 1005312 32936288 83560576 4 115691488 5747456 28922784 83560576 742 0 0 0 0 0 0 5 180737568 1005312 36147232 78052480
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 313792320 32308 908591327424 23119008 28122688 11330254144 0 0 0 0 0 0 0 0 0 0 0 0 32308 908591327424 23119008 28122688 11330254144
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 313793024 13 288917376 691328 22224224 99235840 7 143440352 5134272 20491328 69207776 742 0 0 0 0 0 0 6 145477024 691328 24246112 99235840
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 313793728 9 262194592 1008128 29132576 70518624 4 100785344 5660864 25196160 69734368 742 0 0 0 0 0 0 5 161409248 1008128 32281568 70518624
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 313794432 32291 921550259872 23487200 28538752 41136565184 0 0 0 0 0 0 0 0 0 0 0 0 32291 921550259872 23487200 28538752 41136565184
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 313795136 13 333074368 684992 25621024 141294208 7 143031680 5382432 20432896 64507520 581 0 0 0 0 0 0 6 190042688 684992 31673664 141294208
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 313795840 9 297730752 1044384 33080960 86588480 4 126414816 5759424 31603616 86588480 742 0 0 0 0 0 0 5 171315936 1044384 34262976 73181152
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 313796544 32298 899811710336 23400256 27859392 536635968 0 0 0 0 0 0 0 0 0 0 0 0 32298 899811710336 23400256 27859392 536635968

|
|
|
Number of rows:
Query results operations Print view Print view Print view (with full texts) Print view (with full texts) Export Export Display chart Display chart Create view Create view