synex.uk / 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

InnoDB

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

===================================== 2026-10-20 01:08:27 0x4888 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 36 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1755274 srv_active, 0 srv_shutdown, 36464 srv_idle srv_master_thread log flush and writes: 1791717 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 431427759 OS WAIT ARRAY INFO: signal count 555748920 RW-shared spins 741522782, rounds 11398208415, OS waits 220815169 RW-excl spins 641658611, rounds 8810072880, OS waits 157922216 RW-sx spins 35082172, rounds 351445327, OS waits 5353502 Spin rounds per wait: 15.37 RW-shared, 13.73 RW-excl, 10.02 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 2600469313 Purge done for trx's n:o < 2587812750 undo n:o < 0 state: running but idle History list length 6215664 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 282891049365792, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 282891049361624, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 282891049369960, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 282891049357456, ACTIVE 58290 sec 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 5185071, OS thread handle 18496, query id 1821885686 localhost 127.0.0.1 root Trx read view will not see trx with id >= 2587812746, sees < 2587812740 -------- 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 2133170699 OS file reads, 2308977025 OS file writes, 286125437 OS fsyncs 188.41 reads/s, 16384 avg bytes/read, 396.49 writes/s, 56.64 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 3435, free list len 36777, seg size 40213, 190803455 merges merged operations: insert 552611512, delete mark 986660090, delete 8572524 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 553253, node heap has 1281 buffer(s) Hash table size 553253, node heap has 314 buffer(s) Hash table size 553253, node heap has 29 buffer(s) Hash table size 553253, node heap has 6 buffer(s) Hash table size 553253, node heap has 8 buffer(s) Hash table size 553253, node heap has 4 buffer(s) Hash table size 553253, node heap has 22 buffer(s) Hash table size 553253, node heap has 6 buffer(s) 1646.62 hash searches/s, 4796.03 non-hash searches/s --- LOG --- Log sequence number 4797121395238 Log flushed up to 4797121395238 Pages flushed up to 4797120620397 Last checkpoint at 4797119870795 0 pending log flushes, 0 pending chkp writes 153921669 log i/o's done, 6.44 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 2281701376 Dictionary memory allocated 262920 Buffer pool size 128432 Free buffers 8192 Database pages 118570 Old database pages 43604 Modified db pages 1559 Percent of dirty pages(LRU & free pages): 1.230 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1299319988, not young 96282743911 914.86 youngs/s, 1511.62 non-youngs/s Pages read 2133170591, created 22629714, written 2095987089 188.41 reads/s, 4.69 creates/s, 369.99 writes/s Buffer pool hit rate 995 / 1000, young-making rate 21 / 1000 not 36 / 1000 Pages read ahead 2.25/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 118570, unzip_LRU len: 0 I/O sum[457896]:cur[2664], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 16054 Free buffers 1024 Database pages 14845 Old database pages 5459 Modified db pages 58 Percent of dirty pages(LRU & free pages): 0.365 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 178561100, not young 12452731256 70.11 youngs/s, 21.69 non-youngs/s Pages read 260620184, created 2877461, written 260624287 2.25 reads/s, 0.61 creates/s, 40.50 writes/s Buffer pool hit rate 999 / 1000, young-making rate 17 / 1000 not 5 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14845, unzip_LRU len: 0 I/O sum[57237]:cur[333], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 16054 Free buffers 1024 Database pages 14836 Old database pages 5456 Modified db pages 171 Percent of dirty pages(LRU & free pages): 1.078 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 129943207, not young 11627374001 88.44 youngs/s, 26.47 non-youngs/s Pages read 252178705, created 2839738, written 251716596 2.56 reads/s, 0.00 creates/s, 44.17 writes/s Buffer pool hit rate 999 / 1000, young-making rate 22 / 1000 not 6 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14836, unzip_LRU len: 0 I/O sum[57237]:cur[333], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 16054 Free buffers 1024 Database pages 14830 Old database pages 5454 Modified db pages 200 Percent of dirty pages(LRU & free pages): 1.261 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 216403793, not young 12940119295 149.75 youngs/s, 501.57 non-youngs/s Pages read 293319297, created 2787051, written 276664107 66.58 reads/s, 0.61 creates/s, 46.25 writes/s Buffer pool hit rate 993 / 1000, young-making rate 14 / 1000 not 48 / 1000 Pages read ahead 0.92/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14830, unzip_LRU len: 0 I/O sum[57237]:cur[333], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 16054 Free buffers 1024 Database pages 14791 Old database pages 5439 Modified db pages 124 Percent of dirty pages(LRU & free pages): 0.784 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 149010350, not young 11692134561 126.39 youngs/s, 153.05 non-youngs/s Pages read 267827970, created 2811813, written 263659540 14.14 reads/s, 0.11 creates/s, 39.61 writes/s Buffer pool hit rate 996 / 1000, young-making rate 30 / 1000 not 37 / 1000 Pages read ahead 0.67/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14791, unzip_LRU len: 0 I/O sum[57237]:cur[333], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 16054 Free buffers 1024 Database pages 14836 Old database pages 5456 Modified db pages 275 Percent of dirty pages(LRU & free pages): 1.734 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 144026568, not young 11593495668 125.50 youngs/s, 112.80 non-youngs/s Pages read 257964835, created 2832613, written 275153619 10.19 reads/s, 0.72 creates/s, 53.39 writes/s Buffer pool hit rate 998 / 1000, young-making rate 24 / 1000 not 21 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14836, unzip_LRU len: 0 I/O sum[57237]:cur[333], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 16054 Free buffers 1024 Database pages 14793 Old database pages 5440 Modified db pages 299 Percent of dirty pages(LRU & free pages): 1.890 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 199562865, not young 12759486531 149.86 youngs/s, 597.18 non-youngs/s Pages read 292303111, created 2830259, written 263725014 82.30 reads/s, 1.81 creates/s, 54.39 writes/s Buffer pool hit rate 983 / 1000, young-making rate 30 / 1000 not 122 / 1000 Pages read ahead 0.67/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14793, unzip_LRU len: 0 I/O sum[57237]:cur[333], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 16054 Free buffers 1024 Database pages 14835 Old database pages 5456 Modified db pages 155 Percent of dirty pages(LRU & free pages): 0.977 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 139085239, not young 11403952971 91.25 youngs/s, 23.36 non-youngs/s Pages read 245844269, created 2816210, written 251153557 2.33 reads/s, 0.50 creates/s, 43.17 writes/s Buffer pool hit rate 999 / 1000, young-making rate 17 / 1000 not 4 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14835, unzip_LRU len: 0 I/O sum[57237]:cur[333], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 16054 Free buffers 1024 Database pages 14804 Old database pages 5444 Modified db pages 277 Percent of dirty pages(LRU & free pages): 1.750 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 142726866, not young 11813449628 113.58 youngs/s, 75.50 non-youngs/s Pages read 263112220, created 2834569, written 253290369 8.06 reads/s, 0.33 creates/s, 48.53 writes/s Buffer pool hit rate 998 / 1000, young-making rate 26 / 1000 not 17 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14804, unzip_LRU len: 0 I/O sum[57237]:cur[333], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Process ID=4344, Main thread ID=5928, state: sleeping Number of rows inserted 409786533, updated 314058614, deleted 408773622, read 235337013345 0.28 inserts/s, 90.55 updates/s, 0.00 deletes/s, 142582.84 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 345487 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