…: 2048 kB My limits.conf looks like this: mysql soft memlock unlimited mysql hard memlock unlimited My my.cnf looks like this: large-pages innodb_buffer_pool_size=4G . If I su to mysql…
Comment: Percona build7 with latest patches
November 20, 2008 By 26 Comments
…or more optimal my.conf file should looks for persona MySQL to keep let’…buffer_size = 2097152 innodb_file_per_table innodb_log_file_size=500M innodb_buffer_pool_size=1600M innodb_additional_mem_pool_size=20M innodb_log_buffer_size=8M innodb_checksums=0 innodb_doublewrite=0 innodb_support_xa=0 innodb…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 17 Comments
… other conf file other than /etc/my.cnf [root@tstlx1 mysql]# locate my.cnf /etc/my.cnf /etc/my.cnf.old /etc/my.cnf.rpmnew [root@tstlx1 mysql]# cat /etc/my.cnf | grep log_file # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 64M…
