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 30293 902815072965 2616705 29802708 15980460327 0 0 0 0 0 0 0 0 0 0 0 0 30293 902815072965 2616705 29802708 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 449390 3146563531566 465426 7001748 363717296514 227004 1298962240524 3347487 5722002 30825423720 11358773 0 0 0 0 0 0 222386 1847601291042 465426 8307819 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 30611 961682272785 465426 31415904 44838594684 171 63517559859 7962786 371447505 44838594684 150480 0 0 0 0 0 0 30440 898164712926 465426 29505762 421513794
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 30123 1055385868095 519129 35035767 80050037886 162 48265055631 11489283 297932310 28442105289 112266 0 0 0 0 0 0 29961 1007120812464 519129 33614217 80050037886
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 29717 862256491902 23187762 29015415 9622652715 0 0 0 0 0 0 0 0 0 0 0 0 29717 862256491902 23187762 29015415 9622652715
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 29749 843847687917 23321844 28365363 865620756 0 0 0 0 0 0 0 0 0 0 0 0 29749 843847687917 23321844 28365363 865620756
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 29728 960193811304 23462244 32299020 72335308500 0 0 0 0 0 0 0 0 0 0 0 0 29728 960193811304 23462244 32299020 72335308500

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