… Server 5.5.22-25.2 on April 25, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.22, including all the bug fixes in it, Percona Server 5.5.22-25.2 is now the… keys. Bug fixed #892951 (Laurynas Biveinis). Release notes for Percona Server 5.5.22-25.2 are available in our online documentation.
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
…x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I …to do and causes way too many bugs in the server and the tool, so there is no code in … of this tool? It was completely rewritten in version 2.1. Q: qw() as use of () is deprecated That …
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following…_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct… I am using “estimate” flushing method available only on Percona Server. The “estimate” method reduces the impact of traditional InnoDB log…
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
… “the affect gap locks to SELECT … FOR UPDATE ” on my server ,and my results are as follow: Transaction1: root@localhost:test… inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1216, 1 row lock(s) MySQL thread…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… you close connection. In Percona Server you can do better as you can query temporary tables too: mysql> select sum(data_length… 16384 INDEX_LENGTH: 0 CREATE_TIME: NULL UPDATE_TIME: NULL *************************** 2. row *************************** SESSION_ID: 7234 TABLE_SCHEMA: test TABLE_NAME: tmp…
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 …Galera library is developed by Codership Oy company and Galera 2.x supports such new features as: Incremental State Transfer, …
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… of the XtraDB buffer pool (LRU), namely Percona Server, this will enable a server restored from backup to give excellent performance without… file copying (‘–parallel’). For example, ‘–parallel=4 –compress –compress-threads=2‘ will create 4 IO threads that will read the data and pipe it to 2 compression threads. New streaming format to work with parallel compression…
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: 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 … dumptest | Query | 0 | NULL | show processlist | 0 | 0 | 2 | +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ 3 rows in set (0.00…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
…reads consistent and therefore makes the replication between servers consistent. If you execute SELECT * FROM id > … create locks to prevent that from happening. 2- innodb_locks_unsafe_for_binlog = 1. Disables….1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation …
