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 315756608 5 575425653 10858633 115085060 240229208 3 354995156 10858633 118331601 240229208 60783 0 0 0 0 0 0 2 220430497 25606267 110215072 194824230
c:\wamp\bin\mysql\mysql5.6.17\share\charsets\Index... wait/io/file/mysys/charset 315757312 3 467490961 23631938 155830085 292171746 1 151687277 151687277 151687277 151687277 18305 0 0 0 0 0 0 2 315803684 23631938 157901842 292171746
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.fr... wait/io/file/sql/FRM 315759424 13 911702278 672112 70130863 379380396 7 176915834 5314062 25273388 81715617 1104 0 0 0 0 0 0 6 734786444 672112 122464172 379380396
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.MY... wait/io/file/myisam/kfile 315760128 9 347437779 1104184 38604080 94993006 4 131746307 5788141 32936312 88235880 728 0 0 0 0 0 0 5 215691472 1104184 43138012 94993006
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.MY... wait/io/file/myisam/dfile 315760832 26768 849613206487 2607258 31739642 49355506547 0 0 0 0 0 0 0 0 0 0 0 0 26768 849613206487 2607258 31739642 49355506547
c:\wamp\bin\mysql\mysql5.6.17\data\auto.cnf wait/io/file/mysys/cnf 315761536 5 5194242857 372062 1038848289 5097254342 3 69650783 372062 23216810 61627446 56 0 0 0 0 0 0 2 5124592074 27337732 2562296037 5097254342
c:\wamp\bin\mysql\mysql5.6.17\data\Server.pid wait/io/file/sql/pid 315762240 3 694036830 60631280 231345610 538571747 0 0 0 0 0 0 1 94833803 94833803 94833803 94833803 5 2 599203027 60631280 299601337 538571747
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.frm wait/io/file/sql/FRM 315762944 13 24980006170 699293 1921538909 24298100185 7 24802082168 5832972 3543154545 24298100185 3222 0 0 0 0 0 0 6 177924002 699293 29653765 134527594
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.MYI wait/io/file/myisam/kfile 315763648 4 11506278217 1923144 2876569466 10298605207 2 10306829754 8224547 5153414877 10298605207 680 0 0 0 0 0 0 2 1199448463 1923144 599724055 1197525319
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.MYD wait/io/file/myisam/dfile 315764352 238419 1749379069063 462077 7337105 3458640344 113464 620434538878 3399743 5467970 426521075 5807391 0 0 0 0 0 0 124955 1128944530185 462077 9034682 3458640344
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.frm wait/io/file/sql/FRM 315765056 13 406637997 626928 31279683 184353544 7 195841223 4128688 27977015 161056603 2021 0 0 0 0 0 0 6 210796774 626928 35132678 184353544
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.MYI wait/io/file/myisam/kfile 315765760 4 170950487 1122187 42737357 82063675 2 91887312 9823637 45943656 82063675 605 0 0 0 0 0 0 2 79063175 1122187 39531411 77940988
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.MYD wait/io/file/myisam/dfile 315766464 26817 1167368671259 480080 43530901 315293110095 9 26508301667 10690605 2945366695 20782651198 7920 0 0 0 0 0 0 26808 1140860369592 480080 42556621 315293110095
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/sql/FRM 315767168 13 234512726 705294 18039359 71585929 7 149916982 5328888 21416510 71585929 1489 0 0 0 0 0 0 6 84595744 705294 14099173 59151857
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/myisam/kfile 315767872 4 158704917 1083004 39676141 75615424 2 85727109 10111685 42863378 75615424 522 0 0 0 0 0 0 2 72977808 1083004 36488904 71894804
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/myisam/dfile 315768576 26792 803502793640 528088 29990174 14057663730 10 260210420 15113695 26021042 113113908 6930 0 0 0 0 0 0 26782 803242583220 528088 29991586 14057663730
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 315769280 13 665843426 762127 51218535 389749065 7 248066161 5658943 35438023 127201079 576 0 0 0 0 0 0 6 417777265 762127 69629250 389749065
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 315769984 9 533393943 1218203 59265876 261775622 4 143363890 6193032 35840796 101818967 742 0 0 0 0 0 0 5 390030053 1218203 78005940 261775622
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 315770688 26754 918388920843 22167694 34327132 129618632682 0 0 0 0 0 0 0 0 0 0 0 0 26754 918388920843 22167694 34327132 129618632682
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 315771392 13 288590208 710942 22199111 104441404 7 157354692 5244874 22479040 74904482 742 0 0 0 0 0 0 6 131235516 710942 21872586 104441404
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 315772096 9 308415394 1032172 34268181 92628612 4 120086011 5518096 30021238 79726109 742 0 0 0 0 0 0 5 188329383 1032172 37665806 92628612
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 315772800 26772 1225335235449 22494572 45769274 393515893053 0 0 0 0 0 0 0 0 0 0 0 0 26772 1225335235449 22494572 45769274 393515893053
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 315773504 13 381928350 612102 29378778 165049386 7 207779683 3888648 29682711 165049386 581 0 0 0 0 0 0 6 174148667 612102 29024719 148344720
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 315774208 9 313785936 1004991 34865104 101368892 4 119455906 5709775 29863800 76791973 742 0 0 0 0 0 0 5 194330030 1004991 38866006 101368892
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 315774912 26765 865699787490 22068501 32344331 55920786578 0 0 0 0 0 0 0 0 0 0 0 0 26765 865699787490 22068501 32344331 55920786578

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