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 314241088 5 559692320 9762720 111938464 276380192 3 379442272 9762720 126480640 276380192 60783 0 0 0 0 0 0 2 180250048 46417888 90125024 133832160
c:\wamp\bin\mysql\mysql5.6.17\share\charsets\Index... wait/io/file/mysys/charset 314241792 3 223957536 42010848 74652512 106281824 1 106281824 106281824 106281824 106281824 18305 0 0 0 0 0 0 2 117675712 42010848 58837856 75664864
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.fr... wait/io/file/sql/FRM 314243904 13 515123488 664224 39624640 302898112 7 154889504 5224032 22127072 78097184 1104 0 0 0 0 0 0 6 360233984 664224 60038880 302898112
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.MY... wait/io/file/myisam/kfile 314244608 9 12468992448 1032416 1385443488 11267141952 4 11354777632 5750624 2838694144 11267141952 728 0 0 0 0 0 0 5 1114214816 1032416 222842752 990624096
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.MY... wait/io/file/myisam/dfile 314245312 50461 1985498688448 2581920 39346912 162804757984 0 0 0 0 0 0 0 0 0 0 0 0 50461 1985498688448 2581920 39346912 162804757984
c:\wamp\bin\mysql\mysql5.6.17\data\auto.cnf wait/io/file/mysys/cnf 314246016 5 320996544 371008 64199168 210744160 3 62311392 371008 20770464 54633920 56 0 0 0 0 0 0 2 258685152 47940992 129342400 210744160
c:\wamp\bin\mysql\mysql5.6.17\data\Server.pid wait/io/file/sql/pid 314246720 3 394977088 48150432 131658912 237744320 0 0 0 0 0 0 1 109082336 109082336 109082336 109082336 5 2 285894752 48150432 142947200 237744320
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.frm wait/io/file/sql/FRM 314247424 13 475387264 640288 36568224 225255712 7 202603456 3737184 28943200 157124704 3222 0 0 0 0 0 0 6 272783808 640288 45463968 225255712
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.MYI wait/io/file/myisam/kfile 314248128 4 177916288 1002144 44479072 96638784 2 102446080 5807296 51223040 96638784 680 0 0 0 0 0 0 2 75470208 1002144 37735104 74468064
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.MYD wait/io/file/myisam/dfile 314248832 478274 3697166206272 460768 7729920 27600882848 222646 1301228550688 3413696 5844256 165254144 11887676 0 0 0 0 0 0 255628 2395937655584 460768 9372704 27600882848
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.frm wait/io/file/sql/FRM 314249536 13 422049056 634304 32465312 198217184 7 177225664 3838912 25317952 133745568 2021 0 0 0 0 0 0 6 244823392 634304 40803840 198217184
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.MYI wait/io/file/myisam/kfile 314250240 4 234198624 1089088 58549568 138326144 2 160179712 21853568 80089856 138326144 605 0 0 0 0 0 0 2 74018912 1089088 37009280 72929824
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.MYD wait/io/file/myisam/dfile 314250944 55362 1924474607616 460768 34761408 191568290144 703 37225179904 8069600 52951712 29451177536 618640 0 0 0 0 0 0 54659 1887249427712 460768 34527680 191568290144
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/sql/FRM 314251648 13 289305280 637472 22254144 134433728 7 179334496 3886784 25618912 134433728 1489 0 0 0 0 0 0 6 109970784 637472 18328288 58322880
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/myisam/kfile 314252352 4 241873280 1035232 60468320 144022912 2 166711424 22688512 83355712 144022912 522 0 0 0 0 0 0 2 75161856 1035232 37580928 74126624
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/myisam/dfile 314253056 52391 1847328408640 556512 35260192 224865217280 579 39996746944 11456544 69078944 31220652320 401247 0 0 0 0 0 0 51812 1807331661696 556512 34882144 224865217280
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 314253760 13 434300768 631136 33407616 203144832 7 178329184 3787872 25475296 134544256 576 0 0 0 0 0 0 6 255971584 631136 42661696 203144832
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 314254464 9 5172097216 993344 574677312 3841330240 4 3953820640 5652064 988455072 3841330240 742 0 0 0 0 0 0 5 1218276576 993344 243655104 1099966912
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 314255168 50215 1513773487072 23894112 30145632 18677898272 0 0 0 0 0 0 0 0 0 0 0 0 50215 1513773487072 23894112 30145632 18677898272
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 314255872 13 327805632 649088 25215520 136414080 7 179372864 3659040 25624544 136414080 742 0 0 0 0 0 0 6 148432768 649088 24738560 102063104
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 314256576 9 5914254016 987360 657139296 4750625792 4 4858131520 5747808 1214532704 4750625792 742 0 0 0 0 0 0 5 1056122496 987360 211224288 944047808
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 314257280 50028 1722848709120 24285888 34437568 202720297120 0 0 0 0 0 0 0 0 0 0 0 0 50028 1722848709120 24285888 34437568 202720297120
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 314257984 13 390614048 619168 30047072 153830688 7 187756448 3718880 26822048 144740640 581 0 0 0 0 0 0 6 202857600 619168 33809600 153830688
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 314258688 9 47175447616 1023264 5241716128 33319094336 4 13728699424 5885440 3432174592 13628904256 742 0 0 0 0 0 0 5 33446748192 1023264 6689349568 33319094336
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 314259392 50478 2369512587552 26835072 46941312 569826250400 0 0 0 0 0 0 0 0 0 0 0 0 50478 2369512587552 26835072 46941312 569826250400

|
|
|
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