One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… be a good idea. It also often helps with monopolizing replication thread. For example if I need to delete old data…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… avoid phantom reads and to get a consistent Statement based replication. To accomplish that, row level locking databases also acquire gap… that table. This makes reads consistent and therefore makes the replication between servers consistent. If you execute SELECT * FROM id > 1000… source of information: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… easy and affordable for everyone. You can convert your existing MySQL replication setup into a cluster in just a couple minutes. Tomorrow… Benchmarking Galera replication overhead Percona Server 5.5.15 + Galera 21.1-beta2 State of the art: Galera – synchronous replication for InnoDB Happy…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… execute on the table. mysql> show processlist; +——-+——+———–+———-+————+——+——————————+——————————+———–+—————+———–+ | Id | User | Host | db | Command…If you’re just using Innodb tables and you’re …replication…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
….6: Percona XtraBackup can now save Galera replication information while performing a backup when given…running Percona XtraBackup against debug versions of InnoDB. This is only for very advanced users….the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, …
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… weeks. Major features include: Multi sourced replication XtraBackup included IPv6 data type ZeroMQ… API (experimental) Some of the Percona InnoDB patches have been merged Since Drizzle …Drizzle protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication …
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
Kristian, This is different issue. In many versions Innodb would print wrong position for current binary log (especially if …: http://www.mysqlperformanceblog.com/2008/01/29/no-more-mysql-crash-safe-replication-in-50/ We have fixed it in Percona Server…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… MySQL replication hierarchy? We have, too. As consultants, a lot of times we need to get a quick overview of the whole replication… errors Slave mode STRICT Auto-increment increment 1, offset 1 InnoDB version 1.0.6-unknown +- [redacted].compute-1.amazonaws.com… 3 InnoDB version 1.0.16-12.8 So that’s how you can quickly find out what’s in your replication…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and getting things right… altering tables. If you have Innodb tables you’re normally OK because you can use –skip-innodb on the filtering slave and… can see no matter which road you take with partial MySQL Replication there are things to be careful with, so if you…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… storage engine for MySQL – Innodb. Innodb Storage Engine was covered in a lot of talks, many of them done by Innodb users. I found… born same as bunch of others due to statement level MySQL Replication which among other requirements, needs all auto-increment values in… mention Innodb is being blamed for a lot of “Gotches” while many of them come from MySQL limits at the time when Innodb…
