Linked Questions
34 questions linked to/from How large should be mysql innodb_buffer_pool_size?
-1
votes
1
answer
163
views
Extremely slow requests on small innodb tables
The situation is the following. Two InnoDB tables, one has 2 records, another one - 281 - small ones, insert and update requests may last up to two (!) minutes. Dropped db, created again. The ...
2
votes
1
answer
106
views
should I change mysql platform for higher innodb_buffer_pool_size?
Currently Im running a 160G MySQL database on Xampp (Windows). But Xampp has upper limit for innodb buffer pool size of 4G. My computer has 16G RAM. So if I want to make full use of resources, should ...
- 21
1
vote
0
answers
190
views
MySQL using more memory than allocated in InnoDB
I have a Ubuntu 20.04 machine with 64 GB of RAM that is used both as a web server and for MySQL version 8.0.35. I am using InnoDB, but even if the innodb_buffer_pool_size variable is set to 128MB, the ...
- 11
0
votes
0
answers
54
views
Optimising InnoDB configuration in MySQL80 Server
I have a WAMP production environment, currently running Apache24, MySQL57, PHP73 on two Windows Server 2016 servers - an application server and a dedicated database server - and I'm toying with the ...
- 101