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.0007 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 47973 1499887515243 2607258 31265210 49355506547 0 0 0 0 0 0 0 0 0 0 0 0 47973 1499887515243 2607258 31265210 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 428508 3060581299293 459253 7142249 3458640344 207409 1127531298215 3399743 5436200 426521075 10291645 0 0 0 0 0 0 221099 1933050001078 459253 8742751 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 48338 1823469496351 471255 37722992 315293110095 66 27166607484 9676436 411614944 20782651198 58080 0 0 0 0 0 0 48272 1796302888867 471255 37211848 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 48012 1429891946200 528088 29781904 14057663730 31 5454070978 13886314 175937671 4873362327 21483 0 0 0 0 0 0 47981 1424437875222 528088 29687300 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 47905 1537867698807 22167694 32102173 129618632682 0 0 0 0 0 0 0 0 0 0 0 0 47905 1537867698807 22167694 32102173 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 47954 1852312365636 22494572 38626672 393515893053 0 0 0 0 0 0 0 0 0 0 0 0 47954 1852312365636 22494572 38626672 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 47962 1576224552786 22068501 32863947 76679066656 0 0 0 0 0 0 0 0 0 0 0 0 47962 1576224552786 22068501 32863947 76679066656

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