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 (144 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 312873024 5 613575422 21279546 122714802 360470892 3 411089327 21279546 137029658 360470892 60783 0 0 0 0 0 0 2 202486095 53088023 101242871 149398072
c:\wamp\bin\mysql\mysql5.6.17\share\charsets\Index... wait/io/file/mysys/charset 312873728 3 268748784 44563426 89582928 143414722 1 143414722 143414722 143414722 143414722 18305 0 0 0 0 0 0 2 125334062 44563426 62667031 80770636
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.fr... wait/io/file/sql/FRM 312875840 13 122137565104 720120 9395197017 121624991454 7 168404298 5334889 24057656 80857474 1104 0 0 0 0 0 0 6 121969160806 720120 20328193350 121624991454
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.MY... wait/io/file/myisam/kfile 312876544 9 504098826 1004991 56010863 280462736 4 316717601 5571752 79179312 280462736 728 0 0 0 0 0 0 5 187381225 1004991 37476245 92436580
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.MY... wait/io/file/myisam/dfile 312877248 202426 6400255751772 2970495 31617504 180175782293 0 0 0 0 0 0 0 0 0 0 0 0 202426 6400255751772 2970495 31617504 180175782293
c:\wamp\bin\mysql\mysql5.6.17\data\auto.cnf wait/io/file/mysys/cnf 312877952 5 350317200 396066 70063440 219193585 3 77170036 396066 25723110 69656784 56 0 0 0 0 0 0 2 273147164 53953579 136573582 219193585
c:\wamp\bin\mysql\mysql5.6.17\data\Server.pid wait/io/file/sql/pid 312878656 3 35795585172 60132844 11931861724 35638533001 0 0 0 0 0 0 1 96919327 96919327 96919327 96919327 5 2 35698665845 60132844 17849332746 35638533001
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.frm wait/io/file/sql/FRM 312879360 13 319726220 672112 24594216 114561914 7 156184144 4344724 22311718 81445572 3222 0 0 0 0 0 0 6 163542076 672112 27256895 114561914
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.MYI wait/io/file/myisam/kfile 312880064 4 204581150 1038173 51145111 112492981 2 118205933 5712952 59102790 112492981 680 0 0 0 0 0 0 2 86375217 1038173 43187432 85337044
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.MYD wait/io/file/myisam/dfile 312880768 1546785 11628484811254 458900 7517841 71280958180 738524 3588778856020 3291725 4859045 248198183 35398893 0 0 0 0 0 0 808261 8039705955234 458900 9946834 71280958180
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.frm wait/io/file/sql/FRM 312881472 13 322216988 624104 24785895 145623090 7 131040660 4395556 18719943 69202473 2021 0 0 0 0 0 0 6 191176328 624104 31862486 145623090
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.MYI wait/io/file/myisam/kfile 312882176 4 169659919 1116186 42414715 89207689 2 79336044 8257376 39668022 71078668 605 0 0 0 0 0 0 2 90323875 1116186 45161761 89207689
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.MYD wait/io/file/myisam/dfile 312882880 222098 6942653078027 468078 31259209 153627265454 2781 131780048858 7354402 47385661 102506675599 2447280 0 0 0 0 0 0 219317 6810873029169 468078 31054822 153627265454
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/sql/FRM 312883584 13 246426476 650932 18955747 68861475 7 134276964 4149515 19182373 68861475 1489 0 0 0 0 0 0 6 112149512 650932 18691350 59607933
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/myisam/kfile 312884288 4 154868866 1119010 38717040 73101358 2 80648498 7984154 40324249 72664344 522 0 0 0 0 0 0 2 74220368 1119010 37110184 73101358
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/myisam/dfile 312884992 203896 6507374585583 519263 31915083 143811201363 1182 84359517459 10384907 71369893 67648456864 819126 0 0 0 0 0 0 202714 6423015068124 519263 31684927 143811201363
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 312885696 13 331918487 684114 25532137 146415575 7 134323207 4197523 19188727 70555522 576 0 0 0 0 0 0 6 197595280 684114 32932429 146415575
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 312886400 9 277858302 1050175 30873027 77259698 4 97453416 5640940 24363354 71811143 742 0 0 0 0 0 0 5 180404886 1050175 36080836 77259698
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 312887104 200602 6014575671176 24048831 29982408 86043166138 0 0 0 0 0 0 0 0 0 0 0 0 200602 6014575671176 24048831 29982408 86043166138
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 312887808 13 303327252 639283 23332594 98389572 7 157703809 3963837 22528813 97037935 742 0 0 0 0 0 0 6 145623443 639283 24270515 98389572
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 312888512 9 259018339 1065354 28779737 74364392 4 96952156 5709775 24238039 72114017 742 0 0 0 0 0 0 5 162066183 1065354 32413166 74364392
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 312889216 202676 6257431627012 23976819 30873733 133847181911 0 0 0 0 0 0 0 0 0 0 0 0 202676 6257431627012 23976819 30873733 133847181911
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 312889920 13 325726867 702117 25055587 142742963 7 132851903 4317896 18978692 62419578 581 0 0 0 0 0 0 6 192874964 702117 32145592 142742963
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 312890624 9 259288384 1041350 28809742 71636761 4 98053516 5620113 24513379 68879478 742 0 0 0 0 0 0 5 161234868 1041350 32246903 71636761
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 312891328 201864 6212927796590 24052008 30777717 120111312981 0 0 0 0 0 0 0 0 0 0 0 0 201864 6212927796590 24052008 30777717 120111312981

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