…in this series. Regardless, when the working set fits in memory, InnoDB almost always performs better, at least for this…=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_buffer…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 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… a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug… fixed #1186690. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would make server stop with an…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… fixed #1185686. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would make server stop with an… between the directory and file name components in a bitmap file name could stop the server starting if the innodb_data_home_dir… a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… so I find it convenient to set it up on crontab so …_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` (…Metadata files come in to play Creating a Metadata File The format of the metadata file …high level overview of the table sizes and an easy way to …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_block_size… defaults, as I understand from documentation TokuDB comes with good settings out-of-box, but I am ready to tune something…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… data set size in relation to both the working set and the cache device size, the numbers…innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb_log_buffer_size = 128M innodb…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…) about Linux swappiness setting, which basically controls how important is the file cache for Linux. Basically, with InnoDB, since the file cache is not… using the numactl utility, drop the file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_populate option. That… a split operation to create files of 5GB since the backup size is about 28GB and the file upload size limit is 5GB. So…
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… 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 ranges…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… significant amount of writes to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting it too large will increase… 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…
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) setting? In general, there are two settings that simply can’t be left…
