ag.appsoft.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

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

InnoDB

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

===================================== 2026-10-27 05:29:50 0x43f4 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 28 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 2468994 srv_active, 0 srv_shutdown, 1103292 srv_idle srv_master_thread log flush and writes: 3572286 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 30374720 OS WAIT ARRAY INFO: signal count 14407943 RW-shared spins 7953453, rounds 68068635, OS waits 1972789 RW-excl spins 9155176, rounds 41615618, OS waits 138732 RW-sx spins 236471, rounds 2245464, OS waits 21136 Spin rounds per wait: 8.56 RW-shared, 4.55 RW-excl, 9.50 RW-sx ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2026-10-27 01:49:25 0x10bc *** (1) TRANSACTION: TRANSACTION 3614354724, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1 MySQL thread id 17018616, OS thread handle 15764, query id 41511120675 localhost 127.0.0.1 root Update INSERT INTO transaction_logs (transaction_id, sheet_name, sheet_row, agent_number, player_number, amount, pic_name, reason, status_label, image_link, processing_seconds, source_type, status, logged_at) VALUES ('767F0ZAR', 'MVB-sheet', '645', '1947117994', '1577194580', '', '', 'Agent No Response', NULL, 'https://download.v2ply.com/bdt/BJLBDT/767F0ZAR_Screenshot_20261027_142210_Nagad.png', '1534', '', 'PROVIDE_VIDEO', '2026-10-27T08:49:25+00:00') *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 193 page no 384 n bits 392 index idx_transaction_logs_status_logged of table `dashboard_agent`.`transaction_logs` trx id 3614354724 lock_mode X insert intention waiting Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; *** (2) TRANSACTION: TRANSACTION 3614354723, ACTIVE 0 sec fetching rows mysql tables in use 2, locked 2 231 lock struct(s), heap size 41080, 12088 row lock(s), undo log entries 1 MySQL thread id 17018655, OS thread handle 4284, query id 41511120665 localhost 127.0.0.1 root Sending data DELETE FROM transaction_logs WHERE id IN ( SELECT id FROM ( SELECT id FROM transaction_logs WHERE status = 'RECEIVED' AND (source_type IS NULL OR source_type = '' OR source_type <> 'sheet_completed_sync') AND ( (TRIM(COALESCE(status_label, '')) = '' AND LOWER(TRIM(COALESCE(reason, ''))) NOT IN ('success', 'auto', 'make up')) OR LOWER(TRIM(COALESCE(NULLIF(status_label, ''), reason, ''))) IN ('success', 'auto', 'make up') ) ORDER BY logged_at ASC, id ASC LIMIT 1 ) old_completed_reports ) *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 193 page no 384 n bits 392 index idx_transaction_logs_status_logged of table `dashboard_agent`.`transaction_logs` trx id 3614354723 lock mode S Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 193 page no 184 n bits 120 index PRIMARY of table `dashboard_agent`.`transaction_logs` trx id 3614354723 lock_mode X waiting Record lock, heap no 49 PHYSICAL RECORD: n_fields 17; compact format; info bits 0 0: len 4; hex 8002be76; asc v;; 1: len 6; hex 0000d76ead24; asc n $;; 2: len 7; hex e7000001992f3c; asc /<;; 3: len 8; hex 37363746305a4152; asc 767F0ZAR;; 4: len 9; hex 4d56422d7368656574; asc MVB-sheet;; 5: len 4; hex 80000285; asc ;; 6: len 10; hex 31393437313137393934; asc 1947117994;; 7: len 10; hex 31353737313934353830; asc 1577194580;; 8: len 0; hex ; asc ;; 9: len 17; hex 4167656e74204e6f20526573706f6e7365; asc Agent No Response;; 10: len 30; hex 68747470733a2f2f646f776e6c6f61642e7632706c792e636f6d2f626474; asc https://download.v2ply.com/bdt; (total 83 bytes); 11: len 4; hex 800005fe; asc ;; 12: len 13; hex 50524f564944455f564944454f; asc PROVIDE_VIDEO;; 13: len 25; hex 323032362d31302d32375430383a34393a32352b30303a3030; asc 2026-10-27T08:49:25+00:00;; 14: len 0; hex ; asc ;; 15: SQL NULL; 16: len 0; hex ; asc ;; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 3615116052 Purge done for trx's n:o < 3615116052 undo n:o < 0 state: running but idle History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 283707187417376, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283707187413208, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283707187409040, not started estimating records in index range mysql tables in use 1, locked 0 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 2593 OS file reads, 121291992 OS file writes, 37405162 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 25.28 writes/s, 8.82 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 9, seg size 11, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 17700857, node heap has 12 buffer(s) Hash table size 17700857, node heap has 57 buffer(s) Hash table size 17700857, node heap has 1 buffer(s) Hash table size 17700857, node heap has 13 buffer(s) Hash table size 17700857, node heap has 28 buffer(s) Hash table size 17700857, node heap has 10 buffer(s) Hash table size 17700857, node heap has 67 buffer(s) Hash table size 17700857, node heap has 185 buffer(s) 39727.37 hash searches/s, 49195.06 non-hash searches/s --- LOG --- Log sequence number 96694123539 Log flushed up to 96694114468 Pages flushed up to 96694113261 Last checkpoint at 96694112941 0 pending log flushes, 0 pending chkp writes 27239769 log i/o's done, 6.07 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 69256347648 Dictionary memory allocated 305488 Buffer pool size 4109824 Free buffers 4099772 Database pages 9679 Old database pages 3410 Modified db pages 21 Percent of dirty pages(LRU & free pages): 0.001 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 48, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 2469, created 7210, written 80985217 0.00 reads/s, 0.00 creates/s, 16.14 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: 9679, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 513728 Free buffers 512500 Database pages 1188 Old database pages 418 Modified db pages 1 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 3, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 381, created 807, written 6253027 0.00 reads/s, 0.00 creates/s, 1.32 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: 1188, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 513728 Free buffers 512540 Database pages 1142 Old database pages 401 Modified db pages 1 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 15, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 365, created 777, written 7606295 0.00 reads/s, 0.00 creates/s, 1.54 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: 1142, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 513728 Free buffers 512526 Database pages 1152 Old database pages 405 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 25, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 334, created 818, written 1389550 0.00 reads/s, 0.00 creates/s, 0.29 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: 1152, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 513728 Free buffers 512488 Database pages 1182 Old database pages 416 Modified db pages 9 Percent of dirty pages(LRU & free pages): 0.002 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 269, created 913, written 18938673 0.00 reads/s, 0.00 creates/s, 3.89 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: 1182, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 513728 Free buffers 512380 Database pages 1297 Old database pages 459 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.001 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 241, created 1056, written 23675065 0.00 reads/s, 0.00 creates/s, 3.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: 1297, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 513728 Free buffers 512296 Database pages 1391 Old database pages 493 Modified db pages 2 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 2, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 337, created 1054, written 9660956 0.00 reads/s, 0.00 creates/s, 1.61 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: 1391, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 513728 Free buffers 512470 Database pages 1213 Old database pages 427 Modified db pages 5 Percent of dirty pages(LRU & free pages): 0.001 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 299, created 914, written 10948749 0.00 reads/s, 0.00 creates/s, 3.04 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: 1213, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 513728 Free buffers 512572 Database pages 1114 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 243, created 871, written 2512902 0.00 reads/s, 0.00 creates/s, 0.50 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: 1114, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=4424, Main thread ID=7888, state: sleeping Number of rows inserted 4102093, updated 14624420, deleted 3807193, read 1069636130350 0.79 inserts/s, 3.04 updates/s, 0.50 deletes/s, 330766.65 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 4637 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