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 2495 3256254735360 0 1305111984 233600086896 1370 27557888 20115.2467 744 32849920 44153.1183 60407808
sql/io_cache 186 20788729632 0 111767304 16944504192 80 4505470 56318.3750 76 4505470 59282.5000 9010940
innodb/innodb_temp_file 285 518593266576 0 1819625280 28346394912 0 0 0.0000 218 4685824 21494.6055 4685824
sql/ERRMSG 70 43224396336 2834832 617491248 2517808128 42 4296007 102285.8810 0 0 0.0000 4296007
innodb/innodb_log_file 563 3513252433152 216480 6240235056 176080285392 8 70656 8832.0000 323 262656 813.1765 333312
mysys/charset 3 266393424 1919808 88797720 255726240 1 19495 19495.0000 0 0 0.0000 19495
myisam/dfile 28 1662396912 208560 59371224 1644325584 25 1675 67.0000 0 0 0.0000 1675
sql/binlog 713 36687300672 0 51454656 17030106192 175 1296 7.4057 3 156 52.0000 1452
myisam/kfile 4 263652048 582912 65912880 243558480 2 392 196.0000 0 0 0.0000 392
sql/binlog_index 38 41669900448 0 1096576272 23833197168 9 288 32.0000 0 0 0.0000 288
mysys/cnf 5 800362992 195888 160072440 783258432 3 56 18.6667 0 0 0.0000 56
sql/pid 3 19198080 847440 6399360 14176272 0 0 0.0000 1 4 4.0000 4
sql/casetest 15 1042040208 0 69469224 980291664 0 0 0.0000 0 0 0.0000 0
sql/misc 1 13551120 0 13551120 13551120 0 0 0.0000 0 0 0.0000 0
Query results operations