Questions tagged [bufferpool]
5 questions
1
vote
1 answer
Why is InnoDB so painfully slow on full table scans even though entire data is in buffer pool?
Environment
AMD Ryzen 9 5950X, 128GB 3200MHz Dual Channel
Datacenter NVMe SSDs with 3GB/s+ read and write
MariaDB 10.6.3 x64
Windows Server 2019 (same issue on Debian though)
dedicated machine, no other tasks…
Alex K.
- 129
- 1
- 8
1
vote
1 answer
What's the impact of innodb_buffer_pool_dump_now in Running MySQL Instance?
The parameter innodb_buffer_pool_dump_now dump the least recently used pages into the file ib_buffer_pool.
And the parameter innodb_buffer_pool_load_now restore that file into the buffer pool again.
Question is-
Whenever we run the below command in…
Aman Aggarwal
- 17,619
- 9
- 53
- 81
0
votes
2 answers
How to updated my.cnf file to increase innodb-buffer-pool-size?
I am trying to updated the my.cnf file to increase the buffer pool size for a query I am running in python via mysql because I keep getting the error:
OperationalError: 2013 (HY000): Lost connection to MySQL server during query
Now I have located…
Astro_raf
- 57
- 5
0
votes
1 answer
What is Unzip_LRU list?
I am learning mysql buffer pool.
I know that buffer pools have lru list and unzip lru list in the InnoDB storage engine.
I don't know why InnoDB buffer pool use the unzip lru list.
Why use unzip lru list and when?
haedoang
- 13
- 1
- 3
0
votes
1 answer
Mysql Show InnoDB status not reporting buffer pool stats correctly on Linux
We have multiple slaves running MySQL 5.7 - some on Linux (CentOS 7) and some on Windows. We're trying to diagnose an issue where our linux boxes randomly start falling behind with no long running queries or locks or dramatic increases in writes and…
Matthew Conradie
- 990
- 2
- 8
- 17