… come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the… I am using “estimate” flushing method available only on Percona Server. The “estimate” method reduces the impact of traditional InnoDB log… that we can see the impact of growth in data-set on the insert rate. We can see that adding the…
Comment: InnoDB's gap locks
May 7, 2012 By 15 Comments
… “the affect gap locks to SELECT … FOR UPDATE ” on my server ,and my results are as follow: Transaction1: root@localhost:test…>select * from t; +——+ | i | +——+ | 21 | | 30 | | 26 | +——+ 3 rows in set (0.00 sec) root@localhost:test 14:51:40> Transaction2…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… | sum(data_length+index_length) | +——————————-+ | 126984 | +——————————-+ 1 row in set (0.98 sec) This however will not cover… and will result in increased memory allocation until server is restarted. I would suspect memory leak when…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…writes will be blocked to the server, which in the end causes “field …| show processlist | 0 | 0 | 1 | +——-+——+———–+———-+————+——+——————————+——————————+———–+—————+———–+ 5 rows in set (0.00 sec) As result …
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
Shlomi, Yes setting server read only would be solution. Though it is still too bad setting server read only…. When we speak about Innodb…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
…. Percona XtraDB Cluster works with databases created in MySQL / Percona Server Application compatibility. There is no or minimal application changes required… Cluster Percona XtraDB Cluster is based on Percona Server with XtraDB and includes Write Set REPlication patches. It uses the Galera library…
Comment: MariaDB 5.3 is released as GA!
March 6, 2012 By 17 Comments
… work, and many changes would also be needed to the server itself. PostGIS is not only better than MyISAM’s GIS… a blog post on the differences between MariaDB and Percona Server. They are fundamentally different and targeted towards very different use… of misconceptions, such as “Percona Server is just a set of patches” or “MariaDB has everything Percona Server has and more.” Henrik: mea…
Comment: Fixing column encoding mess in MySQL
March 14, 2012 By 32 Comments
… tables with latin1 encoding. Tried: ALTER TABLE CONVERT TO CHARACTER SET utf8; Does nothing except changes table/column encodings, but no… try the nr2 way mentioned in this blog: UPDATE table SET column=CONVERT(CONVERT(column USING binary) USING utf8) WHERE id…; And it.. Does nothing. £ sign stays the same, nothing changes. Server version: 5.1.61-0ubuntu0.11.10.1
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
…. This makes reads consistent and therefore makes the replication between servers consistent. If you execute SELECT * FROM id > 1000 FOR UPDATE… a global variable that affects all sessions and needs a server restart to change its value. Both options cause phantom reads…://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation…
Comment: Making the impossible: 3 nodes intercontinental replication
March 21, 2012 By 25 Comments
… and the setup script. I had a quick question: I set up three nodes on three different Availability Zones (US East… work on either. Should I install Percona server: http://www.percona.com/doc/percona-server/5.5/installation.html on these images…
