The variable I am trying to change is innodb_buffer_pool_size. As you can see below the settings is 512M. But SELECT @@innodb_buffer_pool_size;
returns 134217728.
When I execute: /usr/libexec/mysqld --help --verbose
My resulting config is:
Default options are read from the following files in the given order:
/etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf
- /etc/mysql/my.cnf - does not exist
- /etc/my.cnf - is shown below
- ~/.my.cnf - when I
cd ~/
I am taken to /root where no my.cnf files exist. Does mysql run as root, would it be taken to the same directory? How can I tell?
Here is my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
skip-networking
innodb_thread_concurrency = 6
innodb_flush_log_at_trx_commit = 2
thread_concurrency = 12
table_cache = 1024
query_cache_size = 64M
query_cache_type=1
query_cache_limit = 4M
expire_logs_days=10
max_binlog_size=100M
join_buffer_size = 8M
tmp_table_size =256M
max_allowed_packet = 2M
thread_stack = 192K
thread_cache_size = 32
thread_concurrency = 4
table_open_cache = 4096
myisam-recover=BACKUP
max_connections = 2500
max_heap_table_size = 256M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_max_extra_sort_file_size = 10G
myisam_repair_threads = 1
innodb_additional_mem_pool_size = 8M
innodb_log_buffer_size = 4M
innodb_log_file_size = 128M
innodb_log_files_in_group = 2
innodb_flush_log_at_trx_commit = 0
innodb_buffer_pool_size = 512M
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:256M:autoextend
innodb_autoextend_increment=512
slow_query_log = Off
slow_query_log_file = /var/www/html/log/mysql/slow-queries.log
long_query_time = 2
innodb_file_per_table = 1
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[isamchk]
key_buffer = 32M
cat /etc/my.cnf.d/*
andcat $(grep mysql /etc/passwd | cut -d ":" -f 6)/my.cnf
. You have alsomysqld --print-defaults
.SHOW VARIABLES LIKE 'basedir';
to see if it points to the directory withmy.cnf
(ormy.ini
). Checkmysqld.err
.strace mysqld --print-defaults
. You will see which files are actually read by MySQL. If/etc/my.cnf
is not open, check that it belongs to mysql user and is readable by its owner. Also check that no configuration file is read after that. Then you'll see the list of settings - values read from files and default values, check the value for innodb_buffer_pool_size.