…innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL… preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that… #1130145. Percona XtraBackup didn’t initialize per-thread data in the log copying…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… MySQL manual, especially the option …innodb_doublewriteblogpercona.commanual innodb_fast_shutdownblogpercona.commanual innodb_file_formatblogpercona.commanual innodb_file_format_checkblogpercona.commanual innodb_file_format_maxblogpercona.commanual innodb_file_per_tableblogpercona.commanual innodb…
Post: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
March 20, 2013 By 2 Comments
…innodb_open_files value. Bug fixed #870119 (Alexey Kopytov). Fix for the bug #711166 introduced a regression that caused individual partition…file-per-table setting for table-independent backups. Fixed by making XtraBackup auto-enable innodb_file_per…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb…case offset is correct, but file system is unaware how to align files properly. 4. Partition table and file system properly aligned; sunit/…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…” either as Innodb is very sensitive to corruptions and if any of file system errors are reported back to MySQL/Innodb it will assert… not needed for partition you store MySQL data on, as chances are MySQL server is only one doing writes on this partition anyway it… automatic file system check on startup which is normally done once per so many mounts or so many days. Large partitions with many files…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… using mysql_stmt_send_long_data call – Server buffers such data until you have executed prepared statement. Innodb Table Cache Leak – Innodb never… will likely cause your MySQL server to run out of file descriptors. The same is true for Partitioned tables in MySQL 5.1 Disk… can also use similar technique with innodb_file_per_table. However you can’t control growth of Innodb system tablespace which is used to…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
… and how data was lost: MySQL had a dedicated partition on XFS file system Server was running innodb_file_per_table There was a production master…?) – 10G partition was scanned in like 5 minutes and all 4G of innodb pages were successfully written to a separate partition. That’s…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb-flush-log…response time, get a good plan optimizer-prune-level=0 partition=ON port=3306 read-buffer-size=512K read-rnd-…
Post: Percona Server and XtraBackup weekly news, February 5th
February 6, 2011 By 2 Comments
… without referring to the documentation. There was discussion about making innodb_file_per_table a session variable. There was discussion on a bug…, tests for partitioned tables. Bug reported: when filtering by table name, innobackupex doesn’t back up all *.par files for partitions. Also, a…
