Linked Questions

0 votes
2 answers
433 views

Optimization: Increase Innodb_pool_size useful?

We run an AWS RDS instance with 8vCPUs and 64GB memory. All tables are using InnoDB engine. I have kept the default setup of innodb_pool_size to be half the memory. What I see is that almost 30Gb of ...
Kaymaz's user avatar
  • 103
0 votes
0 answers
50 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 ...
Bence Gajdán's user avatar
0 votes
1 answer
212 views

MySQL query very slow for one object, very fast for others

I have a table for Items and then a table for Parameters where each Item can have multiple Parameters. Each Parameter object has a foreign key back to its Item. I also have a Parameter Type table that ...
samskeller's user avatar
-1 votes
1 answer
161 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 ...
Windy Wanderer's user avatar

15 30 50 per page
1 2
3