…, 5.6-style buffer pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5… fail when preparing the MySQL 5.6 backup if the log files were bigger than 4G on the source server. Bug fixed… well. Bug fixed #1169509. innobackupex wasn’t handling the innodb_data_file_path option which could cause backup to fail. Bug fixed…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…, 5.6-style buffer pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5… prevent XtraBackup failures that are caused by the log records in the transactional log being overwritten before they are copied by the… leave xbtemp temp files behind due to a typo. Bug fixed #1172016. innobackupex wasn’t handling the innodb_data_file_path option which…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes=1\” > /var/log/playback.log 2…, and only have a log file for debugging purposes. Streaming logs from stdin Percona Playback now supports the –query-log-stdin command-line option…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… when rebuilding secondary indexes on innobackupex –apply-log –rebuild-indexes. This allows parallel processing of… command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed …fixed #1168513. Percona XtraBackup would leave xbtemp temp files behind due to a typo. Bug fixed #…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts,…on its primary objective: analyzing MySQL query logs. So the ability to parse memcached, Postgres, … tools: –user, –host, –port, –password, –socket, –defaults-file. So now the command line is what …
Post: How to calculate a good InnoDB log file size
November 21, 2008 By 38 Comments
… wrote a post a while ago about choosing a good InnoDB log file size. Not to pick on Peter, but the post…. Since there are two log files by default, divide that in half, and now you can set innodb_log_file_size=64M Does that look surprisingly small? It might. I commonly see log file sizes in the gigabyte…
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
… gather statistics about how the log file writes are distributed in terms of write size. InnoDB writes to the log files in multiples of 512… So, in sum, we see that about 3/4ths of InnoDB log file writes on this workload are 512 or 1024 bytes. (It… 4k. This server has innodb_flush_log_at_trx_commit set to 2. This means each transaction does a log file write, the same…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… you’re doing significant amount of writes to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting… on recovery and why large innodb_log_file_size slows down recovery. During startup after crash Innodb scans log files to find log records which only have…
Post: How to change innodb_log_file_size safely
July 9, 2011 By 17 Comments
… 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… the old log files. The typical error message you’ll see in the client when InnoDB has refused to start due to log file size…
Post: Should MySQL update the default innodb_log_file_size?
November 21, 2011 By 37 Comments
… that InnoDB is the default storage engine in MySQL, is it time to update the default configuration for the InnoDB log file size (innodb_log_file_size… of 8MB), but the log file size remains at 5MB. That’s 10MB total, because there are two logs by default. Is it… for a default log file size into the comments. By the way, if you’re looking to choose a good log file size for…
