Question : No, increase in innodb_buffer_pool_size would be helpful. When innodb_data_reads / uptime result is < 1.00 there is no […]
Tag: buffer-pool
Why is InnoDB so painfully slow on full table scans even though entire data is in buffer pool?
Question : Environment AMD Ryzen 9 5950X, 128GB 3200MHz Dual Channel Datacenter NVMe SSDs with 3GB/s+ read and write MariaDB […]
innodb cache duplication due to os page cache and buffer pool
Question : We have set our innodb buffer pool 80% of total memory. Mysql page allocation gets stalled sometimes when […]
What’s the exact meaning of `innodb_max_dirty_pages_pct`, and how does it relate to the redo log?
Question : I’m puzzled by the innodb_max_dirty_pages_pct parameter, and its relation to the redo log. The definition itself is simple: […]
Sudden MySQL freeze, with spike in dirty pages, but without obvious write queries
Question : I’m systematically (1/2 times per day) experiencing a freeze in the DB server. Suddenly, all the COMMITs get […]
Can large data deletion affect Innodb buffer pool performance? [duplicate]
Question : This question already has answers here: Do I need to reindex my table in mysql after delete? (2 […]
Reason for using write barrier before unlocking the buffer header in Postgresql
Question : I was reading the source code for buffer management in Postgres. In buffer management, there is a macro […]
“Approximately equal” between Sync and Async operations for PageCleaners
Question : The documentation of num_iocleaners says: The parameter can be reduced if both of the following conditions are true: […]
Querying MySQL InnoDB to find if the Record is in its Buffer Pool
Question : For us, it is very important to get high response time for our website php script which queries […]
need to do some fine tuning on my Innodb Buffer
Question : Evening all, I have a modest 6GB database running in MySQL 8.0.x.. my dedicated server is only running […]