…innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 3 xtrabackup: innodb_log_file_size = 536870912 xtrabackup: use O_DIRECT >> log scanned up to (3…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…group involvement early on is a good start to this. What to… : 3 …to miss, as is the absence of innodb_log_file_size. I won’t give you a full rundown over every option in the file…in big units, so it’s hard to read. If the InnoDB buffer pool is set to 22GB, it’s much easier to…in the process of removing…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…removed…innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb…set to WT cache: The second is with WB cache: I couldn’t figure out what exactly happened with setting #3…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…innodb_log_file_size = 512M innodb_log_files_in_group = 2 innodb_max_dirty_pages_pct = 90 innodb_flush_method = O_DIRECT (the followings are XtraDB specific general settings) innodb…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…to use a non-conctextual primary key (NCPK – an auto_increment column) in nearly (emphasize nearly) every InnoDB…to group tables by certain logic, such as > you do with directories to group files. I think this makes a lot of > sense. Sometimes grouping…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…to remove it before going to production. Q: How would you migrate to XtradbCluster from a traditional Master Slave scenario when the data set…in a 3 node cluster is synchronizing with the group, are the other two nodes available to…
