… 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following… 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
… gap locks to SELECT … FOR UPDATE ” on my server ,and my results are as follow: Transaction1: root…from t; +——+ | i | +——+ | 21 | | 30 | | 26 | +——+ 3 rows in set (0.00 sec) root@localhost:test 14:51:…s), heap size 1216, 1 row lock(s) MySQL thread id 31929, query id 484616 localhost root…
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… connection. In Percona Server you can do better as you can query temporary tables too: mysql> select sum…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Introducing the pmp-check-mysql-status Nagios Plugin
March 29, 2012 By Leave a Comment
… it excellently. This makes the plugins easier to set up and use, and I believe it …counters and variables. This is the pmp-check-mysql-status plugin, which can perform computations on status… the Uptime variable is too small, indicating the server has been restarted Check whether Threads_connected is…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… make MySQL read only. In many cases the period for which server … show processlist | 0 | 0 | 1 | +——-+——+———–+———-+————+——+——————————+——————————+———–+—————+———–+ 5 rows in set (0.00 sec) As result …
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
…compatible with MySQL or Percona Server in the following meaning: Data compatibility. Percona XtraDB Cluster works with databases created in MySQL / Percona Server …Cluster Percona XtraDB Cluster is based on Percona Server with XtraDB and includes Write Set REPlication patches. It uses the Galera …
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… source of information: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the…
Comment: MariaDB 5.3 is released as GA!
March 6, 2012 By 17 Comments
… microsecond timestamp support in version 5.6, yes. MySQL is unlikely to be a usable solution for GIS anytime … 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: Making the impossible: 3 nodes intercontinental replication
March 21, 2012 By 25 Comments
… setup script. I had a quick question: I set up three nodes on three different Availability Zones …command not found” I’m not able to find mysql_install_db anywhere on the file system either. … either. Should I install Percona server: http://www.percona.com/doc/percona-server/5.5/installation.html on …
