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

Press Ctrl+Enter to execute query

InnoDB

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

===================================== 2026-10-27 04:39:47 0x2aa8 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 13 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 2466979 srv_active, 0 srv_shutdown, 1102339 srv_idle srv_master_thread log flush and writes: 3569318 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 30353275 OS WAIT ARRAY INFO: signal count 14395262 RW-shared spins 7941739, rounds 68007479, OS waits 1971132 RW-excl spins 9148065, rounds 41585658, OS waits 138644 RW-sx spins 236285, rounds 2243831, OS waits 21116 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 3614987005 Purge done for trx's n:o < 3614987005 undo n:o < 0 state: running but idle History list length 1 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 283707187409040, 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 283707187417376, ACTIVE 0 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 17072460, OS thread handle 15764, query id 41675807563 localhost 127.0.0.1 root Sending data SELECT id, 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 FROM transaction_logs WHERE status IN ('RECEIVED', 'NOT_RECEIVED', 'PROVIDE_VIDEO') AND (source_type IS NULL OR source_type = '' OR source_type <> 'sheet_completed_sync') AND logged_at >= '2026-10-24T11:39:47+00:00' ORDER BY id DESC LIMIT 1000 OFFSET 7000 Trx read view will not see trx with id >= 3614987005, sees < 3614987005 -------- 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, 121202271 OS file writes, 37376761 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 18.61 writes/s, 3.85 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) 39985.46 hash searches/s, 46721.64 non-hash searches/s --- LOG --- Log sequence number 96678478125 Log flushed up to 96678467125 Pages flushed up to 96678354392 Last checkpoint at 96678354392 0 pending log flushes, 0 pending chkp writes 27220064 log i/o's done, 10.85 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 69256347648 Dictionary memory allocated 305488 Buffer pool size 4109824 Free buffers 4099778 Database pages 9673 Old database pages 3408 Modified db pages 218 Percent of dirty pages(LRU & free pages): 0.005 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 7204, written 80924785 0.00 reads/s, 0.00 creates/s, 6.69 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: 9673, 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 512501 Database pages 1187 Old database pages 418 Modified db pages 15 Percent of dirty pages(LRU & free pages): 0.003 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 806, written 6249232 0.00 reads/s, 0.00 creates/s, 0.15 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: 1187, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 513728 Free buffers 512541 Database pages 1142 Old database pages 401 Modified db pages 15 Percent of dirty pages(LRU & free pages): 0.003 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 7598772 0.00 reads/s, 0.00 creates/s, 0.77 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 1151 Old database pages 404 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 25, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 334, created 817, written 1388627 0.00 reads/s, 0.00 creates/s, 0.08 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: 1151, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 513728 Free buffers 512487 Database pages 1182 Old database pages 416 Modified db pages 88 Percent of dirty pages(LRU & free pages): 0.017 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 18924711 0.00 reads/s, 0.00 creates/s, 2.31 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 512381 Database pages 1297 Old database pages 459 Modified db pages 40 Percent of dirty pages(LRU & free pages): 0.008 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 23659047 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: 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 512299 Database pages 1388 Old database pages 492 Modified db pages 30 Percent of dirty pages(LRU & free pages): 0.006 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 1051, written 9652896 0.00 reads/s, 0.00 creates/s, 1.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: 1388, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 513728 Free buffers 512471 Database pages 1212 Old database pages 427 Modified db pages 24 Percent of dirty pages(LRU & free pages): 0.005 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 913, written 10940532 0.00 reads/s, 0.00 creates/s, 0.77 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: 1212, 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 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 243, created 871, written 2510968 0.00 reads/s, 0.00 creates/s, 0.08 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 1 read views open inside InnoDB Process ID=4424, Main thread ID=7888, state: sleeping Number of rows inserted 4099372, updated 14613370, deleted 3804747, read 1068861085635 0.69 inserts/s, 8.00 updates/s, 0.62 deletes/s, 155835.63 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 3375 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