Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: performance_schema »Table: file_summary_by_instance
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - 24 (227 total, Query took 0.0005 seconds.)
SELECT * FROM `file_summary_by_instance`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
|
Number of rows:
Filter rows:
Sort by key:
FILE_NAMEEVENT_NAMEOBJECT_INSTANCE_BEGINCOUNT_STARSUM_TIMER_WAITMIN_TIMER_WAITAVG_TIMER_WAITMAX_TIMER_WAITCOUNT_READSUM_TIMER_READMIN_TIMER_READAVG_TIMER_READMAX_TIMER_READSUM_NUMBER_OF_BYTES_READCOUNT_WRITESUM_TIMER_WRITEMIN_TIMER_WRITEAVG_TIMER_WRITEMAX_TIMER_WRITESUM_NUMBER_OF_BYTES_WRITECOUNT_MISCSUM_TIMER_MISCMIN_TIMER_MISCAVG_TIMER_MISCMAX_TIMER_MISC
C:\xampp\mysql\share\english\errmsg.sys wait/io/file/sql/ERRMSG 2367388450944 5 149707513750 11198804 29941502750 72355825486 3 77340489460 395140764 25780163063 56403661161 308724 0 0 0 0 0 0 2 72367024290 11198804 36183512145 72355825486
C:\xampp\mysql\share\charsets\Index.xml wait/io/file/mysys/charset 2367388451648 3 47847731274 9223214 15949243758 47816480096 1 47816480096 47816480096 47816480096 47816480096 19495 0 0 0 0 0 0 2 31251178 9223214 15625589 22027964
C:\xampp\mysql\data\ibdata1 wait/io/file/innodb/innodb_data_file 2367388454464 33625 440062433350088 6515382 13087358556 929857253909 12 466219237761 971185952 38851603079 96361538272 2310144 16804 16578265220026 6600476 986566557 357551607375 853770240 16809 423017948892301 6515382 25166157821 929857253909
C:\xampp\mysql\data\ib_logfile0 wait/io/file/innodb/innodb_log_file 2367388455168 64717 594765711856304 2139274 9190254438 1111932723380 8 89629455458 2139274 11203681729 80423720958 70656 34108 804256249769 2513796 23579439 43764452866 34699776 30601 593871826151077 4369062 19406941701 1111932723380
C:\xampp\mysql\data\ib_logfile1 wait/io/file/innodb/innodb_log_file 2367388455872 88330 726219940359139 2383716 8221667918 253164415214 0 0 0 0 0 0 46359 1009322051123 2383716 21771598 11985070934 47824384 41971 725210618308016 4207004 17278849974 253164415214
C:\xampp\mysql\data\undo_001 wait/io/file/innodb/innodb_data_file 2367388456576 30365 151585130874996 5379892 4992100214 2094662569154 396 4125059567149 9506680 10416816969 2094662569154 6537216 22633 683441544920 5379892 30196446 877276322 370819072 7336 146776629762927 5789102 20007719433 415237877119
C:\xampp\mysql\data\undo_002 wait/io/file/innodb/innodb_data_file 2367388457280 30302 173551332998312 5677450 5727388525 630939000303 391 830240621359 10144072 2123377411 118565642516 6455296 22467 706625304137 5677450 31451447 2303670188 368099328 7444 172014467072816 5793438 23107800356 630939000303
C:\xampp\mysql\data\ibtmp1 wait/io/file/innodb/innodb_data_file 2367388457984 147 233732268887 6708876 1590015265 182237899554 0 0 0 0 0 0 143 51040508018 6708876 356926512 5056334260 14729216 4 182691760869 17055114 45672940014 182237899554
C:\xampp\mysql\data\#innodb_temp\temp_1.ibt wait/io/file/innodb/innodb_temp_file 2367388458688 8 204417667727 30634382 25552208432 140303993423 0 0 0 0 0 0 3 32724164625 461489694 10908054875 31111137124 114688 5 171693503102 30634382 34338700512 140303993423
C:\xampp\mysql\data\#innodb_temp\temp_2.ibt wait/io/file/innodb/innodb_temp_file 2367388459392 8 149010816923 35534062 18626351946 64120314617 0 0 0 0 0 0 3 65162068427 441254666 21720689295 64120314617 114688 5 83848748496 35534062 16769749645 47175997070
C:\xampp\mysql\data\#innodb_temp\temp_3.ibt wait/io/file/innodb/innodb_temp_file 2367388460096 8 90405280491 40102580 11300659892 49642672403 0 0 0 0 0 0 3 4299357548 405131450 1433119002 3107867566 114688 5 86105922943 40102580 17221184426 49642672403
C:\xampp\mysql\data\#innodb_temp\temp_4.ibt wait/io/file/innodb/innodb_temp_file 2367388460800 8 102557688776 22439342 12819711097 52045962462 0 0 0 0 0 0 3 2139319799 442811019 713106419 902159542 114688 5 100418368977 22439342 20083673687 52045962462
C:\xampp\mysql\data\#innodb_temp\temp_5.ibt wait/io/file/innodb/innodb_temp_file 2367388461504 8 217097076704 20437736 27137134588 149705612956 0 0 0 0 0 0 3 41736544690 433301358 13912181473 40647060734 114688 5 175360532014 20437736 35072106186 149705612956
C:\xampp\mysql\data\#innodb_temp\temp_6.ibt wait/io/file/innodb/innodb_temp_file 2367388462208 8 142941034532 27659344 17867629181 67913189154 0 0 0 0 0 0 3 17979823723 1305978268 5993274484 14033183244 114688 5 124961210809 27659344 24992241945 67913189154
C:\xampp\mysql\data\#innodb_temp\temp_7.ibt wait/io/file/innodb/innodb_temp_file 2367388462912 8 187221161645 20927162 23402645104 65737291401 0 0 0 0 0 0 3 70412185573 392313421 23470728434 65737291401 114688 5 116808976072 20927162 23361795106 62596871857
C:\xampp\mysql\data\#innodb_temp\temp_8.ibt wait/io/file/innodb/innodb_temp_file 2367388463616 8 117659726372 20113078 14707465661 59301587466 0 0 0 0 0 0 3 72755910916 495113477 24251970215 59301587466 114688 5 44903815456 20113078 8980763037 24095104304
C:\xampp\mysql\data\#innodb_temp\temp_9.ibt wait/io/file/innodb/innodb_temp_file 2367388464320 1787 8781106414074 6305628 4913881484 96912656609 0 0 0 0 0 0 1538 2171666206427 6305628 1412006476 77088657832 41254912 249 6609440207647 20943422 26543936455 96912656609
C:\xampp\mysql\data\#innodb_temp\temp_10.ibt wait/io/file/innodb/innodb_temp_file 2367388465024 351 4938993324478 12692556 14071205899 154358917913 0 0 0 0 0 0 201 1135821919987 12692556 5650855144 154358917913 12861440 150 3803171404491 20210638 25354475992 112824760630
C:\xampp\mysql\data\mysql.ibd wait/io/file/innodb/innodb_data_file 2367388465728 990 4540397053028 4411880 4586259557 109482182945 873 2549436999413 7511578 2920317138 89753441752 14352384 58 12047552423 8274714 207716351 2648730694 950272 59 1978912501192 4411880 33540889791 109482182945
C:\xampp\mysql\data\sys\sys_config.ibd wait/io/file/innodb/innodb_data_file 2367388466432 8 1328127640 3532756 166015955 1061480984 3 1123063566 19943432 374354522 1061480984 49152 0 0 0 0 0 0 5 205064074 3532756 41012598 152190890
C:\xampp\mysql\data\phpmyadmin\pma__bookmark.ibd wait/io/file/innodb/innodb_data_file 2367388467136 8 6432131071 3228694 804016350 5313420036 3 6322334337 15452962 2107444779 5313420036 49152 0 0 0 0 0 0 5 109796734 3228694 21959130 63285004
C:\xampp\mysql\data\phpmyadmin\pma__column_info.ib... wait/io/file/innodb/innodb_data_file 2367388467840 9 51245711386 3149562 5693967721 38593111084 4 51121666014 14134276 12780416368 38593111084 65536 0 0 0 0 0 0 5 124045372 3149562 24808966 55182646
C:\xampp\mysql\data\phpmyadmin\pma__history.ibd wait/io/file/innodb/innodb_data_file 2367388468544 8 1348839357 3152272 168604818 1091496673 3 1149464115 19176502 383154705 1091496673 49152 0 0 0 0 0 0 5 199375242 3152272 39874940 141701022
C:\xampp\mysql\data\phpmyadmin\pma__pdf_pages.ibd wait/io/file/innodb/innodb_data_file 2367388469248 9 30137759324 3256336 3348639684 19748457256 4 29977778810 20423102 7494444567 19748457256 65536 0 0 0 0 0 0 5 159980514 3256336 31995886 97843466
C:\xampp\mysql\data\phpmyadmin\pma__recent.ibd wait/io/file/innodb/innodb_data_file 2367388469952 3980 52523798680880 3212434 13196934154 765803537281 3 25845084094 67197702 8615027941 19854946164 49152 1986 106586809460 7714828 53668840 2538181664 32538624 1991 52391366787326 3212434 26314096748 765803537281

|
|
|
|
Number of rows:
Filter rows:
Sort by key:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport Export Display chart Display chart Create view Create view

Bookmark this SQL query Bookmark this SQL query