… For example: Transaction commit takes approximately the worst packet round trip time (RTT) between any two … are inflight in the form of deadlock errors. (This is actually a form of Eventual …s law for Galera. We must have group communication to replicate and establish global ordering for every…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… mysql> use test ERROR 1047 (08S01): Unknown command If you try to insert data just while the communication problem occurs, here is what you will have: percona1 mysql> insert into percona values (0,’percona1′,’peter’); ERROR 1213… 2012-07-24 11:42:51.268 INFO: Changing maximum packet size to 64500, resulting msg size: 32636 2012-07-24…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…such as ifconfig (which shows good stuff like dropped packets). Starting to look at MySQL Assuming I don’… you. I will also look at the error log. The error log shows all sorts of interesting things. … small adjustments to the direction we’re going, communicate to the client how much time we’re …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… to spread processing over up to 20 nodes. The Infobright Community Edition (ICE) images are available in 32 and 64 bit…-infile=on lock-wait-timeout=300 log-error=/var/log/mysqld-innodb.log max-allowed-packet=1M net-buffer-length=16K #we…
