… to recover from disasters? We also want to know what the operating parameters are. Can we suggest upgrades, rewriting…also elect to use in some cases): vmstat 5 5 iostat -dx 5 5 If you don’t know how to read these…/mysqld.log mysql 3172 3137 78 Nov19 ? 1-11:17:30 /usr/libexec/mysqld –defaults-…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… easy to fix, But why is not it mentioned in MySQL 4.1 to 5.0 upgrade notes ? ? Furthermore if there were no good ideas how to make XA to work with group commit… 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: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…d like to share my experience. The article does not cover MMM installation nor how to do this without…remember, standby master is running with read-only=1) and they must be executed on db2…5. on monitor: switch masters Once standby servers (only db2 in our case) have caught-up, we are ready to upgrade…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… sure the write traffic replicates properly to the new setup. It was the time to check how read traffic behaves. We stopped both… upgrade are very different depending on the upgrade version – upgrade from MySQL 4.1 to 5.0 had a lot of different issues than upgrade from MySQL 5.0 to 5.1 Also, Maatkit…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… 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 people approach the upgrade process…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… heard about loss of performance with 5.0.X. I’m hopeful that 5.1.X will be better, but still … that random writes to them are actually slower than to a mechanical disk. I do not know how it is for … for a client, upgrading their main database (from 16GB, 2 two-year old HT’ed XEONs to 32 GB, 4x …
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
…you cover the following: RAID type (usually 5 or 1+0) RAID stripe size BBU enabled … to ensure your MySQL datadir is separated from the OS in case you ever want to upgrade …to squeeze every last ounce of performance from the box. Fiddling with how to allocate drives and drive space from partition to…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…unlikely will be able to solve the problem by CPU upgrade. For single thread…) rented server which would usually have 1-2GB of memory may be couple…would cost $5-10K or some $500 a month if you want to lease …how to optimize it another 10-15% may be a great idea. On higher end I’d even look to speak to…
Comment: Heikki Tuuri to answer your in depth Innodb questions
October 2, 2007 By 51 Comments
Hi, With a 1.5 TB database on 4.1.14 consisting mostly of Innodb tables, I’m looking at upgrading to 5.1.X as soon… 4.1 to 5.0 and 5.0 to 5.1 but that sounds like several reformatting steps. With a large database, that means lots of downtime. How can I avoid as much reformatting as possible and still move to 5.1.X? Can you give me…
Comment: Percona Server 5.1.57-12.8 Stable Release
June 8, 2011 By 10 Comments
How safe would it be to upgrade from 5.1 to 5.5 using the apt repo?
