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.0009 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 318201920 5 375688989 10463310 75137517 123409494 3 208004355 10463310 69334785 120862287 60783 0 0 0 0 0 0 2 167684634 44275140 83842317 123409494
c:\wamp\bin\mysql\mysql5.6.17\share\charsets\Index... wait/io/file/mysys/charset 318202624 3 239378490 44173701 79792830 116935650 1 116935650 116935650 116935650 116935650 18305 0 0 0 0 0 0 2 122442840 44173701 61221420 78269139
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.fr... wait/io/file/sql/FRM 318204736 13 549142659 677079 42241446 306205380 7 178547733 5662683 25506819 119318940 1104 0 0 0 0 0 0 6 370594926 677079 61765821 306205380
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.MY... wait/io/file/myisam/kfile 318205440 9 2580541821 1026324 286726635 2336390784 4 111680478 5435937 27919944 92300013 728 0 0 0 0 0 0 5 2468861343 1026324 493772058 2336390784
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.MY... wait/io/file/myisam/dfile 318206144 35019 1132203238452 2595645 32330961 53143393680 0 0 0 0 0 0 0 0 0 0 0 0 35019 1132203238452 2595645 32330961 53143393680
c:\wamp\bin\mysql\mysql5.6.17\data\auto.cnf wait/io/file/mysys/cnf 318206848 5 355484025 405756 71096805 226465551 3 79984476 405756 26661258 72931482 56 0 0 0 0 0 0 2 275499549 49033998 137749599 226465551
c:\wamp\bin\mysql\mysql5.6.17\data\Server.pid wait/io/file/sql/pid 318207552 3 327214147338 49851126 109071382329 327091319802 0 0 0 0 0 0 1 72976410 72976410 72976410 72976410 5 2 327141170928 49851126 163570585464 327091319802
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.frm wait/io/file/sql/FRM 318208256 13 414171927 698139 31859217 209423097 7 156562146 5298696 22365720 76941657 3222 0 0 0 0 0 0 6 257609781 698139 42934671 209423097
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.MYI wait/io/file/myisam/kfile 318208960 4 156726063 1085994 39181428 75927267 2 81891108 5963841 40945554 75927267 680 0 0 0 0 0 0 2 74834955 1085994 37417302 73748961
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.MYD wait/io/file/myisam/dfile 318209664 192857 2269221335199 462267 11766222 183731976675 77479 453572414100 3433833 5853978 209943630 4452224 0 0 0 0 0 0 115378 1815648921099 462267 15736383 183731976675
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.frm wait/io/file/sql/FRM 318210368 13 370926972 725166 28532790 181777986 7 144855594 5626881 20693556 67767219 2021 0 0 0 0 0 0 6 226071378 725166 37678446 181777986
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.MYI wait/io/file/myisam/kfile 318211072 4 153775908 1089153 38443977 71768268 2 80918487 10245339 40459068 70673148 605 0 0 0 0 0 0 2 72857421 1089153 36428535 71768268
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.MYD wait/io/file/myisam/dfile 318211776 47706 1481025713076 465426 31044546 106337215530 2054 29618190459 7658469 14419431 6606428985 1807520 0 0 0 0 0 0 45652 1451407522617 465426 31792527 106337215530
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/sql/FRM 318212480 13 251005014 706914 19307808 65481858 7 141343137 5250960 20191626 65481858 1489 0 0 0 0 0 0 6 109661877 706914 18276921 57178953
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/myisam/kfile 318213184 4 151537932 1071252 37884483 70852158 2 80757378 9905220 40378689 70852158 522 0 0 0 0 0 0 2 70780554 1071252 35390277 69709302
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/myisam/dfile 318213888 36812 1538934232563 513162 41805153 276238958580 705 18013874580 11050884 25551396 7280665587 488565 0 0 0 0 0 0 36107 1520920357983 513162 42122457 276238958580
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 318214592 13 423349875 743067 32565078 184639338 7 187224102 5811858 26746200 64529946 576 0 0 0 0 0 0 6 236125773 743067 39354120 184639338
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 318215296 9 9264833136 1065285 1029425787 9059777181 4 91462176 5880303 22865544 70586802 742 0 0 0 0 0 0 5 9173370960 1065285 1834674192 9059777181
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 318216000 34792 1270840795848 23671089 36526464 153037236222 0 0 0 0 0 0 0 0 0 0 0 0 34792 1270840795848 23671089 36526464 153037236222
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 318216704 13 284670126 700947 21897486 99156798 7 138827871 5060016 19832553 64670346 742 0 0 0 0 0 0 6 145842255 700947 24306750 99156798
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 318217408 9 3220225983 1047384 357802731 3022792695 4 89594154 5373108 22398363 69975009 742 0 0 0 0 0 0 5 3130631829 1047384 626126085 3022792695
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 318218112 34857 1205871357483 23229531 34594560 84305586105 0 0 0 0 0 0 0 0 0 0 0 0 34857 1205871357483 23229531 34594560 84305586105
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 318218816 13 329950881 727974 25380810 139045842 7 142808211 5313789 20401173 65386386 581 0 0 0 0 0 0 6 187142670 727974 31190211 139045842
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 318219520 9 60369391368 1047384 6707710035 60167754855 4 94484286 5704452 23620896 71063811 742 0 0 0 0 0 0 5 60274907082 1047384 12054981276 60167754855
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 318220224 35641 1400528050155 23584392 39295152 104683201038 0 0 0 0 0 0 0 0 0 0 0 0 35641 1400528050155 23584392 39295152 104683201038

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