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
Customise 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 2801 2764200691296 0 986861832 266978139648 1325 26820608 20241.9683 971 40714240 41930.2163 67534848
innodb/innodb_temp_file 210 606386847264 0 2887556232 37452080688 0 0 0.0000 140 3604480 25746.2857 3604480
sql/io_cache 56 977151648 0 17449080 79895904 20 1517632 75881.6000 26 1517632 58370.4615 3035264
sql/ERRMSG 45 28426505712 2857008 631699992 3913899264 27 2771926 102663.9259 0 0 0.0000 2771926
innodb/innodb_log_file 1614 7786386892944 222288 4824279240 615852894096 8 70656 8832.0000 1120 2178560 1945.1429 2249216
mysys/charset 3 301075632 2166912 100358544 288086304 1 19495 19495.0000 0 0 0.0000 19495
sql/binlog 191 516071576064 0 2701945224 37810554144 28 708 25.2857 36 7057 196.0278 7765
sql/binlog_index 38 52406859648 0 1379127816 30600616464 9 288 32.0000 0 0 0.0000 288
csv/metadata 8 1892637120 2098272 236579640 668041968 2 70 35.0000 0 0 0.0000 70
mysys/cnf 5 711900816 382800 142379952 665378208 3 56 18.6667 0 0 0.0000 56
sql/pid 3 55594176 2836944 18531216 39417840 0 0 0.0000 1 4 4.0000 4
sql/casetest 15 788622912 0 52574808 724119792 0 0 0.0000 0 0 0.0000 0
sql/misc 4 66925056 0 16731264 28787616 0 0 0.0000 0 0 0.0000 0
csv/data 4 590468208 0 147616920 480858576 0 0 0.0000 0 0 0.0000 0
myisam/dfile 4 345369552 0 86342256 281897616 0 0 0.0000 0 0 0.0000 0
myisam/kfile 4 778643712 0 194660928 692359536 0 0 0.0000 0 0 0.0000 0
Query results operations