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 `x$io_global_by_wait_by_latency`
event_name total total_latency avg_latency max_latency read_latency write_latency misc_latency count_read total_read avg_read count_write total_written avg_written
innodb/innodb_log_file 4077 21718554382800 5327092056 192958303296 981823920 824856049776 20892716509104 8 70656 8832.0000 2606 4105728 1575.4904
innodb/innodb_data_file 6444 13442095832352 2085986232 225338121360 313980671664 179968180128 12948146980560 1441 28721152 19931.4032 3625 127057920 35050.4607
sql/binlog 685 1603810107504 2341328616 42475833312 813703968 3267778800 1599728624736 118 1068 9.0508 103 33012 320.5049
innodb/innodb_temp_file 125 631835202240 5054681544 67591920000 0 3534371808 628300830432 0 0 0.0000 52 2359296 45371.0769
sql/ERRMSG 60 58842495888 980708256 13525353072 26113276464 0 32729219424 36 3672054 102001.5000 0 0 0.0000
sql/binlog_index 38 42252320352 1111903056 22438647264 292516752 0 41959803600 9 288 32.0000 0 0 0.0000
sql/io_cache 30 2252528784 75084240 1025559744 104088864 805694736 1342745184 8 557824 69728.0000 12 549076 45756.3333
csv/metadata 8 1331884224 166485528 581799504 1060754640 0 271129584 2 70 35.0000 0 0 0.0000
mysys/cnf 5 800742624 160148472 783989184 785266944 0 15475680 3 56 18.6667 0 0 0.0000
sql/casetest 15 755088048 50338992 682369248 0 0 755088048 0 0 0.0000 0 0 0.0000
csv/data 4 616528176 154131912 336347616 0 0 616528176 0 0 0.0000 0 0 0.0000
mysys/charset 3 260045280 86681760 247510032 247510032 0 12535248 1 19495 19495.0000 0 0 0.0000
sql/misc 9 155208240 17245272 38439456 0 0 155208240 0 0 0.0000 0 0 0.0000
sql/pid 3 33473088 11157696 20037600 0 11554224 21918864 0 0 0.0000 1 4 4.0000
Query results operations