jay-mis.com / 127.0.0.1 | phpMyAdmin 5.2.1

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.

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.

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.

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

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

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 :

InnoDB

Supports transactions, row-level locking, foreign keys and encryption for tables

===================================== 2026-10-16 02:51:49 0x37ec INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 49 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 44234 srv_active, 0 srv_shutdown, 21778 srv_idle srv_master_thread log flush and writes: 66012 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1417569 OS WAIT ARRAY INFO: signal count 304725 RW-shared spins 34017, rounds 742525, OS waits 23108 RW-excl spins 11915, rounds 50201, OS waits 881 RW-sx spins 1038, rounds 4496, OS waits 41 Spin rounds per wait: 21.83 RW-shared, 4.21 RW-excl, 4.33 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 7183508 Purge done for trx's n:o < 7183508 undo n:o < 0 state: running but idle History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 283173588762840, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283173588758672, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 7791 OS file reads, 633827 OS file writes, 416619 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 12.29 writes/s, 6.84 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 12, seg size 14, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 553253, node heap has 15 buffer(s) Hash table size 553253, node heap has 157 buffer(s) Hash table size 553253, node heap has 167 buffer(s) Hash table size 553253, node heap has 15 buffer(s) Hash table size 553253, node heap has 23 buffer(s) Hash table size 553253, node heap has 38 buffer(s) Hash table size 553253, node heap has 52 buffer(s) Hash table size 553253, node heap has 13 buffer(s) 15.78 hash searches/s, 40.49 non-hash searches/s --- LOG --- Log sequence number 5266204197 Log flushed up to 5266204197 Pages flushed up to 5266204197 Last checkpoint at 5266188986 0 pending log flushes, 0 pending chkp writes 167118 log i/o's done, 3.06 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 2181038080 Dictionary memory allocated 160256 Buffer pool size 128432 Free buffers 120068 Database pages 7884 Old database pages 3032 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 119, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 7726, created 158, written 307739 0.00 reads/s, 0.00 creates/s, 6.51 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 7884, unzip_LRU len: 0 I/O sum[0]:cur[24], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 16054 Free buffers 15197 Database pages 796 Old database pages 311 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 17, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 781, created 15, written 26947 0.00 reads/s, 0.00 creates/s, 0.47 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 796, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 16054 Free buffers 15023 Database pages 972 Old database pages 376 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 24, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 966, created 6, written 36890 0.00 reads/s, 0.00 creates/s, 0.57 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 972, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 16054 Free buffers 15031 Database pages 959 Old database pages 352 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 26, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 958, created 1, written 399 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 959, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 16054 Free buffers 14939 Database pages 1059 Old database pages 403 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 23, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1056, created 3, written 63105 0.00 reads/s, 0.00 creates/s, 0.82 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 1059, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 16054 Free buffers 14962 Database pages 1024 Old database pages 397 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 20, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1021, created 3, written 53552 0.00 reads/s, 0.00 creates/s, 1.92 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 1024, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 16054 Free buffers 14989 Database pages 1007 Old database pages 391 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1005, created 2, written 42702 0.00 reads/s, 0.00 creates/s, 0.96 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 1007, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 16054 Free buffers 14924 Database pages 1071 Old database pages 415 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1008, created 63, written 40953 0.00 reads/s, 0.00 creates/s, 1.20 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 1071, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 16054 Free buffers 15003 Database pages 996 Old database pages 387 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 9, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 931, created 65, written 43191 0.00 reads/s, 0.00 creates/s, 0.57 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 996, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=3568, Main thread ID=5372, state: sleeping Number of rows inserted 10075, updated 73718, deleted 9207, read 168166027 0.00 inserts/s, 1.65 updates/s, 0.00 deletes/s, 19.04 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 127 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

Storage engines

InnoDB

Navigation panel

Customize appearance of the navigation panel.

Navigation tree

Customize the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Storage engines

InnoDB