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 (143 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 34931 1046576213865 2616705 29961009 15980460327 0 0 0 0 0 0 0 0 0 0 0 0 34931 1046576213865 2616705 29961009 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 482010 3436487431884 462618 7129161 363717296514 241287 1379864102409 3347487 5718492 30825423720 12135451 0 0 0 0 0 0 240723 2056623329475 462618 8543340 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 36314 1121422513887 465426 30880980 44838594684 370 65650544739 7813611 177433659 44838594684 325600 0 0 0 0 0 0 35944 1055771969148 465426 29372382 3180607911
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 35092 1199644891965 519129 34185645 80050037886 307 50328297864 11489283 163935603 28442105289 212751 0 0 0 0 0 0 34785 1149316594101 519129 33040332 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 34342 1009370086101 23187762 29391687 9622652715 0 0 0 0 0 0 0 0 0 0 0 0 34342 1009370086101 23187762 29391687 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 34375 978135768792 23321844 28454517 865620756 0 0 0 0 0 0 0 0 0 0 0 0 34375 978135768792 23321844 28454517 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 34392 1103729126526 23462244 32092281 72335308500 0 0 0 0 0 0 0 0 0 0 0 0 34392 1103729126526 23462244 32092281 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