Drop files here
Console
Storage engines
InnoDB
Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables
[ Variables | Buffer Pool | InnoDB Status ]
=====================================
2024-11-12 09:38:46 168 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 22 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 5536 srv_active, 0 srv_shutdown, 2215841 srv_idle
srv_master_thread log flush and writes: 2221377
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 37938
--Thread 21348 has waited at buf0flu.cc line 1900 for 0.00000 seconds the semaphore:
Mutex at 04AB1C18 '&buf_pool->flush_state_mutex', lock var 1
Last time reserved by thread 16928 in file not yet reserved line 0, waiters flag 1
--Thread 23700 has waited at buf0buf.cc line 4241 for 0.00000 seconds the semaphore:
Mutex at 04AB1A28 '&buf_pool->LRU_list_mutex', lock var 1
Last time reserved by thread 16928 in file not yet reserved line 0, waiters flag 1
--Thread 13440 has waited at buf0buf.cc line 4241 for 0.00000 seconds the semaphore:
Mutex at 04AB1A28 '&buf_pool->LRU_list_mutex', lock var 1
Last time reserved by thread 16928 in file not yet reserved line 0, waiters flag 1
--Thread 29828 has waited at buf0buf.cc line 3042 for 0.00000 seconds the semaphore:
S-lock on RW-latch at 04BC3C88 '&block->lock'
a writer (thread id 13440) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file row0sel.cc line 3249
Last time write locked in file buf0buf.cc line 4300
Holder thread 0 file not yet reserved line 0
OS WAIT ARRAY INFO: signal count 45655
Mutex spin waits 331175, rounds 762932, OS waits 9390
RW-shared spins 351417, rounds 3229214, OS waits 26861
RW-excl spins 21712, rounds 94698, OS waits 1504
Spin rounds per wait: 2.30 mutex, 9.19 RW-shared, 4.36 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 20327279
Purge done for trx's n:o < 20327252 undo n:o < 0 state: running but idle
History list length 37
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 20327273, not started
MySQL thread id 29336, OS thread handle 0x5d04, query id 361904 localhost 127.0.0.1 root
---TRANSACTION 0, not started
MySQL thread id 29326, OS thread handle 0x168, query id 361881 localhost 127.0.0.1 root init
SHOW ENGINE INNODB STATUS
---TRANSACTION 20327277, not started
MySQL thread id 29329, OS thread handle 0x23a4, query id 361914 localhost 127.0.0.1 root
---TRANSACTION 20327266, not started estimating records in index range
mysql tables in use 1, locked 0
MySQL thread id 29333, OS thread handle 0x7484, query id 361893 localhost 127.0.0.1 root statistics
SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`='root' GROUP BY `db_name`
---TRANSACTION 20327270, not started estimating records in index range
mysql tables in use 1, locked 0
MySQL thread id 29330, OS thread handle 0x23a4, query id 361915 localhost 127.0.0.1 root statistics
SELECT `master_field`,
`foreign_db`,
`foreign_table`,
`foreign_field`
FROM `phpmyadmin`.`pma__relation`
WHERE `master_db` = 'profile'
AND `master_table` = 'wp_studypress_rate_quality'
---TRANSACTION 0, not started
MySQL thread id 29323, OS thread handle 0x8398, query id 361878 localhost 127.0.0.1 root
---TRANSACTION 20327256, not started
MySQL thread id 29327, OS thread handle 0x3480, query id 361841 localhost 127.0.0.1 root
---TRANSACTION 20327254, not started estimating records in index range
mysql tables in use 1, locked 0
MySQL thread id 29321, OS thread handle 0x3480, query id 361887 localhost 127.0.0.1 root statistics
SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`='root' GROUP BY `db_name`
---TRANSACTION 0, not started
MySQL thread id 29301, OS thread handle 0x168, query id 361858 localhost 127.0.0.1 root
---TRANSACTION 0, not started
MySQL thread id 29311, OS thread handle 0x8684, query id 361857 localhost 127.0.0.1 root
---TRANSACTION 20327231, not started
MySQL thread id 29316, OS thread handle 0x29b8, query id 361738 localhost 127.0.0.1 root
---TRANSACTION 20217602, not started
MySQL thread id 1, OS thread handle 0x4a24, query id 0 Waiting for background binlog tasks
---TRANSACTION 20327269, ACTIVE 1 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 4 lock struct(s), heap size 312, 1 row lock(s)
MySQL thread id 29324, OS thread handle 0x8398, query id 361879 localhost 127.0.0.1 root update
REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{\"db\":\"sams\",\"table\":\"pension_details\"},{\"db\":\"pu_recruitment\",\"table\":\"payment_bill_desk\"},{\"db\":\"sams\",\"table\":\"employee_other_payments\"},{\"db\":\"gpsbeta\",\"table\":\"ci_sessions\"},{\"db\":\"pu_website1\",\"table\":\"wp_addonlibrary_categories\"},{\"db\":\"pu_recruitment_dir\",\"table\":\"research_details\"},{\"db\":\"profile\",\"table\":\"wp_studypress_course\"},{\"db\":\"phpmyadmin\",\"table\":\"pma__central_columns\"},{\"db\":\"pu_sms_beta\",\"table\":\"fauclyit\"},{\"db\":\"quiz\"
Trx #rec lock waits 1 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 5775 page no 3 n bits 80 index `PRIMARY` of table `phpmyadmin`.`pma__recent` trx table locks 1 total table locks 3 trx id 20327269 lock_mode X locks rec but not gap waiting lock hold time 1 wait time before grant 0
------------------
---TRANSACTION 20327268, ACTIVE 1 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 4 lock struct(s), heap size 312, 1 row lock(s)
MySQL thread id 29302, OS thread handle 0x29b8, query id 361876 localhost 127.0.0.1 root update
REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{\"db\":\"pu_website\",\"table\":\"pu_cartflows_ca_email_templates\"},{\"db\":\"pu_recruitment\",\"table\":\"payment_bill_desk\"},{\"db\":\"sams\",\"table\":\"employee_other_payments\"},{\"db\":\"gpsbeta\",\"table\":\"ci_sessions\"},{\"db\":\"pu_website1\",\"table\":\"wp_addonlibrary_categories\"},{\"db\":\"pu_recruitment_dir\",\"table\":\"research_details\"},{\"db\":\"profile\",\"table\":\"wp_studypress_course\"},{\"db\":\"phpmyadmin\",\"table\":\"pma__central_columns\"},{\"db\":\"pu_sms_beta\",\"table\":\"faucly
Trx #rec lock waits 1 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 5775 page no 3 n bits 80 index `PRIMARY` of table `phpmyadmin`.`pma__recent` trx table locks 1 total table locks 3 trx id 20327268 lock_mode X locks rec but not gap waiting lock hold time 1 wait time before grant 0
------------------
---TRANSACTION 20327262, ACTIVE (PREPARED) 1 sec committing
mysql tables in use 1, locked 1
2 lock struct(s), heap size 312, 1 row lock(s), undo log entries 1
MySQL thread id 29313, OS thread handle 0x8684, query id 361860 localhost 127.0.0.1 root query end
REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{\"db\":\"gpsbeta\",\"table\":\"course_materials\"},{\"db\":\"purec_stat\",\"table\":\"departments\"},{\"db\":\"gpsbeta\",\"table\":\"curriculum\"},{\"db\":\"information_schema\",\"table\":\"COLUMNS\"},{\"db\":\"gpsbeta\",\"table\":\"tstphdexam_del\"},{\"db\":\"pu_website\",\"table\":\"pu_tm_tasks\"},{\"db\":\"genhr\",\"table\":\"logistic_assign\"},{\"db\":\"sams\",\"table\":\"registered\"},{\"db\":\"genhr\",\"table\":\"pro_expenses\"},{\"db\":\"fuel\",\"table\":\"fuel_archives\"}]')
Trx #rec lock waits 1 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
--------
FILE I/O
--------
I/O thread 0 state: complete io for buf page (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: 32 [32, 0, 0, 0] , aio writes: 23 [2, 8, 10, 3] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 1
3029881 OS file reads, 69019 OS file writes, 35186 OS fsyncs
1 pending reads, 1 pending writes
94.56 reads/s, 16384 avg bytes/read, 30.82 writes/s, 10.39 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 242, seg size 244, 21 merges
merged operations:
insert 10, delete mark 11, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
19.95 hash searches/s, 79.22 non-hash searches/s
---
LOG
---
Log sequence number 61156232655
Log flushed up to 61156231308
Pages flushed up to 61156228748
Last checkpoint at 61156158531
Max checkpoint age 7782360
Checkpoint age target 7539162
Modified age 3907
Checkpoint age 74124
1 pending log writes, 0 pending chkp writes
18325 log i/o's done, 6.96 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 17203200; in additional pool allocated 0
Total memory allocated by read views 164928
Internal hash tables (constant factor + variable factor)
Adaptive hash index 297300 (276764 + 20536)
Page hash 9068 (buffer pool 0 only)
Dictionary cache 3643868 (69928 + 3573940)
File system 751816 (406136 + 345680)
Lock system 26860 (21188 + 5672)
Recovery system 0 (0 + 0)
Dictionary memory allocated 3573940
Buffer pool size 1023
Buffer pool size, bytes 16760832
Free buffers 697
Database pages 325
Old database pages 0
Modified db pages 7
Percent of dirty pages(LRU & free pages): 0.684
Max dirty pages percent: 75.000
Pending reads 33
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 6227, not young 16333466
0.26 youngs/s, 56.39 non-youngs/s
Pages read 3028130, created 3289, written 44377
94.56 reads/s, 0.30 creates/s, 22.30 writes/s
Buffer pool hit rate 926 / 1000, young-making rate 0 / 1000 not 43 / 1000
Pages read ahead 43.13/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 325, unzip_LRU len: 0
I/O sum[4000]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
2 RW transactions active inside InnoDB
0 RO transactions active inside InnoDB
2 out of 1000 descriptors used
---OLDEST VIEW---
Normal read view
Read view low limit trx n:o 20327242
Read view up limit trx id 20327242
Read view low limit trx id 20327242
Read view individually stored trx ids:
-----------------
Main thread id 16668, state: sleeping
Number of rows inserted 62, updated 8225, deleted 20, read 104989316
0.00 inserts/s, 6.45 updates/s, 0.00 deletes/s, 6914.91 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 17
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO) Connection for controluser as defined in your configuration failed.