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 27039 361312597595887 6515382 13362646318 929857253909 12 466219237761 971185952 38851603079 96361538272 2310144 13511 14167843110938 6600476 1048615259 357551607375 677904384 13516 346678535247188 6515382 25649492012 929857253909
C:\xampp\mysql\data\ib_logfile0 wait/io/file/innodb/innodb_log_file 2367388455168 64371 590604095648763 2139274 9175002558 1111932723380 8 89629455458 2139274 11203681729 80423720958 70656 33934 796422188815 2513796 23469684 43764452866 34610688 30429 589718044004490 4369062 19380132213 1111932723380
C:\xampp\mysql\data\ib_logfile1 wait/io/file/innodb/innodb_log_file 2367388455872 51259 433234307549644 2383716 8451868055 234328519293 0 0 0 0 0 0 26956 597328588443 2383716 22159128 11985070934 28022272 24303 432636978961201 4207004 17801792983 234328519293
C:\xampp\mysql\data\undo_001 wait/io/file/innodb/innodb_data_file 2367388456576 23963 120425006302393 5379892 5025455978 2094662569154 396 4125059567149 9506680 10416816969 2094662569154 6537216 17805 522474067077 5379892 29344151 877276322 291717120 5762 115777472668167 5789102 20093278740 415237877119
C:\xampp\mysql\data\undo_002 wait/io/file/innodb/innodb_data_file 2367388457280 23939 138983626846852 5677450 5805740587 630939000303 391 830240621359 10144072 2123377411 118565642516 6455296 17659 546392717861 5677450 30941154 2303670188 289325056 5889 137606993507632 5793438 23366784216 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 1700 7984580476161 6305628 4696811839 96912656609 0 0 0 0 0 0 1482 2081957524661 6305628 1404829583 77088657832 38305792 218 5902622951500 20943422 27076251999 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 977 4255427257768 4411880 4355606037 91606205880 873 2549436999413 7511578 2920317138 89753441752 14352384 51 10925867705 8274714 214232546 2648730694 835584 53 1695064390650 4411880 31982346840 91606205880
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 3340 45052936701900 3212434 13488903050 765803537281 3 25845084094 67197702 8615027941 19854946164 49152 1666 88734924024 7714828 53262069 2538181664 27295744 1671 44938356693782 3212434 26893091771 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