…’ll get roughly 1.67x the throughput of … option in /etc/my.cnf if bandwidth is a…my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5…3 node cluster in AWS, got the volume mounted, and went to try to install MySQL. It failed miserably on the mysql…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…MySQL 5.6 GTIDs. You can find part one here. Our goal will be to go from setup #1… replication may be broken. Scenario #3: The master has crashed …cnf file in the datadir). So the last executed event is 219be3a9-c3ae-11e2-b985-0800272864ba:1… course, but very poor in my opinion: look for the binlog…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my… is similar to Flight #1. MyISAM is …hot. SSB Flight #3 Here in some…my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… isn’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate…0.11, so we’ll add this to our my.cnf: wsrep_provider_options = “gmcast.mcast_addr=239.192.0…address = gcomm://192.168.70.2,192.168.70.3,192.168.70.4 wsrep_cluster_address = gcomm://…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…introduced a regression in Percona Server for MySQL 5.5.28-29.3 which could cause a server to … Bychko). UDF/configure.ac was incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced… set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…introduced a regression in Percona Server for MySQL 5.5.28-29.3 which could cause a server to … Bychko). UDF/configure.ac was incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced… set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the …
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… some memory allocation setting in my.cnf file. On first day after doing memory allocation setting in my.cnf file, site performance was good… – 5.3.3 MySQL – 5.1.66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5.3.3 Hardware: Node:2 CPU = Quard Core RAM = 12 GB HDD = 1…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…you find in standard async MySQL replication. It is my belief that the lack of…. This setting traditionally defaulted to 0.5, meaning the queue had to fall … – the fraction of time (out of 1.0) since the last SHOW GLOBAL…cnf # name cmt sta Up Dn Up Dn Up Dn pau snt dst lcf bfa 09:22:17 myclu P 3 3…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… elect to use in some cases): vmstat 5 5 iostat -dx 5 5 If you don’t know how to…mysql 3172 3137 78 Nov19 ? 1-11:17:30 /usr/libexec/mysqld –defaults-file=/etc/my.cnf –basedir=/usr –datadir=/var/db/mysql –user=mysql… work to some number of hours, such as 3 hours. Knowing this ahead of time gives us…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…valgrind-3.8.1.tar.bz2 # Or newer tar -xf valgrind-3.8.1.tar.bz2 cd valgrind-3.8.1 ./… instance include –default-file=/etc/my.cnf (if this is where your my.cnf file is located) in order to…->84.91% (349,404,796B) 0x7A3CB0: my_malloc (in /usr/local/percona/mysql-5.5.28/usr/sbin/mysqld) | ->27.73% …
