Linked Questions
33 questions linked to/from How large should be mysql innodb_buffer_pool_size?
1
vote
2
answers
6k
views
inno_db_buffer_pool_size and key efficiency
I have the following metrics from mysql workbench
After I have set innodb-buffer-pool-size to 6G, according to this answer's query on how to determine the recommended size.
While the used buffer ...
- 111
0
votes
2
answers
5k
views
Best Innodb Buffer Pool Size for 8GB RAM?
I found out that my MySQL server is configured with only 128MB for innodb_buffer_pool_size. That is not enough considering that I have a 8GB RAM server. It hosts MySQL server and an Apache/Catalina ...
1
vote
1
answer
2k
views
Can putting mysql DB into memory or having the innodb_buffer_pool_size match the size of DB increase performance?
We have a mysql database that has roughly 80 gigabytes (GB) of data using inno_db engine. We are looking to increase performance on the database (we looked at the slow log and gone through and ...
- 641
1
vote
1
answer
2k
views
innodb_buffer_pool & innodb_buffer_pool_instances [duplicate]
I have a database dedicated server with one quad-core cpu and 48GB Memory.
Total database size is about 6GB and my ultimate goal is to get the maximum performance out of this system.
At First, to ...
- 23
1
vote
1
answer
2k
views
mysql innodb_buffer_pool_size let me understand
I couldn't find answer for my situation.
I have a windows server 2008 with 2 cores and 7 GB RAM (Azure D1 VM).
I'm running mariadb 10.0.14 on it. I have 2 databases (1.5GB and 9GB in size).
...
- 11
1
vote
1
answer
1k
views
Hardware specs for MySQL database with millions of records
For 35 million records I have this table
CREATE TABLE IF NOT EXISTS `records` (
`code` varchar(12) NOT NULL,
`type` varchar(255) NOT NULL,
`used` set('y','n') NOT NULL default 'n',
PRIMARY ...
1
vote
1
answer
561
views
Mysql 5.7 innodb_buffer_pool_size - zero I/O?
I have a question regarding Mysql server 5.7, put the correct value for innodb_buffer_pool_size or increase RAM. Maybe I'm wrong, I'm not an expert, but let me explain what is it about.
Server ...
- 13
1
vote
1
answer
389
views
Estimation of appropriate innodb buffer pool size
I'm reading this thread How large should be mysql innodb_buffer_pool_size?
And perform the querys suggested by RolandoMySQLDBA and I get 307 RIBPS and 264G. That's mean that I need 307GB of RAM?
...
- 111
2
votes
1
answer
467
views
Safe values for InnoDB variables when using FULLTEXT searches
I'm using Maria DB, version 10.2.22, where one database column uses FULLTEXT for a broad document searching. However, I've ran into a "Table handler out of memory" on some searches. The ...
- 21
0
votes
2
answers
336
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 ...
- 103
1
vote
1
answer
313
views
mysql multiple database prioritize innodb buffer pool size
With a mysql instance and multiple databases within that instance is there a way to allocate which database you would like to assign priority to the buffer pool size?
- 135
2
votes
1
answer
98
views
Which hardware you suggest?
I'm completely new to buying a database hosting and I would greatly appreciate your opinion about the following situation. I just created an App and I want to go live this weekend. I want to be ...
- 123
0
votes
1
answer
182
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 ...
1
vote
2
answers
169
views
What settings should I use in my.cnf
We have about 5-6 different internal webapps (staff use only) that we will be transferring across to a new virtual server, however I need to setup our my.cnf settings first and I am lost (I am web ...
- 13
-1
votes
1
answer
154
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 ...
