Bug #44408 Innodb_buffer_pool_size is set too big by default

• Submitted: 22 Apr 2009 13:33
• Modified: 23 Sep 2009 0:30
• Reporter: Oli Sennhauser
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S2 (Serious)
• Version: 5.4.0
• OS: Any (Linux, Mac OS X)
• CPU Architecture: Any

[22 Apr 2009 13:33] Oli Sennhauser

Description:
Starting MySQL with the default settings sets the innodb_buffer_pool_size to 1 Gbyte on my 1 Gbyte machine:

| innodb_buffer_pool_size | 1073741824 |

USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
mysql    20512  0.6 10.8 1360868 111856 pts/4  Sl   15:24   0:03 mysqld

How to repeat:
client]

port          = 5400
socket        = /home/mysql/run/mysql-5400.sock

[mysqld]

port          = 5400
socket        = /home/mysql/run/mysql-5400.sock

log-error     = error.log

Suggested fix:
Official recommendation is: 80% of RAM.

[22 Apr 2009 17:32] Valeriy Kravchuk

Thank you for the bug report. Verified just as described.

[23 Apr 2009 13:31] Mikhail Izioumtchenko

this appears to be a 5.4 feature, not present in anything that Innobase released,
changing the category

[23 Apr 2009 13:33] Mikhail Izioumtchenko

correcting the status which I accidentally set to Feedback. Back to Verified

[27 Apr 2009 19:21] Omer Barnir

triage: setting to not a bug following discussion - 5.4 as a performance release is set out of the box to run on high end machines.

[28 Apr 2009 6:32] Sergei Golubchik

1GB is way too much. Just as the old default - 8M - was way too little.
The default configuration will run *slower* than 5.1 out of the box for many installations - as the vast majority of users that use the default settings don't use "high end machines" - and those that do, don't use default settings.

[25 Jun 2009 21:28] Allan Packer

A static default is a lot easier to implement, but it might be more useful to set it to either a percentage of system memory (70%, say) or 1GB, whichever is _lower_. That would allow a decent amount of memory on systems that could support it (up to 1GB), while still supporting systems with a smaller memory footprint.

[21 Sep 2009 20:40] Calvin Sun

Fixed in 5.4.3.

[23 Sep 2009 0:30] Paul DuBois

Noted in 5.4.3 changelog.

The default value of innodb_buffer_pool_size was set to 1GB in MySQL 
5.4.0. This was too large for many installations, so the default has
been lowered to 128MB.