… regression cases when upgrading from MySQL 4.0 and 4.1 to MySQL 5.0. By serious I mean several times performance difference not just 5-10% you often… MySQL 5.0 and 5.1 would not get any fixes for this problem, so lets see who is affected, how to check you’re affected and how to…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… when you upgrade to different major version, especially if you skip over one. MySQL 5.0 to 5.1 upgrade is a lot safer upgrade path than 4.1 to 5.1 just because so much more people have followed that road. So how do…
Post: Rebuilding MySQL with same options
April 8, 2010 By 4 Comments
…MySQL. How to upgrade to the new MySQL Options while preserving as much of original compilation options as possible if original build scripts are not available ? MySQL…’ ‘–with-low-memory’ ‘–with-comment=FreeBSD port: mysql-client-5.0.67_1‘ ‘–enable-thread-safe-client’ ‘–with-charset=cp1251′…
Comment: Upgrading MySQL
January 17, 2010 By 23 Comments
… my experience upgrading MySQL can be trivial to rather a pain. Here I’m talking about major version changes such as 5.0 to 5.1. This also depends on various issues one of which is the amount of downtime you can take and also how… theory” an issue with 5.0 to 5.1 upgrades that when you run mysql_upgrade it tries to check and upgrade all tables which need to be changed but fails…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…to recover from disasters? We also want to know what the operating parameters are. Can we suggest upgrades…5 5 iostat -dx 5 5 If you don’t know how to read these, there’s a full explanation in our book, High Performance MySQL…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… HT: 5.0.xx, where xx >= 30 should be better than 4.1.xx. PZ: I should note MySQL 5.0 vs 4.1 …that random writes to them are actually slower than to a mechanical disk. I do not know how it is …Linux/Mysql server for a client, upgrading their main database (from 16GB, 2 two-year old HT’ed XEONs to …
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…how…5.00g mysql-data 0.00 mysql-data-201202230153 sb swi-a- 5.00g mysql-data 0.00 mysql-data-201202230155 sb swi-a- 5.00g mysql-data 0.00 mysql…to execute a long running ALTER or server upgrade…
Post: Data Corruption, DRBD and story of bug
November 29, 2010 By 6 Comments
… pastebin. Everything below is related to InnoDB-plugin/XtraDB, but not to regular InnoDB ( i.e in MySQL 5.0) In short, if you use… SQL statements, I strongly recommend to upgrade to MySQL version 5.1.51+ . Now another interesting point – how can you be sure that 5.1.51 works. The bug…
Post: Percona Server security fix releases
May 23, 2010 By 4 Comments
… MySQL ® announced 5.0.91 and 5.1.47 with serious security fixes, so we provide binary releases of Percona Server 5.0 and Percona Server / XtraDB 5.1… still are many active MySQL 4.0 and MySQL 4.1 installations and we understand how hard it is upgrade 4.0/4.1 to 5.1. With published exploits these…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
… MySQL 3.23 and MySQL 4.0…MySQL version is getting more and more complicated. MySQL architecture has to be additionally complicated to… will only upgrade on the…MySQL. Why is not this part of stock MySQL 5.1 ? I guess because MySQL 5.1 release was closed for any significant changes for years. Now how…
