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 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 33141 1075848258654 2595645 32462586 53143393680 0 0 0 0 0 0 0 0 0 0 0 0 33141 1075848258654 2595645 32462586 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 182498 2165429334744 462267 11865204 183731976675 73129 427610933568 3433833 5847309 209943630 4219992 0 0 0 0 0 0 109369 1737818401176 462267 15889419 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 45039 1372972484520 465426 30483999 106337215530 1928 28204024797 7658469 14628627 6606428985 1696640 0 0 0 0 0 0 43111 1344768459723 465426 31193019 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 34877 1472607262035 513162 42222843 276238958580 674 17535797487 11050884 26017173 7280665587 467082 0 0 0 0 0 0 34203 1455071464548 513162 42541902 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 32911 1202642135370 23671089 36541908 153037236222 0 0 0 0 0 0 0 0 0 0 0 0 32911 1202642135370 23671089 36541908 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 32983 1117548645174 23229531 33882381 84305586105 0 0 0 0 0 0 0 0 0 0 0 0 32983 1117548645174 23229531 33882381 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 33761 1341378460656 23584392 39731445 104683201038 0 0 0 0 0 0 0 0 0 0 0 0 33761 1341378460656 23584392 39731445 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