… For the InnoDB tests, a 64GB buffer pool was used. O_DIRECT was used so, there was no caching of data at…_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links is recommended to…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… enabled and variable innodb_flush_method was set to ALL_O_DIRECT. Bug fixed #1131949. Fixed the RPM package dependencies for different…. A warning is now returned if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning… the right moment would make server stop with an I/O error if changed page tracking is enabled. Bug fixed #1184517…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… msandbox_ro -p msandbox -meta schemaspy.meta.xml -o /var/www/schemaspy/ The -o directive tells SchemaSpy where to write the output to…
Comment: MySQL and Percona Server in LinkBench benchmark
June 9, 2013 By 18 Comments
…. 32G BP was faster than 50GB BP even I used O_DIRECT when I tested) might not be from PCI-e flash…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… notes. Bugs Fixed: Transaction objects are now allocated calling calloc() directly instead of using InnoDB heap allocation. This may improve write… the right moment would make server stop with an I/O error if changed page tracking is enabled. Bug fixed #1184517…. A warning is now returned if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning…
Comment: Testing the Micron P320h
April 16, 2013 By 7 Comments
… I’ve observed that EXT4 still cached data even under O_DIRECT, while XFS not at all. This may also probably explain… on 13GB BP there was really x3 times more I/O ops on EXT4 than on XFS (as it should be…
Comment: Testing the Micron P320h
April 16, 2013 By 7 Comments
… with O_DIRECT the majority of the stuff what we expect file system to do is perform IO mapping from physical to direct…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb_log_buffer_size = 128M innodb_flush_log_at_trx…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… port=3306 innodb_buffer_pool_size = 30G innodb_flush_method = O_DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx…
