… suggest hardware upgrade and when it is not in a simple checklist form. How good is hardware ? Sometimes people use so crappy hardware it… choice than hardware upgrade and it also can be done easily. Is MySQL, Queries, Architecture optimized well enough ? Do not advice hardware upgrade as…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… getting more powerful MySQL Server hardware the cost is going to be increasing dramatically after certain hardware size. For example right now… tuned applications when further tunings are expensive you may well upgrade hardware instead but as you grow further you’ve got to… from economic standpoint until you think about resources and risks – hardware upgrade is straightforward and can be done by operations and data…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 1 Comment
…-upgrade can help you identify what to expect and test your upgrades better which is one important step when upgrading your servers. pt-upgrade… if you are upgrading your hardware alongside your MySQL version, you should also consider running these tests on similar hardware and OS configuration…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… ? First if you followed MySQL upgrade best practices such as testing your workload with pt-upgrade the chances of this happening are… at the same time, operating system is upgraded or system is moved to “better” hardware. It is best if you can isolate… these – make sure changing only MySQL version on the same hardware with same settings causes regression. You can always improve them…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… MySQL version upgrade involves new Operating System and hardware and any of them could be potential cause of rollback. MySQL Upgrade in my… experience. Also problems you encounter during 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…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… week I already had two serious performance regression cases when upgrading from MySQL 4.0 and 4.1 to MySQL 5… not it mentioned in MySQL 4.1 to 5.0 upgrade notes ? ? Furthermore if there were no good ideas how to… recovery, but at the same time you should not have hardware RAID or have one without battery backed up cache (BBU…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… way. Let’s say you have a server with standard hardware RAID setup running conventional HDDs. RAID setup For the sake… separated from the OS in case you ever want to upgrade the OS, but otherwise keep it simple. My suggestion? Plan… excellent blogs on both the theory of Aligning IO on hardware RAID and some good benchmarks to emphasize the point, go…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… – install, configure, tune, start/stop MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for… RedHat or SuSE. Another such case can be related to hardware. Any newly released component may simply lack support from the… be the case for any high-end/enterprise class equipment. Hardware vendors may release Linux drivers on their own, but often…
Page: Presentations
May 3, 2006 By
… design recommendations as well as Innodb MySQL Server Settings and Hardware selection aspects. Download Effective Full Text Search for Databases Russian… self explanatory. Very good reading if you’re planing hardware purchase or OS upgrade. Too bad such results outdate pretty quickly. Download…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… to know what the operating parameters are. Can we suggest upgrades, rewriting queries, or whatnot? Sometimes there are rigid constraints on… keep working to get a picture of the OS and hardware. [percona@db1 ~]$ tail -n 25 /proc/cpuinfo power management: processor… to investigate further, I have a pretty good idea what hardware and operating system I’m working with. System performance Next…
