…. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances…
Post: How to change innodb_log_file_size safely
July 9, 2011 By 17 Comments
… MySQL’s innodb_log_file_size parameter (see How to calculate a good InnoDB log file size), you can’t just change the parameter in the my.cnf file and restart the server. If you do, InnoDB will refuse…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… value of innodb_max_files_open in InnoDB: my.cnf. InnoDB: fil_sys open file LRU len 0 091118 18:47:44 InnoDB: Warning: too many (68) files stay… on hardware log file size workload and even when crash happen (how many unflushed changes we had) Repeating test with innodb_open_files=16384 I…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… table by mask: xtrabackup –defaults-file=/etc/my.reg.cnf –backup –tables=tpcc.order_line* –…innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 92684288 xtrabackup: Starting InnoDB…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
… was really puzzled, looking for answers in MySQL status counters, innodb status, memory info and what not. It seemed that the…_binlog_size in size, new binary log is created and, if expire_logs_days is not zeroish, log files older than expire_logs_days are removed. &LOCK_log… have reduced the size of binary log file from default 1GB (some systems have it set to 100MB in their default my.cnf) down to…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_files_in_group=2 innodb_log_file_size=1900M innodb…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… /usr/bin/mysqld_safe –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1-11:17:30 /usr/libexec/mysqld –defaults-file=/etc/my.cnf –basedir… is the absence of innodb_log_file_size. I won’t give you a full rundown over every option in the file. But again, you…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 17 Comments
… 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…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…# You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server…innodb_buffer_pool_size = 8000M #innodb_additional_mem_pool_size = 80M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log…
