…=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… symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
… to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O error if a bitmap file in the… between the directory and file name components in a bitmap file name could stop the server starting if the innodb_data_home_dir… warning is now returned if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… between the directory and file name components in a bitmap file name could stop the server starting if the innodb_data_home_dir… does not need to read any bitmap files. Bug fixed #1184427. Query to the INNODB_CHANGED_PAGES table would cause server to… warning is now returned if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` ( `id` int(10…_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Notice that in the case of child…. This is where Metadata files come in to play Creating a Metadata File The format of the metadata file is XML-based. I…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… a quick refresher, Xtrabackup works by copying the dirty tablespace files while streaming the redo-logs to ensure that all transactions… target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup… FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
…* && date && mysql -BNe’show engine innodb status\G’ | grep sequence && sleep 60 && date && mysql -BNe’show engine innodb status\G’ | grep sequence && ls -l… is far cheaper in modern versions of InnoDB: https://blogs.oracle.com/mysqlinnodb/entry/innodb_recovery_is_now_faster And from the…/refman/5.5/en/innodb-performance-recovery.html “If you kept the size of your redo log files artificially low because recovery…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… cases your virtual disk is basically nothing more than a file on the host filesystem rather than an actual physical volume…] /usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… prevents double caching by the file system vs the InnoDB caching. However, limited ARC size also limits ZFS file system’s internal metadata…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… about the table structure in an InnoDB page. Normally we either recover the structure from .frm files or take it from some… .frm files over taken from backups. But in some cases even .frm files is not an option: Table was dropped and innodb_file_per_table is ON Frm file corrupt, zeroed out…
