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 3177 4319959709810 0 1359760580 224848623580 1573 30883840 19633.7190 1011 40845312 40400.9021 71729152
sql/io_cache 861 204124813740 0 237078540 100443087800 403 20259337 50271.3077 338 20259337 59938.8669 40518674
innodb/innodb_temp_file 452 2018275953610 0 4465212105 585043208300 0 0 0.0000 360 8650752 24029.8667 8650752
sql/ERRMSG 95 60117932330 2957930 632820265 4296364440 57 5825125 102195.1754 0 0 0.0000 5825125
innodb/innodb_log_file 826 5167657098890 228430 6256243225 132438857610 8 70656 8832.0000 474 373248 787.4430 443904
mysys/charset 3 318654020 2198440 106217830 304860770 1 19495 19495.0000 0 0 0.0000 19495
myisam/kfile 16 2715485740 2077600 169717660 668714780 8 1703 212.8750 0 0 0.0000 1703
sql/binlog 777 41468961720 0 53370470 18331210170 191 1360 7.1204 3 156 52.0000 1516
sql/binlog_index 38 64456691470 0 1696228695 48781727880 9 288 32.0000 0 0 0.0000 288
myisam/dfile 17 730813820 1170770 42988830 555995440 2 123 61.5000 0 0 0.0000 123
mysys/cnf 5 385529950 234260 77105990 363506330 3 56 18.6667 0 0 0.0000 56
csv/metadata 4 13306484750 1797230 3326621055 12783680560 1 35 35.0000 0 0 0.0000 35
sql/pid 3 19855920 1029260 6618640 15939750 0 0 0.0000 1 4 4.0000 4
sql/casetest 15 828414910 0 55227590 768960570 0 0 0.0000 0 0 0.0000 0
sql/misc 1 5426670 0 5426670 5426670 0 0 0.0000 0 0 0.0000 0
csv/data 6 1212329950 0 202054815 1099909000 2 0 0.0000 0 0 0.0000 0
Query results operations