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
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 `INNODB_BUFFER_PAGE_LRU` ORDER BY `IS_OLD` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
POOL_ID LRU_POSITION SPACE PAGE_NUMBER PAGE_TYPE FLUSH_TYPE FIX_COUNT IS_HASHED NEWEST_MODIFICATION OLDEST_MODIFICATION ACCESS_TIME TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE COMPRESSED_SIZE COMPRESSED IO_FIX IS_OLD Descending Ascending 1 FREE_PAGE_CLOCK
0 247 0 289 SYSTEM 1 0 NO 37736286 37732484 291615233 NULL NULL 0 0 0 NO IO_NONE NO 27581
0 24 0 444 UNDO_LOG 1 0 NO 37673120 37670094 291685542 NULL NULL 0 0 0 NO IO_NONE NO 27446
0 169 0 227 SYSTEM 1 0 NO 37713822 37704116 291078621 NULL NULL 0 0 0 NO IO_NONE NO 27552
0 91 0 273 SYSTEM 1 0 NO 37596408 0 291692737 NULL NULL 0 0 0 NO IO_NONE NO 27482
0 55 0 257 SYSTEM 1 0 NO 37723893 37719691 286103997 NULL NULL 0 0 0 NO IO_NONE NO 27468
0 200 0 59 SYSTEM 1 0 NO 37766996 37651317 291615232 NULL NULL 0 0 0 NO IO_NONE NO 27581
0 122 0 329 UNDO_LOG 1 0 NO 37761732 37758907 291748092 NULL NULL 0 0 0 NO IO_NONE NO 27516
0 8 0 357 UNDO_LOG 1 0 NO 37672778 37662403 291683859 NULL NULL 0 0 0 NO IO_NONE NO 27441
0 232 0 246 SYSTEM 1 0 NO 37569766 0 286161154 NULL NULL 0 0 0 NO IO_NONE NO 27581
0 154 0 404 UNDO_LOG 0 0 NO 37713970 37706987 291756269 NULL NULL 0 0 0 NO IO_NONE NO 27552
0 39 22 1 IBUF_BITMAP 0 0 NO 0 0 291689967 NULL NULL 0 0 0 NO IO_NONE NO 27456
0 185 7 4 INDEX 0 0 NO 0 0 291759054 `phpmyadmin`.`pma__pdf_pages` db_name 0 0 0 NO IO_NONE NO 27571
0 107 0 377 UNDO_LOG 1 0 NO 37748452 37746020 291709277 NULL NULL 0 0 0 NO IO_NONE NO 27505
0 71 0 296 SYSTEM 1 0 NO 37748667 37741034 286103997 NULL NULL 0 0 0 NO IO_NONE NO 27468
0 216 0 203 SYSTEM 1 0 NO 37673164 37672462 286185013 NULL NULL 0 0 0 NO IO_NONE NO 27581
0 138 0 344 UNDO_LOG 0 0 NO 37699857 37689561 291753925 NULL NULL 0 0 0 NO IO_NONE NO 27532
0 139 0 317 UNDO_LOG 0 0 NO 37699901 37690727 291753974 NULL NULL 0 0 0 NO IO_NONE NO 27532
0 248 0 290 SYSTEM 0 0 NO 0 0 291762868 NULL NULL 0 0 0 NO IO_NONE NO 27581
0 25 0 320 UNDO_LOG 1 0 NO 37673164 37671312 291685893 NULL NULL 0 0 0 NO IO_NONE NO 27446
0 170 0 228 SYSTEM 1 0 NO 37713866 37705503 286209929 NULL NULL 0 0 0 NO IO_NONE NO 27552
0 92 0 274 SYSTEM 1 0 NO 37723981 37722250 291652257 NULL NULL 0 0 0 NO IO_NONE NO 27482
0 56 0 258 SYSTEM 1 0 NO 37723937 37720964 286100722 NULL NULL 0 0 0 NO IO_NONE NO 27468
0 201 0 60 SYSTEM 1 0 NO 37768468 37652611 291253044 NULL NULL 0 0 0 NO IO_NONE NO 27581
0 123 0 332 UNDO_LOG 1 0 NO 37761771 37760139 291748235 NULL NULL 0 0 0 NO IO_NONE NO 27521
0 9 0 378 UNDO_LOG 1 0 NO 37672928 37665056 291684132 NULL NULL 0 0 0 NO IO_NONE NO 27443
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