Drop files here

SQL upload ( 0 ) x -

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:
Options
Restore default values
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `file_summary_by_instance`
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
/usr/share/mysql-8.0/english/errmsg.sys wait/io/file/sql/ERRMSG 139772255593216 5 1200670416 4960032 240133872 492152496 3 966189840 226486128 322063104 492152496 303507 0 0 0 0 0 0 2 234480576 4960032 117240288 229520544
/usr/share/mysql-8.0/charsets/Index.xml wait/io/file/mysys/charset 139772255593920 3 264595584 3399264 88198440 245512080 1 245512080 245512080 245512080 245512080 19495 0 0 0 0 0 0 2 19083504 3399264 9541752 15684240
/var/lib/mysql/ibdata1 wait/io/file/innodb/innodb_data_file 139772255596736 163 2485379718096 1842720 15247728144 917164068480 20 7088072640 1842720 354403632 3143606400 2441216 73 35588402784 7017648 487512168 20685591696 16121856 70 2442703242672 1887072 34895760504 917164068480
/var/lib/mysql/ib_logfile0 wait/io/file/innodb/innodb_log_file 139772255597440 53 419964748896 238128 7923863112 120248234304 6 454574208 238128 75762192 452574672 4608 22 1654130016 11039424 75187728 620288592 11264 25 417856044672 708048 16714241544 120248234304
/var/lib/mysql/ib_logfile1 wait/io/file/innodb/innodb_log_file 139772255598144 1305 6564451852992 477312 5030231184 63871403904 2 737585904 5424144 368792952 732161760 66048 855 419141152848 477312 490223448 29003361024 1402368 448 6144573114240 485760 13715564808 63871403904
/var/lib/mysql/undo_001 wait/io/file/innodb/innodb_data_file 139772255598848 809 369256080336 645744 456435144 26914261968 388 32155278144 4436784 82874352 2280311616 6406144 387 17296032864 5341776 44692560 4731202608 6340608 34 319804769328 645744 9406022472 26914261968
/var/lib/mysql/undo_002 wait/io/file/innodb/innodb_data_file 139772255599552 785 529471977408 492096 674486472 59252743440 384 30022156032 3362832 78182544 2001813792 6340608 367 16269562848 5040816 44331144 4772153232 6012928 34 483180258528 492096 14211183888 59252743440
/var/lib/mysql/ibtmp1 wait/io/file/innodb/innodb_data_file 139772255600256 147 247028610048 5077776 1680466656 238108103376 0 0 0 0 0 0 143 8860918176 5077776 61964232 962734608 14729216 4 238167691872 9973392 59541922968 238108103376
/var/lib/mysql/#innodb_temp/temp_1.ibt wait/io/file/innodb/innodb_temp_file 139772255600960 8 40219224144 8930592 5027402952 24324905088 0 0 0 0 0 0 3 124957008 18403968 41652336 75733152 114688 5 40094267136 8930592 8018853216 24324905088
/var/lib/mysql/#innodb_temp/temp_2.ibt wait/io/file/innodb/innodb_temp_file 139772255601664 8 32072151936 10184064 4009018992 20011222704 0 0 0 0 0 0 3 133204368 29210544 44401368 70292112 114688 5 31938947568 10184064 6387789408 20011222704
/var/lib/mysql/#innodb_temp/temp_3.ibt wait/io/file/innodb/innodb_temp_file 139772255602368 8 29844713184 7896240 3730589016 17953575024 0 0 0 0 0 0 3 108246336 15286128 36081936 61365216 114688 5 29736466848 7896240 5947293264 17953575024
/var/lib/mysql/#innodb_temp/temp_4.ibt wait/io/file/innodb/innodb_temp_file 139772255603072 8 32221877424 9889968 4027734480 18584054544 0 0 0 0 0 0 3 130148832 14267616 43382856 83246592 114688 5 32091728592 9889968 6418345560 18584054544
/var/lib/mysql/#innodb_temp/temp_5.ibt wait/io/file/innodb/innodb_temp_file 139772255603776 8 27115446336 7821792 3389430792 15184094640 0 0 0 0 0 0 3 120123696 13917552 40041144 82903392 114688 5 26995322640 7821792 5399064528 15184094640
/var/lib/mysql/#innodb_temp/temp_6.ibt wait/io/file/innodb/innodb_temp_file 139772255604480 8 28035099840 8392032 3504387480 14578893648 0 0 0 0 0 0 3 149912400 15595536 49970712 110991936 114688 5 27885187440 8392032 5577037488 14578893648
/var/lib/mysql/#innodb_temp/temp_7.ibt wait/io/file/innodb/innodb_temp_file 139772255605184 8 28841059632 8993424 3605132256 14674748352 0 0 0 0 0 0 3 84299424 13373712 28099632 41875680 114688 5 28756760208 8993424 5751351936 14674748352
/var/lib/mysql/#innodb_temp/temp_8.ibt wait/io/file/innodb/innodb_temp_file 139772255605888 10 65576837568 7841328 6557683704 37300926432 0 0 0 0 0 0 4 158787552 16648896 39696888 74074176 196608 6 65418050016 7841328 10903008336 37300926432
/var/lib/mysql/#innodb_temp/temp_9.ibt wait/io/file/innodb/innodb_temp_file 139772255606592 98 370348936848 4549776 3779070768 282592760208 0 0 0 0 0 0 92 308890376784 4549776 3357503952 282592760208 1638400 6 61458560064 10024608 10243093344 27450060528
/var/lib/mysql/#innodb_temp/temp_10.ibt wait/io/file/innodb/innodb_temp_file 139772255607296 43 244678907088 4601520 5690206896 122013239040 0 0 0 0 0 0 37 171408767904 4601520 4632669360 122013239040 737280 6 73270139184 10235808 12211689864 29778527856
/var/lib/mysql/mysql.ibd wait/io/file/innodb/innodb_data_file 139772255608000 520 622996150656 277728 1198069488 128574697152 344 213405614928 2007984 620365152 128574697152 5685248 138 16490267376 3863376 119494584 3847212864 2260992 38 393100268352 277728 10344743904 55351894752
/var/lib/mysql/sys/sys_config.ibd wait/io/file/innodb/innodb_data_file 139772255608704 3 284776272 3168528 94925424 267609936 1 267609936 267609936 267609936 267609936 65536 0 0 0 0 0 0 2 17166336 3168528 8583168 13997808
/var/lib/mysql/sakila/actor.ibd wait/io/file/innodb/innodb_data_file 139772255609408 10 5143967136 1997424 514396608 2439160944 5 5041335552 23830752 1008266952 2439160944 131072 0 0 0 0 0 0 5 102631584 1997424 20526264 45354144
/var/lib/mysql/sakila/address.ibd wait/io/file/innodb/innodb_data_file 139772255610112 10 2801525232 2546544 280152312 1855297488 5 2757359616 35922480 551471712 1855297488 131072 0 0 0 0 0 0 5 44165616 2546544 8832912 19910880
/var/lib/mysql/sakila/category.ibd wait/io/file/innodb/innodb_data_file 139772255610816 9 4236906960 2224992 470767440 2057964480 4 4181674464 40941648 1045418616 2057964480 114688 0 0 0 0 0 0 5 55232496 2224992 11046288 22495440
/var/lib/mysql/sakila/city.ibd wait/io/file/innodb/innodb_data_file 139772255611520 3 1098180864 3058704 366060288 1087460352 1 1087460352 1087460352 1087460352 1087460352 65536 0 0 0 0 0 0 2 10720512 3058704 5360256 7661808
/var/lib/mysql/sakila/country.ibd wait/io/file/innodb/innodb_data_file 139772255612224 9 908144688 1541760 100904760 311009424 4 858768240 9920592 214691928 311009424 114688 0 0 0 0 0 0 5 49376448 1541760 9875184 18722352
Query results operations