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.0006 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 315568192 5 548221708 13277389 109644271 340103851 3 384859309 13277389 128286201 340103851 60783 0 0 0 0 0 0 2 163362399 25255385 81681023 138107014
c:\wamp\bin\mysql\mysql5.6.17\share\charsets\Index... wait/io/file/mysys/charset 315568896 3 291222882 23061843 97074294 189019851 1 189019851 189019851 189019851 189019851 18305 0 0 0 0 0 0 2 102203031 23061843 51101339 79141188
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.fr... wait/io/file/sql/FRM 315571008 13 5395493099 698940 415037632 5199512088 7 167215747 5418903 23887863 85691456 1104 0 0 0 0 0 0 6 5228277352 698940 871379441 5199512088
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.MY... wait/io/file/myisam/kfile 315571712 9 12078311893 1011345 1342034341 10591726170 4 10684123567 5850975 2671030627 10591726170 728 0 0 0 0 0 0 5 1394188326 1011345 278837524 1284831750
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.MY... wait/io/file/myisam/dfile 315572416 53833 1532933338786 2163537 28475451 576204018 0 0 0 0 0 0 0 0 0 0 0 0 53833 1532933338786 2163537 28475451 576204018
c:\wamp\bin\mysql\mysql5.6.17\data\auto.cnf wait/io/file/mysys/cnf 315573120 5 299320702 342057 59863858 207850283 3 64763145 342057 21587715 57126696 56 0 0 0 0 0 0 2 234557557 26707274 117278602 207850283
c:\wamp\bin\mysql\mysql5.6.17\data\Server.pid wait/io/file/sql/pid 315573824 3 662739613843 57861642 220913204379 662307133775 0 0 0 0 0 0 1 374618426 374618426 374618426 374618426 5 2 662364995417 57861642 331182497532 662307133775
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.frm wait/io/file/sql/FRM 315574528 13 2994823407 630105 230370977 2804606533 7 2839799221 4056676 405685603 2804606533 3222 0 0 0 0 0 0 6 155024186 630105 25837129 127890841
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.MYI wait/io/file/myisam/kfile 315575232 4 636432878 1236206 159108043 552154834 2 559031980 6877146 279515990 552154834 680 0 0 0 0 0 0 2 77400898 1236206 38700449 76164692
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.MYD wait/io/file/myisam/dfile 315575936 524097 3514160809869 462077 6704882 1334925627 254743 1261444320627 3471402 4951531 193316214 12565800 0 0 0 0 0 0 269354 2252716489242 462077 8363276 1334925627
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.frm wait/io/file/sql/FRM 315576640 13 383223154 627281 29478677 170446403 7 186264686 3981840 26609140 141980483 2021 0 0 0 0 0 0 6 196958468 627281 32826176 170446403
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.MYI wait/io/file/myisam/kfile 315577344 4 266960133 1089005 66739945 157420703 2 180017645 22596942 90008646 157420703 605 0 0 0 0 0 0 2 86942488 1089005 43471244 85853483
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.MYD wait/io/file/myisam/dfile 315578048 57333 1646565933690 470902 28719021 8004943935 502 13446252551 7552082 26785287 8004943935 441760 0 0 0 0 0 0 56831 1633119681139 470902 28736318 1172289349
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/sql/FRM 315578752 13 449977572 738123 34613415 283892131 7 363065442 5307708 51866290 283892131 1489 0 0 0 0 0 0 6 86912130 738123 14485355 60462899
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/myisam/kfile 315579456 4 193898311 1050175 48474313 110406398 2 120755299 10348901 60377473 110406398 522 0 0 0 0 0 0 2 73143012 1050175 36571506 72092837
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/myisam/dfile 315580160 54556 1541654351693 489258 28258003 5625688282 296 9940138296 11171038 33581243 5625688282 205128 0 0 0 0 0 0 54260 1531714213397 489258 28229057 1094957639
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 315580864 13 325911486 704941 25070060 152026157 7 148627120 5482090 21232244 69503582 576 0 0 0 0 0 0 6 177284366 704941 29547159 152026157
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 315581568 9 5236370583 1038173 581818836 3501646687 4 3586914896 5937813 896728724 3501646687 742 0 0 0 0 0 0 5 1649455687 1038173 329890855 1553016793
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 315582272 53574 1489570711474 21639606 27803692 346548572 0 0 0 0 0 0 0 0 0 0 0 0 53574 1489570711474 21639606 27803692 346548572
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 315582976 13 267890994 692939 20606728 100420734 7 142094855 5157683 20299265 67328043 742 0 0 0 0 0 0 6 125796139 692939 20965729 100420734
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 315583680 9 47492778144 1044174 5276975114 37983253958 4 38070946218 5823794 9517736378 37983253958 742 0 0 0 0 0 0 5 9421831926 1044174 1884366244 9332380667
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 315584384 53529 1515301241181 22029671 28307776 1000600739 0 0 0 0 0 0 0 0 0 0 0 0 53529 1515301241181 22029671 28307776 1000600739
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 315585088 13 314167176 750125 24166380 145737462 7 143336709 5517743 20476471 65332887 581 0 0 0 0 0 0 6 170830467 750125 28471568 145737462
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 315585792 9 42569960164 1020170 4729995260 28492192731 4 13989495547 5784964 3497373622 13904890272 742 0 0 0 0 0 0 5 28580464617 1020170 5716092641 28492192731
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 315586496 53730 1551106796838 21900473 28868340 13228037482 0 0 0 0 0 0 0 0 0 0 0 0 53730 1551106796838 21900473 28868340 13228037482

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