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 140550162457344 5 1329865152 3910368 265972872 520798608 3 1097783808 221148576 365927760 520798608 303507 0 0 0 0 0 0 2 232081344 3910368 116040672 228170976
/usr/share/mysql-8.0/charsets/Index.xml wait/io/file/mysys/charset 140550162458048 3 633370848 2786256 211123440 614545536 1 614545536 614545536 614545536 614545536 19495 0 0 0 0 0 0 2 18825312 2786256 9412656 16039056
/var/lib/mysql/ibdata1 wait/io/file/innodb/innodb_data_file 140550162460864 309 2509932350112 1484736 8122758336 128307061344 20 14687889744 1484736 734394408 8955393216 2441216 145 14554718112 5382432 100377288 827338512 19546112 144 2480689742256 2310000 17227011912 128307061344
/var/lib/mysql/ib_logfile0 wait/io/file/innodb/innodb_log_file 140550162461568 141 976024034832 241824 6922156032 38975384448 6 502096320 241824 83682720 499984848 4608 66 6294884640 6998112 95376864 3705882576 33792 69 969227053872 1589280 14046768648 38975384448
/var/lib/mysql/ib_logfile1 wait/io/file/innodb/innodb_log_file 140550162462272 1096 7478158624464 661584 6823137288 717043621536 2 1018381584 1646832 509190792 1016734752 66048 681 285111237312 661584 418665456 104641454016 868352 413 7192029005568 1049136 17414113728 717043621536
/var/lib/mysql/undo_001 wait/io/file/innodb/innodb_data_file 140550162462976 703 657360548064 4036032 935078760 22304264400 389 98915224320 7795920 254280576 7312969488 6422528 258 19273006368 4636896 74701440 5586165552 4227072 56 539172317376 4036032 9628077096 22304264400
/var/lib/mysql/undo_002 wait/io/file/innodb/innodb_data_file 140550162463680 722 789655411248 1361184 1093705536 24583426560 384 107177498208 6288480 279107928 13537415760 6340608 277 13457095872 4909344 48581544 3772701504 4538368 61 669020817168 1361184 10967554224 24583426560
/var/lib/mysql/ibtmp1 wait/io/file/innodb/innodb_data_file 140550162464384 147 348931617408 20869200 2373684456 317501814432 0 0 0 0 0 0 143 31269644736 20869200 218668824 3561543216 14729216 4 317661972672 22779504 79415493168 317501814432
/var/lib/mysql/#innodb_temp/temp_1.ibt wait/io/file/innodb/innodb_temp_file 140550162465088 8 67009270944 19825872 8376158736 35944301712 0 0 0 0 0 0 3 286427328 39330192 95475600 124806528 114688 5 66722843616 19825872 13344568512 35944301712
/var/lib/mysql/#innodb_temp/temp_2.ibt wait/io/file/innodb/innodb_temp_file 140550162465792 8 77516975712 10299696 9689621832 47609234112 0 0 0 0 0 0 3 214328400 39785856 71442624 133234992 114688 5 77302647312 10299696 15460529304 47609234112
/var/lib/mysql/#innodb_temp/temp_3.ibt wait/io/file/innodb/innodb_temp_file 140550162466496 8 72050561616 15215904 9006320136 39817588272 0 0 0 0 0 0 3 127217376 19546560 42405792 57164448 114688 5 71923344240 15215904 14384668848 39817588272
/var/lib/mysql/#innodb_temp/temp_4.ibt wait/io/file/innodb/innodb_temp_file 140550162467200 8 48434776896 19432512 6054347112 26781224448 0 0 0 0 0 0 3 200214960 26193552 66738144 89271072 114688 5 48234561936 19432512 9646912176 26781224448
/var/lib/mysql/#innodb_temp/temp_5.ibt wait/io/file/innodb/innodb_temp_file 140550162467904 8 49071604032 18917184 6133950504 30811539264 0 0 0 0 0 0 3 292956048 43909008 97652016 128938656 114688 5 48778647984 18917184 9755729544 30811539264
/var/lib/mysql/#innodb_temp/temp_6.ibt wait/io/file/innodb/innodb_temp_file 140550162468608 8 67791504528 20219232 8473938000 37744578960 0 0 0 0 0 0 3 261999936 56359248 87333312 121871904 114688 5 67529504592 20219232 13505900760 37744578960
/var/lib/mysql/#innodb_temp/temp_7.ibt wait/io/file/innodb/innodb_temp_file 140550162469312 8 75590883456 23440560 9448860432 38249342736 0 0 0 0 0 0 3 251034432 40861920 83677968 122687664 114688 5 75339849024 23440560 15067969752 38249342736
/var/lib/mysql/#innodb_temp/temp_8.ibt wait/io/file/innodb/innodb_temp_file 140550162470016 8 64762807296 10737936 8095350912 32249738928 0 0 0 0 0 0 3 300308448 41545152 100102728 214440336 114688 5 64462498848 10737936 12892499664 32249738928
/var/lib/mysql/#innodb_temp/temp_9.ibt wait/io/file/innodb/innodb_temp_file 140550162470720 8 51042620640 7261056 6380327448 30425303040 0 0 0 0 0 0 3 165986304 13909632 55328592 125515104 114688 5 50876634336 7261056 10175326656 30425303040
/var/lib/mysql/#innodb_temp/temp_10.ibt wait/io/file/innodb/innodb_temp_file 140550162471424 54 264548388192 4807968 4899044040 28220916768 0 0 0 0 0 0 45 118815776112 4807968 2640350328 23669160768 1064960 9 145732612080 19450992 16192512336 28220916768
/var/lib/mysql/mysql.ibd wait/io/file/innodb/innodb_data_file 140550162472128 922 1063898043648 1548624 1153902288 31580293536 350 229175719344 4175424 654787584 20278441392 5783552 484 11789236800 3590400 24357696 139502880 7929856 88 822933087504 1548624 9351512280 31580293536
/var/lib/mysql/sys/sys_config.ibd wait/io/file/innodb/innodb_data_file 140550162472832 9 1404853296 2292576 156094752 568999728 4 1107790992 32058048 276947616 568999728 114688 0 0 0 0 0 0 5 297062304 2292576 59412408 261534768
/var/lib/mysql/sakila/actor.ibd wait/io/file/innodb/innodb_data_file 140550162473536 3 406067904 3023856 135355968 388931136 1 388931136 388931136 388931136 388931136 65536 0 0 0 0 0 0 2 17136768 3023856 8568384 14112912
/var/lib/mysql/sakila/address.ibd wait/io/file/innodb/innodb_data_file 140550162474240 10 1458505488 3027024 145850496 467359728 5 1387752432 43235280 277550328 467359728 131072 0 0 0 0 0 0 5 70753056 3027024 14150400 29045280
/var/lib/mysql/sakila/category.ibd wait/io/file/innodb/innodb_data_file 140550162474944 3 379780368 3119952 126593280 365377584 1 365377584 365377584 365377584 365377584 65536 0 0 0 0 0 0 2 14402784 3119952 7201392 11282832
/var/lib/mysql/sakila/city.ibd wait/io/file/innodb/innodb_data_file 140550162475648 3 414661104 2093520 138220368 402104736 1 402104736 402104736 402104736 402104736 65536 0 0 0 0 0 0 2 12556368 2093520 6278184 10462848
/var/lib/mysql/sakila/country.ibd wait/io/file/innodb/innodb_data_file 140550162476352 3 1665616128 2997984 555205200 1654333296 1 1654333296 1654333296 1654333296 1654333296 65536 0 0 0 0 0 0 2 11282832 2997984 5641416 8284848
Query results operations