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 109 0 331 UNDO_LOG 1 0 NO 58455325 0 663362245 NULL NULL 0 0 0 NO IO_NONE NO 45222
0 218 0 235 SYSTEM 1 0 NO 58490150 58486987 659228050 NULL NULL 0 0 0 NO IO_NONE NO 45290
0 9 0 353 UNDO_LOG 1 0 NO 58371734 0 663327848 NULL NULL 0 0 0 NO IO_NONE NO 45155
0 140 0 405 UNDO_LOG 1 0 NO 58478797 0 663364442 NULL NULL 0 0 0 NO IO_NONE NO 45240
0 62 0 414 UNDO_LOG 1 0 NO 58513525 58506466 663334066 NULL NULL 0 0 0 NO IO_NONE NO 45201
0 249 0 297 SYSTEM 1 0 NO 58455193 0 3806727848 NULL NULL 0 0 0 NO IO_NONE NO 45290
0 171 0 446 UNDO_LOG 0 0 NO 58490194 58487083 663369648 NULL NULL 0 0 0 NO IO_NONE NO 45265
0 93 0 295 SYSTEM 1 0 NO 58455105 0 4146506207 NULL NULL 0 0 0 NO IO_NONE NO 45206
0 202 0 267 SYSTEM 1 0 NO 58530698 58528664 4146373804 NULL NULL 0 0 0 NO IO_NONE NO 45290
0 124 0 332 UNDO_LOG 1 0 NO 58467144 0 659255681 NULL NULL 0 0 0 NO IO_NONE NO 45240
0 46 4 3 INDEX 0 0 NO 0 0 663332635 `phpmyadmin`.`pma__bookmark` PRIMARY 0 0 0 NO IO_NONE NO 45191
0 25 0 265 SYSTEM 1 0 NO 58530547 58525926 662583540 NULL NULL 0 0 0 NO IO_NONE NO 45166
0 187 0 227 SYSTEM 1 0 NO 58385042 0 663297501 NULL NULL 0 0 0 NO IO_NONE NO 45276
0 188 0 230 SYSTEM 1 0 NO 58489930 58480369 663297501 NULL NULL 0 0 0 NO IO_NONE NO 45276
0 110 0 365 UNDO_LOG 1 0 NO 58467027 0 663362623 NULL NULL 0 0 0 NO IO_NONE NO 45222
0 219 0 236 SYSTEM 1 0 NO 58490194 58487083 659228050 NULL NULL 0 0 0 NO IO_NONE NO 45290
0 10 0 313 UNDO_LOG 1 0 NO 58371778 0 663327920 NULL NULL 0 0 0 NO IO_NONE NO 45155
0 141 0 429 UNDO_LOG 1 0 NO 58478885 0 663364658 NULL NULL 0 0 0 NO IO_NONE NO 45254
0 63 0 46 SYSTEM 1 0 NO 58467105 0 663357789 NULL NULL 0 0 0 NO IO_NONE NO 45206
0 250 0 298 SYSTEM 1 0 NO 58455237 0 4146074335 NULL NULL 0 0 0 NO IO_NONE NO 45290
0 172 9 3 INDEX 0 0 NO 0 0 663295630 `phpmyadmin`.`pma__favorite` PRIMARY 0 0 0 NO IO_NONE NO 45268
0 94 0 299 SYSTEM 1 0 NO 58455281 0 4146506207 NULL NULL 0 0 0 NO IO_NONE NO 45206
0 203 0 426 UNDO_LOG 0 0 NO 58530742 58528760 663374809 NULL NULL 0 0 0 NO IO_NONE NO 45290
0 125 0 48 SYSTEM 1 0 NO 58467183 0 659161116 NULL NULL 0 0 0 NO IO_NONE NO 45240
0 47 4 1 IBUF_BITMAP 0 0 NO 0 0 663332635 NULL NULL 0 0 0 NO IO_NONE NO 45191
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