Linked Questions

0 votes
2 answers
6k 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 ...
Jose Agustin Reinoso's user avatar
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 ...
baao's user avatar
  • 111
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 ...
Ranknoodle's user avatar
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 ...
Won's user avatar
  • 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). ...
Tom's user avatar
  • 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 ...
Juan Pablo Rodriguez's user avatar
2 votes
1 answer
852 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 ...
Yodavish's user avatar
1 vote
1 answer
717 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 ...
mejdenovac's user avatar
1 vote
1 answer
535 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? ...
E_Blue's user avatar
  • 111
1 vote
2 answers
346 views

Tuning MYSQL 8.0.32 for my server

EDIT: User @mustaccio let me acknowledge that I must present the problem that motivates the need for the tuning: There are querys running faster in an older server, less powerful, MySQL Version 5.7....
lio89's user avatar
  • 21
0 votes
2 answers
424 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
1 vote
1 answer
348 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?
tommo's user avatar
  • 135
2 votes
1 answer
104 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 ...
Kevin Vermaat's user avatar
0 votes
1 answer
211 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 vote
2 answers
171 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 ...
BuzzMonkey's user avatar

15 30 50 per page