fmc.bot.ngrok.io / 127.0.0.1 / information_schema / INNODB_BUFFER_PAGE_LRU

Navigation panel
Navigation tree
Servers
Databases
Tables

Navigation panel

Customize appearance of the navigation panel.

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Navigation tree

Customize the navigation tree.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers

Servers display options.

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases

Databases display options.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables

Tables display options.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift + Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Browse mode

Customize browse mode.

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

Showing rows 0 - ...

(Query took 0.0016 seconds.)

SELECT * FROM `INNODB_BUFFER_PAGE_LRU`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

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	FREE_PAGE_CLOCK
0	0	13236	1580	INDEX	0	0	NO	1902795144361	1902795144340	243736639	`fmc_bot`.`data_mydita_order_detail`	SF_ID	577	12694	0	NO	IO_NONE	NO	0
0	1	13236	4085	INDEX	0	0	NO	1902795194907	1902795194644	243737129	`fmc_bot`.`data_mydita_order_detail`	PRIMARY	72	14479	0	NO	IO_NONE	NO	0
0	2	13236	5194	INDEX	0	0	NO	1902795204124	1902795195316	243737160	`fmc_bot`.`data_mydita_order_detail`	PRIMARY	36	8124	0	NO	IO_NONE	NO	0
0	3	13236	2897	INDEX	0	0	NO	1902795204124	1902795195316	243737168	`fmc_bot`.`data_mydita_order_detail`	PRIMARY	52	11342	0	NO	IO_NONE	NO	0
0	4	13236	2901	INDEX	0	0	NO	1902795205888	1902795205663	243737153	`fmc_bot`.`data_mydita_order_detail`	PRIMARY	60	12996	0	NO	IO_NONE	NO	0
0	5	13236	1282	INDEX	0	0	NO	1902795206559	1902795206413	243737544	`fmc_bot`.`data_mydita_order_detail`	PRIMARY	74	14900	0	NO	IO_NONE	NO	0
0	6	13236	313	INDEX	0	0	NO	1902794089912	1902793320442	243733402	`fmc_bot`.`data_mydita_order_detail`	PRIMARY	70	16106	0	NO	IO_WRITE	NO	171601489
0	7	13236	4527	INDEX	0	0	NO	1902794088126	1902794081886	243735592	`fmc_bot`.`data_mydita_order_detail`	PRIMARY	56	12589	0	NO	IO_WRITE	NO	171601489
0	8	13236	5962	INDEX	0	0	NO	1902794089082	1902794084693	243735592	`fmc_bot`.`data_mydita_order_detail`	PRIMARY	44	9512	0	NO	IO_WRITE	NO	171601489
0	9	13236	5603	INDEX	0	0	NO	1902794085517	1902793460875	243733432	`fmc_bot`.`data_mydita_order_detail`	PRIMARY	45	9341	0	NO	IO_WRITE	NO	171601489
0	10	13236	2048	INDEX	0	0	NO	1902794088868	1902793311811	243733399	`fmc_bot`.`data_mydita_order_detail`	PRIMARY	67	14292	0	NO	IO_WRITE	NO	171601489
0	11	13236	3221	INDEX	0	0	NO	1902794087346	1902794081453	243735592	`fmc_bot`.`data_mydita_order_detail`	PRIMARY	50	10900	0	NO	IO_WRITE	NO	171601489
0	12	13236	3575	INDEX	0	0	YES	1902794090478	1902793304416	243733397	`fmc_bot`.`data_mydita_order_detail`	PRIMARY	48	9526	0	NO	IO_WRITE	NO	171601489
0	13	13236	2411	INDEX	0	0	NO	1902794088390	1902793355078	243733410	`fmc_bot`.`data_mydita_order_detail`	PRIMARY	58	12460	0	NO	IO_WRITE	NO	171601489
0	14	13236	814	INDEX	0	0	NO	1902794090390	1902793300027	243733396	`fmc_bot`.`data_mydita_order_detail`	PRIMARY	60	11793	0	NO	IO_WRITE	NO	171601489
0	15	13236	4245	INDEX	0	0	NO	1902795156427	1902795148148	243737730	`fmc_bot`.`data_mydita_order_detail`	ORDER_CODE	406	10786	0	NO	IO_WRITE	NO	0
0	16	13236	2806	INDEX	0	0	NO	1902795194599	1902795156427	243737730	`fmc_bot`.`data_mydita_order_detail`	SF_ID	433	9526	0	NO	IO_WRITE	NO	0
0	17	13236	2807	INDEX	0	0	NO	1902795165625	1902795165097	243737730	`fmc_bot`.`data_mydita_order_detail`	SF_ID	231	5309	0	NO	IO_WRITE	NO	0
0	18	13236	5630	INDEX	0	0	NO	1902795147962	1902795147660	243737730	`fmc_bot`.`data_mydita_order_detail`	PRIMARY	45	9222	0	NO	IO_WRITE	NO	0
0	19	13236	4392	INDEX	0	0	NO	1902795157023	1902795156765	243737730	`fmc_bot`.`data_mydita_order_detail`	SF_ID	494	10868	0	NO	IO_WRITE	NO	0
0	20	13236	4393	INDEX	0	0	NO	1902795194201	1902795148011	243737730	`fmc_bot`.`data_mydita_order_detail`	SF_ID	499	11468	0	NO	IO_WRITE	NO	0
0	21	13236	4394	INDEX	0	0	NO	1902795154577	1902795154398	243737730	`fmc_bot`.`data_mydita_order_detail`	SF_ID	480	10560	0	NO	IO_WRITE	NO	0
0	22	13236	4395	INDEX	0	0	NO	1902795155293	1902795155000	243737730	`fmc_bot`.`data_mydita_order_detail`	SF_ID	487	10905	0	NO	IO_WRITE	NO	0
0	23	13236	4397	INDEX	0	0	NO	1902795155412	1902795155330	243737730	`fmc_bot`.`data_mydita_order_detail`	SF_ID	57	1254	0	NO	IO_WRITE	NO	0
0	24	13236	4398	INDEX	0	0	NO	1902795156374	1902795155867	243737730	`fmc_bot`.`data_mydita_order_detail`	SF_ID	491	10802	0	NO	IO_WRITE	NO	0

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view