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 (141 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 309981248 5 514255716 13783770 102851073 241229664 3 277249284 13783770 92416194 241229664 60783 0 0 0 0 0 0 2 237006432 44275140 118503216 192731292
c:\wamp\bin\mysql\mysql5.6.17\share\charsets\Index... wait/io/file/mysys/charset 309981952 3 297690471 42419403 99230157 144037413 1 144037413 144037413 144037413 144037413 18305 0 0 0 0 0 0 2 153653058 42419403 76826529 111233655
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.fr... wait/io/file/sql/FRM 309984064 13 497040570 659178 38233728 287504100 7 155425257 5149521 22203558 77794587 1104 0 0 0 0 0 0 6 341615313 659178 56935710 287504100
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.MY... wait/io/file/myisam/kfile 309984768 9 7566949611 1109862 840772062 6448450554 4 6536809539 5850468 1634202297 6448450554 728 0 0 0 0 0 0 5 1030140072 1109862 206027874 908612991
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\plugin.MY... wait/io/file/myisam/dfile 309985472 64417 1941050649330 2616705 30132297 15980460327 0 0 0 0 0 0 0 0 0 0 0 0 64417 1941050649330 2616705 30132297 15980460327
c:\wamp\bin\mysql\mysql5.6.17\data\auto.cnf wait/io/file/mysys/cnf 309986176 5 338734305 387855 67746861 211345173 3 78710346 387855 26236548 71678412 56 0 0 0 0 0 0 2 260023959 48678786 130011804 211345173
c:\wamp\bin\mysql\mysql5.6.17\data\Server.pid wait/io/file/sql/pid 309986880 3 357217614 53506089 119072538 229102965 0 0 0 0 0 0 1 74608560 74608560 74608560 74608560 5 2 282609054 53506089 141304527 229102965
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.frm wait/io/file/sql/FRM 309987584 13 451054305 575991 34696350 214525584 7 189478926 3771144 27068418 145514421 3222 0 0 0 0 0 0 6 261575379 575991 43595604 214525584
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.MYI wait/io/file/myisam/kfile 309988288 4 169459992 1124955 42364998 90400050 2 96259644 5859594 48129822 90400050 680 0 0 0 0 0 0 2 73200348 1124955 36600174 72075393
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\user.MYD wait/io/file/myisam/dfile 309988992 729498 6059664863109 462267 8306415 363717296514 345684 2009132186022 3347487 5811858 30825423720 18374559 0 0 0 0 0 0 383814 4050532677087 462267 10553166 363717296514
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.frm wait/io/file/sql/FRM 309989696 13 431777385 566865 33213375 201753045 7 184732002 3857841 26390286 141820497 2021 0 0 0 0 0 0 6 247045383 566865 41174055 201753045
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.MYI wait/io/file/myisam/kfile 309990400 4 230794785 1113021 57698433 134797689 2 156914199 22116510 78456924 134797689 605 0 0 0 0 0 0 2 73880586 1113021 36940293 72767565
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\db.MYD wait/io/file/myisam/dfile 309991104 77237 2352064235859 465426 30452409 125297991585 2376 106869160593 7655661 44978544 44838594684 2090880 0 0 0 0 0 0 74861 2245195075266 465426 29991195 125297991585
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/sql/FRM 309991808 13 324817506 593541 24985935 140126220 7 212542785 3953313 30363255 140126220 1489 0 0 0 0 0 0 6 112274721 593541 18712161 57978531
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/myisam/kfile 309992512 4 171017028 1118637 42754257 80671032 2 89227359 9949797 44613504 79277562 522 0 0 0 0 0 0 2 81789669 1118637 40894659 80671032
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\proxies_p... wait/io/file/myisam/dfile 309993216 66904 2431317125016 519129 36340083 126846583227 1332 137343806145 11021049 103110813 54356799978 923076 0 0 0 0 0 0 65572 2293973318871 519129 34983819 126846583227
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 309993920 13 5362428474 751842 412494498 5149369017 7 156900861 5325372 22414158 75312315 576 0 0 0 0 0 0 6 5205527613 751842 867587760 5149369017
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 309994624 9 21676917951 1091961 2408546205 14073262164 4 7484112558 5647590 1871027964 7392349224 742 0 0 0 0 0 0 5 14192805393 1091961 2838560868 14073262164
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 309995328 63809 1985757840144 23187762 31120011 95526491697 0 0 0 0 0 0 0 0 0 0 0 0 63809 1985757840144 23187762 31120011 95526491697
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 309996032 13 310705902 647244 23900292 115581843 7 148518630 5071950 21216897 72314073 742 0 0 0 0 0 0 6 162187272 647244 27031212 115581843
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 309996736 9 1509588171 1089153 167732019 895882221 4 491334714 6056505 122833503 401483628 742 0 0 0 0 0 0 5 1018253457 1089153 203650551 895882221
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 309997440 63893 1903866183180 23321844 29797443 25658185293 0 0 0 0 0 0 0 0 0 0 0 0 63893 1903866183180 23321844 29797443 25658185293
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/sql/FRM 309998144 13 380922399 733941 29301480 183568788 7 147877704 5217966 21125286 70264584 581 0 0 0 0 0 0 6 233044695 733941 38840607 183568788
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/kfile 309998848 9 26364110175 1050192 2929345263 14022281871 4 14112756684 5689710 3528189171 14022281871 742 0 0 0 0 0 0 5 12251353491 1050192 2450270628 12137663889
c:\wamp\bin\mysql\mysql5.6.17\data\mysql\time_zone... wait/io/file/myisam/dfile 309999552 63924 2217901509369 23462244 34695648 100435639824 0 0 0 0 0 0 0 0 0 0 0 0 63924 2217901509369 23462244 34695648 100435639824

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