… testing and found that InnoDB does more IO than MyISAM when the database is cold, …=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_…table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… with virtual machines. First is the disk IO performance hit that comes with DRBD. When …Why 4? Two of those NICs should be directly connected from one machine to another and …in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… explore the IO-bound scenario. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6…-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has…=3306 innodb_buffer_pool_size = 30G innodb_flush_method = O_DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_… = true innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000…–percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… fixed #1116177. If there are thousands of tables and slow IO then XtraBackup can spend a lot of time opening all… #1166888. Package dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer…. Due to different implementation in MySQL 5.6 error messages were not printed to stderr directly. Because of that all InnoDB error…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced… fixed #1079135. If there are thousands of tables and slow IO then XtraBackup can spend a lot of time opening all…. Due to different implementation in MySQL 5.6 error messages were not printed to stderr directly. Because of that all InnoDB error…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…baseline configuration plus: innodb_read_io_threads = 16 innodb_write_io_threads = 16 We call …=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp… = ibdata1:100M innodb_flush_method = O_DIRECT innodb_log_buffer_size = 128M innodb…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…= ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush…#####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 …repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables …
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… some benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB … Both of them have support for not caching sequential IO, adjusting the dirty page threshold, flushing the cache … via /proc, I’d vote in the other direction. Stay tuned for part two of this series, …
Post: Virtualization and IO Modes = Extra Complexity
March 21, 2011 By 12 Comments
…) or O_DIRECT innodb_flush_method. Virtualization however adds yet another layer and we need to question again whenever IO really durable in virtualized environments. My simple testing shows this may not always be the case I’m comparing O_DIRECT… is lying about write completion if we’re using O_DIRECT IO What is my take away on this ? I did not…
