Linked Questions

2 votes
1 answer
102 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 ...
Shaowen's user avatar
  • 21
2 votes
1 answer
5k views

Can I reduce MySQL memory usage, or do I need to add more RAM?

I have a VPS with 2.25GB of RAM. MySQL is using 1.4GB with only four users on my site right now. It seems to use this amount even when no users are online. The available memory of my server regularly ...
Nate's user avatar
  • 191
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
2 votes
1 answer
23k views

Configuring MySQL (my.cnf) for MyISAM and InnoDB

I want to convert some (not all) the MyISAM tables to InnoDB. Current my.cnf Show engines output Server has two 6-core Xeon processors (2 threads per core = 24 threads) What would be the best ...
tschelik's user avatar
1 vote
1 answer
728 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
543 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
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
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
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
349 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
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
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
1 vote
0 answers
94 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 ...
marcos's user avatar
  • 11
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

15 30 50 per page