… has killed MySQL and made it closed-source”, whilst they haven’t made it closed-source, what they do appear to have… process public) instead for the longer run. Upgrading to the latest version of MySQL is fine from a general perspective, but Oracle….) Given MariaDB is MySQL with patches, I‘m not sure quite how much that gains, or if MariaDB are basically doing that work and…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
Upgrading MySQL Server is a very interesting task as you can approach … safer upgrade path than 4.1 to 5.1 just because so much more people have followed that road. So how do people approach the upgrade process ? I will describe couple of processes which I‘ll call “reckless” and “safe…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… ask us how we do a performance audit (it’s our most popular service). I thought I should …what the operating parameters are. Can we suggest upgrades, rewriting queries, or whatnot? Sometimes there are …do to just assume there’s a single instance in /var/lib/mysql and it’s reading from /etc/my.cnf. I…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… little bit more time while you’re upgrading to Percona Server or newer MySQL version or doing application/architecture changes. Reducing number of… innodb_thread_concurrency and doing other server tuning should be first on your list. I also wanted to highlight how much context switches…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 1 Comment
…upgrading your servers. pt-upgrade This tool lets you test your SELECT queries against multiple MySQL servers and reports on how… time including execution errors and warnings. So how do you exactly test your queries on … account for testing – one that has read (i.e. SELECT) to all objects within …
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
I recently worked on upgrading MySQL from one of very early MySQL 5.0 versions to Percona Server 5.1. This was a classical upgrade… we can’t just do a reckless upgrade First we needed to do a sanity check on … logs for the last month to see how frequently this functionality is used. Happily there …
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… you do ? First if you followed MySQL upgrade best practices such as testing your workload with pt-upgrade the … and what exactly changed for worse. I am speaking about MySQL upgrade – version change but in a … forced to change your application by changing how query is written and provide the hints. …
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… reasonable ? Do we need longer support cycle or shorter would make sense ? How long older platforms need to be supported ? I think for… with MySQL 5.1 but support with MySQL 5.5 is not needed as people doing major MySQL upgrade usually would have an option to upgrade operating system as well Or is MySQL Upgrade…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… problems, with magically means nobody knows how exactly. I would suggest always to question yourself where do you expect these performance gains to… nature of MySQL replication is a showstopper) and it also solves the other big pain of semi-online MySQL/OS upgrades and Schema changes. Backups SAN has number of advantages for operations (and I guess these are…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…lost on restart. Many people understanding this do not quite recognize how long it takes, and by …able to catch up. MySQL or OS version changesMySQL version changes (even minor upgrade) may introduce issues …. In could be even system which queries mysql. I‘ve seen monitoring updates which would add …
