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.0008 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 39813 1469831461472 2581920 36918112 101740300288 0 0 0 0 0 0 0 0 0 0 0 0 39813 1469831461472 2581920 36918112 101740300288
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 396857 3053845641088 460768 7695072 27600882848 183917 1090359382112 3413696 5928384 165254144 10022157 0 0 0 0 0 0 212940 1963486258976 460768 9220640 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 43282 1328694950176 460768 30698272 29451177536 485 34880925376 8069600 71919232 29451177536 426800 0 0 0 0 0 0 42797 1293814024800 460768 30231168 15219155424
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 41240 1513065050112 556512 36688960 224865217280 397 37260214816 11558272 93854112 31220652320 275121 0 0 0 0 0 0 40843 1475804835296 556512 36133504 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 39730 1192964531264 23894112 30026656 18677898272 0 0 0 0 0 0 0 0 0 0 0 0 39730 1192964531264 23894112 30026656 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 39641 1177036413344 24285888 29692256 15585235072 0 0 0 0 0 0 0 0 0 0 0 0 39641 1177036413344 24285888 29692256 15585235072
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 39861 1256065942560 26835072 31511040 60918738496 0 0 0 0 0 0 0 0 0 0 0 0 39861 1256065942560 26835072 31511040 60918738496

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