…version used: 5.6.11, custom compiled to remove performance_schema For the InnoDB tests, a 64GB buffer pool was used. …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_…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…, and were not removed when incremental backups has been merged. Fixed by removing files corresponding to tables… the MySQL 5.6 backup if the log files were bigger than 4G on the source server…fixed #1169509. innobackupex wasn’t handling the innodb_data_file_path option which could cause backup to …
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…that are caused by the log records in the transactional log being overwritten before they … and were not removed when incremental backups has been merged. Fixed by removing files corresponding to tables…files behind due to a typo. Bug fixed #1172016. innobackupex wasn’t handling the innodb_data_file…
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 …client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed from Percona XtraBackup….file exists once innobackupex starts, and try to remove it or fail if it cannot be removed. …
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… configurable. Also, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that…logs. So the ability to parse memcached, Postgres, Apache, and other logs was removed. We also removed…tools: –user, –host, –port, –password, –socket, –defaults-file. So now the command line is …
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… expire_logs_days is not zeroish, log files older than expire_logs_days are removed. &LOCK_log mutex is held for the duration of the binary log removal and if your file system…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…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…_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Next step is to remove created .ibd file, it’s done …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… not forget you may need to increase size of your Innodb log files to be able to use a lot of memory for… first file in a log file group. My questions are: What is always being written to the first file in the log file group? HT: InnoDB writes… hardware, and also on the OS version. In our tests, removing one bottleneck moves the contention to another place. Thus, no…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…autoextend 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_…uniform distribution. The results you can see there: (Results are removed for additional checking) In the next run I tested …
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… we are discussing here holds for when you are using innodb_file_per_table. Implementation Before going into showing how Lazy Drop… cleaning the bufferpool is buf_LRU_flush_or_remove_pages(space_id, BUF_REMOVE_FLUSH_NO_WRITE). Here space_id is the… is 6G. The value of innodb_max_dirty_pages_pct was set at 90, while the InnoDB log files were sized at 4G. The…
