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 (142 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 32022 1129695242368 2581920 35278496 101740300288 0 0 0 0 0 0 0 0 0 0 0 0 32022 1129695242368 2581920 35278496 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 336151 2535380308032 463584 7542304 3869090016 154915 927717144992 3413696 5988224 165254144 8626185 0 0 0 0 0 0 181236 1607663163040 463584 8870400 3869090016
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 34202 1058436451072 460768 30946432 29451177536 311 32971611904 8224832 106017824 29451177536 273680 0 0 0 0 0 0 33891 1025464839168 460768 30257568 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 32972 1252039390272 556512 37972704 224865217280 246 35032476512 11929280 142408288 31220652320 170478 0 0 0 0 0 0 32726 1217006913760 556512 37187744 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 31988 935093882624 23894112 29232544 12366342912 0 0 0 0 0 0 0 0 0 0 0 0 31988 935093882624 23894112 29232544 12366342912
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 31966 933176812480 24285888 29192768 11511818912 0 0 0 0 0 0 0 0 0 0 0 0 31966 933176812480 24285888 29192768 11511818912
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 32067 1015118441216 26835072 31656064 60918738496 0 0 0 0 0 0 0 0 0 0 0 0 32067 1015118441216 26835072 31656064 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