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_bytes`
event_name total total_latency min_latency avg_latency max_latency count_read total_read avg_read count_write total_written avg_written total_requested
innodb/innodb_data_file 2563 2974504278240 0 1160555616 258246555072 1439 28688384 19936.3336 726 32456704 44706.2039 61145088
sql/io_cache 962 75399753792 0 78377904 33372872016 420 22451374 53455.6524 387 22398886 57878.2584 44850260
innodb/innodb_temp_file 410 1903174211136 0 4641888240 394185231264 0 0 0.0000 317 8011776 25273.7413 8011776
sql/ERRMSG 65 58663558800 3753024 902516208 3930366000 39 3992059 102360.4872 0 0 0.0000 3992059
innodb/innodb_log_file 586 3510260464656 230208 5990205408 106825795296 8 70656 8832.0000 336 297984 886.8571 368640
mysys/charset 3 275608080 3404016 91869360 252613152 1 19495 19495.0000 0 0 0.0000 19495
sql/binlog 508 311052247440 0 612307344 220899293472 123 1235 10.0407 6 1041 173.5000 2276
sql/binlog_index 38 62476060944 0 1644106728 30830712528 9 288 32.0000 0 0 0.0000 288
csv/metadata 8 1877252784 664752 234656400 786369936 2 70 35.0000 0 0 0.0000 70
mysys/cnf 5 948244704 149424 189648888 932293296 3 56 18.6667 0 0 0.0000 56
sql/pid 3 54952656 2823744 18317376 33554400 0 0 0.0000 1 4 4.0000 4
sql/casetest 15 799340256 0 53289192 713658000 0 0 0.0000 0 0 0.0000 0
sql/misc 3 28685184 0 9561552 12468720 0 0 0.0000 0 0 0.0000 0
csv/data 4 763434672 0 190858536 662017488 0 0 0.0000 0 0 0.0000 0
Query results operations