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.0008 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 97670 2948371864893 2616705 30187053 15980460327 0 0 0 0 0 0 0 0 0 0 0 0 97670 2948371864893 2616705 30187053 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 1119702 10516357811466 462267 9392058 516877566309 499685 2972893345812 3347487 5949450 30825423720 28737314 0 0 0 0 0 0 620017 7543464465654 462267 12166362 516877566309
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 133841 3840324989085 465426 28692846 125297991585 6332 150940259730 7655661 23837463 44838594684 5572160 0 0 0 0 0 0 127509 3689384729355 465426 28933983 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 103324 3634436117403 519129 35175114 126846583227 2767 159457855635 10603359 57628233 54356799978 1917531 0 0 0 0 0 0 100557 3474978261768 519129 34557003 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 97098 3428888489325 23187762 35313408 340958482488 0 0 0 0 0 0 0 0 0 0 0 0 97098 3428888489325 23187762 35313408 340958482488
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 97008 2873001175785 23321844 29615976 25658185293 0 0 0 0 0 0 0 0 0 0 0 0 97008 2873001175785 23321844 29615976 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 97034 3288257755614 23462244 33887646 100435639824 0 0 0 0 0 0 0 0 0 0 0 0 97034 3288257755614 23462244 33887646 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