…the testing and found that InnoDB does more IO than MyISAM when the database is cold, but…keys with sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local…table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links is…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… DRBD with virtual machines. First is the disk IO performance hit that comes with DRBD. When you …ports. Why 4? Two of those NICs should be directly connected from one machine to another and configured …also use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. If you’re …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… during “prepare” phase and instead of having files created using direct IO they were buffered in OS cache and so writes to… benchmark is IO bound. That said, benchmark was running on a Percona Server 5.0.92-87 with the following my.cnf configuration…_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… a micro instance, simply decrease the values in the /etc/my.cnf file if you really want to try micro instances.*EDIT….287,581.295,11.042,63.366,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket… innodb-flush-method=O_DIRECT innodb-ibuf-active-contract=1 innodb-import-table-from-xtrabackup=1 innodb-io-capacity=1000 innodb-log…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf settings: innodb_buffer_pool_size=24G innodb_data_file_path…=16 innodb_flush_method = O_DIRECT innodb_write_io_threads=8 innodb_read_io_threads=8 innodb_io_capacity=500 innodb_max_dirty_pages…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… size of 512MB and innodb_flush_method=O_DIRECT Test Setup: [root@localhost msb_ps_5_5_15..._ps_5_5_15]# time mysqldump –defaults-file=my.sandbox.cnf test md_cache_test_big > /dev/null … with only 12MB remaining. This makes workload extremely IO bound hence such drop in performance. The performance …
