…MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my… in memory, InnoDB almost always performs better, at least for this workload. Notes MySQL version…. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…the same machine if you use the BLACKHOLE storage engine) in between the actual master and the slaves …also use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. If you’re …trouble is brewing. Or if you watch your MySQL server’s memory usage and you see that it’s starting…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… Percona MYSQL server and found that Percona need some configuration setting regarding to memory allocation. So we did some memory allocation setting in my.cnf file. On first day after doing memory allocation setting in my.cnf file… Version – 5.3.3 MySQL – 5.1.66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5.3.3…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL will fail to start on…,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…’ ’10.195.206.117′ ” ‘/var/lib/mysql/’ ‘/etc/my.cnf‘ ’20758′ 2>sst.err’ 120619 13:20:…. 120619 13:21:17 InnoDB: The InnoDB memory heap is disabled 120619 13:21:17…=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…engines, which was before most of us remember. And at a minimum, most servers these days need to consider the added memory…! I set my max_allowed_packet bigger and ran the following on my laptop: mysql> set @a := …memory usage over time and see how it varies. When I’m initially setting up a my.cnf…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…variables depend on hardware and mix of storage engines, while per session variables are typically workload …_size even if you have 64GB of memory to waste. Furthermore doing so may decrease performance… workload. P.S Note MySQL distribution contains bunch of sample my.cnf files which may be great …
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…memory…mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… really big and forget it. If you have enough memory, who cares. The memory isn’t allocated until it’s used — if… of storage engines (some InnoDB, some MyISAM, which is more important to you, etc) and choose an amount of memory based on… is a shame. When you are new to MySQL, trying to configure my.cnf, and you have heard guidance that seems so definite…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
… my.cnf values on large memory sizes recommend 1M settings and MySQL built-in default is 128K. Some people having a lot of memory and…` int(10) unsigned NOT NULL, `slack` varchar(50) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.00… fits in OS cache): read_buffer_size impace on in memory tableread_buffer_sizeTime (sec)82004.1516K4.1532K4.1264K4.11128K4.11256K4…
