May 26, 2012

Post: Percona Server 5.5.21-25.1 released!

… that we wish to make available. Bugs Fixed: Fixed a memory corruption regression introduced in 5.5.18-23.0. Bug…). Fixed MySQL upstream bug #64160 that was causing issues on upgrade to 5.5.20 and 5.5.21. Bug fixed…

Post: When is it a time to upgrade memory ?

… Pool is already 90% full, should I be thinking about upgrading memory already?” This is a wrong way to put the question… depends on buffer size so you get and understanding what Memory-To-Disk ratio is optimal for your application, or at…_size you can use it as guidance to add more memory or more servers. Of course this is all oversimplifications – you…

Post: When to use Hardware upgrade instead of Software Optimization

… crappy hardware it would be much cheaper for them to upgrade before purchasing much of professional services. Though in some cases… MySQL, Queries, Architecture optimized well enough ? Do not advice hardware upgrade as the first thing when you can triple performance by… use to understand what needs to be done (gettings SSD, upgrading memory, upgrading CPUs). There are number of balancing questions you have to…

Post: Predicting Performance improvements from memory increase

… fits in 16GB you may not see any significant gains upgrading memory to 32GB. Interesting enough similar can happen for very large… typically do not expect to gain much by increasing the memory. This however have to be watched carefully. Performance does not… it – just get memory upgrade and see how it affects performance. With many vendors you can get the memory upgrade or the whole system…

Comment: Predicting Performance improvements from memory increase

memory. http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-disk-data.html The important factor to consider when upgrading memory on an NDB Cluster is that the data nodes all need to run with the same memory specification, therefore any memory upgrade

Comment: When is it a time to upgrade memory ?

… – even though the memory is cheap many hosting providers would not only charge you effectively cost of memory to upgrade but also will put heavy monthly fees for hosting services with large memory amounts. This needs to be factored in in the cost. 3) Upgrade and testing is time…

Post: Different flavors of InnoDB flushing

… lists for flushing (writing pages from the Innodb buffer pool memory to disk): the LRU list and the flush list. YouÂ… strategy which will give the biggest benefit is: Install more memory or upgrade the I/O subsystem. If you are flush list…, and innodb_log_file_size are important for tuning. Also, upgrading to Percona Server, with a more advanced flushing algorithm, may…

Post: When would you use SAN with MySQL ?

… more reliable, same as server with multiple power supplies ECC memory kill-chip and RAID is more reliable than without these… solves the other big pain of semi-online MySQL/OS upgrades and Schema changes. Backups SAN has number of advantages for… should also evaluate external directly attached storage, SSDs, Increasing system memory as well as sharding and replication as a scaling solutions.

Post: Three key things to know about moving MySQL into the cloud.

… do this. There’s no customization of the memory. The maximum amount of memory you can have is 15GB, so some users… store, it costs $2094 to upgrade an R900 from 4G memory to 64G (or $4378 to upgrade to 128G) which justifies that some problems are best solved by just throwing memory at…

Post: Economics of Performance Optimization

… tuned applications when further tunings are expensive you may well upgrade hardware instead but as you grow further you’ve got… virtual) rented server which would usually have 1-2GB of memory may be couple of SATA hard drives – something one would… economic standpoint until you think about resources and risks – hardware upgrade is straightforward and can be done by operations and data…