… available. You can watch the recording and get the slides here. I got a lot …? The first question sounds like a potential MySQL bug. Are you sure this is really … causes way too many bugs in the server and the tool, so there is no… you’re using an old version of the tool. Q: Old version of PT OSC said…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… regular community MySQL 5.5.23 or does it only work (or work better) with a Percona type version of MySQL – ie one of Percona’s “improved” versions of MySQL (that is what Percona does, isn… happening on the server. Any ideas on what is happening here? It seems as if MySQL 5.5 has been getting much slower…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
… in an environment with a large three digit number of servers, and in which we clone new slaves from existing slaves… Oracle MySQL 5.5.x (x=16 on many boxes atm), but we have been experiencing this with many versions of MySQL. We are now using ‘service mysql stop’ instead of FLUSH TABLES WITH READ LOCK to get reliable snapshots…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
…This is different issue. In many versions Innodb would print wrong position for current binary log (…01/29/no-more-mysql-crash-safe-replication-in-50/ We have fixed it in Percona Server. Also if you…consider doing SHOW SLAVE STATUS/SHOW MASTER STATUS to get proper position instead of relying on that …
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL version might just be the most critical operations you ever do once server is moved into…. Why? RedHat and CentOS are the only platforms getting packages from all MySQL and MySQL-fork vendors – Oracle, MariaDB and Percona. By my…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… (for example with MySQL Sandbox) can especially be helpful. Once you have spotted the query which performs differently between MySQL Server versions you should… and increasing innodb-stats-sample-pages to get more accurate results. In recent Percona Server versions and MySQL 5.6 you can also store…
Post: What's the recommended MySQL version?
August 15, 2011 By 24 Comments
… great question: “Which version of Percona Server is currently recommended?” It’s really the same question as “Which version of MySQL is currently recommended… biggest distinguisher). For an existing MySQL database server, I’d encourage not jumping on a new version immediately when it comes out. Let… the near future. At this point, MySQL 5.1 is starting to get old, and MySQL 5.5′s new releases have just…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… MySQL or Percona Server 5.1 than 5.5 Facebook also sticks with MySQL 5.1 even though their highly patched and improved version. MySQL… kind of Version and Platform support do you think is adequate for MySQL ? Oracle seems to have extended support for MySQL versions rather significantly… supported platforms it gets a bit more confusing. Per this table RHEL4 is Supported all the way to MySQL 5.5 yet…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… engine, is to get rid of–purge–the old versions of the records as they become obsolete. In MySQL 5.1 this is… the moment seems to be the one in Percona Server 5.1. MySQL 5.6.2 multiple purge threads have major issues… solve them. However, MySQL 5.6.2 is experimental code and I am sure that next MySQL 5.6 versions will contain a…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… causing replication to lag. Failed hard drive getting RAID in degraded mode could be one common…Automatic Buffer Pool Save/Restore available in Percona Server is great help in this case. Changing … never is able to catch up. MySQL or OS version changesMySQL version changes (even minor upgrade) may …
