Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark 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 `PROCESSLIST`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
ID USER HOST DB COMMAND TIME STATE INFO TIME_MS STAGE MAX_STAGE PROGRESS MEMORY_USED MAX_MEMORY_USED EXAMINED_ROWS QUERY_ID INFO_BINARY TID
7276 root localhost:49671 NULL Sleep 0 NULL 17.538 0 0 0.000 69248 69248 0 369938 NULL 0
7275 pma localhost:49407 phpmyadmin Sleep 0 NULL 8.134 0 0 0.000 59848 366952 0 369944 NULL 0
7274 root localhost:49405 information_schema Sleep 0 NULL 2.001 0 0 0.000 68192 495296 0 369962 NULL 0
7273 pma localhost:49404 phpmyadmin Sleep 0 NULL 67.715 0 0 0.000 59848 366952 0 369886 NULL 0
7272 root localhost:49403 information_schema Sleep 0 NULL 2.469 0 0 0.000 68192 472224 0 369955 NULL 0
7271 pma localhost:49402 phpmyadmin Sleep 0 NULL 31.297 0 0 0.000 59848 366952 0 369923 NULL 0
7270 root localhost:49401 information_schema Query 0 Filling schema table
SELECT * FROM `PROCESSLIST` LIMIT 0, 25
6.067 0 0 0.000 137160 372488 0 369956 [BLOB - 39 B] 0
7269 root localhost:49400 phpmyadmin Sleep 0 NULL 10.718 0 0 0.000 68192 376480 0 369945 NULL 0
7268 pma localhost:49399 phpmyadmin Sleep 0 NULL 26.715 0 0 0.000 59848 366952 0 369931 NULL 0
7267 pma localhost:49398 phpmyadmin Query 0 Commit
REPLACE INTO `phpmyadmin`.`pma__recent` (`username...
7.003 0 0 0.000 59848 366952 0 369952 [BLOB - 680 B] 0
7266 root localhost:49397 information_schema Query 0 Optimizing
SELECT TABLE_NAME FROM information_schema.VIEWS WH...
2.868 0 0 0.000 88112 372488 0 369961 [BLOB - 153 B] 0
7265 pma localhost:49396 phpmyadmin Sleep 0 NULL 39.378 0 0 0.000 59848 366952 0 369917 NULL 0
7264 root localhost:49395 information_schema Sleep 0 NULL 1.450 0 0 0.000 68192 472160 0 369963 NULL 0
7263 root localhost:49394 information_schema Query 0 Removing tmp table
SHOW  COLUMNS FROM `information_schema`.`INNODB_SY...
8.692 0 0 0.000 120104 477392 5 369949 [BLOB - 60 B] 0
7262 pma localhost:49392 phpmyadmin Sleep 0 NULL 72.173 0 0 0.000 59848 366952 0 369878 NULL 0
7261 root localhost:49393 information_schema Query 0 Opening tables
SHOW  COLUMNS FROM `information_schema`.`COLLATION...
3.924 0 0 0.000 103848 471664 0 369959 [BLOB - 79 B] 0
7260 pma localhost:49391 phpmyadmin Sleep 0 NULL 36.602 0 0 0.000 59848 366952 0 369919 NULL 0
7259 root localhost:49390 information_schema Sleep 0 NULL 12.216 0 0 0.000 68192 480392 0 369941 NULL 0
7258 pma localhost:49389 phpmyadmin Sleep 0 NULL 27.129 0 0 0.000 59848 366952 0 369930 NULL 0
7257 pma localhost:49388 phpmyadmin Sleep 0 NULL 93.265 0 0 0.000 59848 366952 0 369842 NULL 0
15 system user NULL Slave_SQL 10295 Slave has read all relay log; waiting for the slav... NULL 10295768.778 0 0 0.000 60904 60904 0 0 NULL 0
13 system user NULL Slave_SQL 10295 Slave has read all relay log; waiting for the slav... NULL 10295786.741 0 0 0.000 60904 60904 0 0 NULL 0
11 system user NULL Slave_SQL 10295 Slave has read all relay log; waiting for the slav... NULL 10295803.228 0 0 0.000 60904 60904 0 0 NULL 0
9 system user NULL Slave_SQL 10295 Slave has read all relay log; waiting for the slav... NULL 10295822.975 0 0 0.000 60904 60904 0 0 NULL 0
5 system user NULL Daemon 0 InnoDB shutdown handler NULL 0.000 0 0 0.000 23960 23960 0 0 NULL 0
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query