MySQL Forums
Forum List  »  Install & Repo

innodb_buffer_pool_size doesn't change
Posted by: Stefan Simmerstatter
Date: May 07, 2015 12:42AM

Hello together,


can someone tell me what i can do if the innodb_buffer_pool_size stays at the default of 128mb instead of the 3gb from my configfile ?
I also tried 3072M, 3145728K and 3221225472.

System:
Ubuntu Server 14.04
MySQL Server 5.6.24 (x64)


my.cnf:

[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

[mysqld_safe]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
explicit_defaults_for_timestamp

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1

log-error = /var/log/mysql/error.log

# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
innodb_read_io_threads = 64
innodb_log_file_size = 104857600
innodb_buffer_pool_load_at_startup
max_allowed_packet = 1G

innodb_buffer_pool_size = 3G

[mysqldump]
max_allowed_packet = 2147483648

Options: ReplyQuote


Subject
Written By
Posted
innodb_buffer_pool_size doesn't change
May 07, 2015 12:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.