… the server from restarting following an upgrade — instead, the server would remain stopped after the upgrade was completed regardless of its state… with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin… #710799. This regression only affected clean RPM installations and not upgrades. We have pushed the fixed packages to the repositories. Bug…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… download from our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This release… script. Bugs fixed #1000761 and #1132934 (Raghavendra D Prabhu). When upgrading the Percona-XtraDB-Cluster-server package, /usr/bin/clustercheck script…
Post: When to use Hardware upgrade instead of Software Optimization
December 5, 2008 By 5 Comments
… well enough ? Do not advice hardware upgrade as the first thing when you can triple performance by simple my.cnf change. Well… query faster. You add memory to avoid disk IO and make lookups faster. The goal in the application performance – making throughput better… 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
August 7, 2008 By 6 Comments
… say 30GB with uniform data access raising memory from 16GB to 32GB can improve performance order of magnitude by converting very IO… subsystem performance. By far the best method is trying, if you can afford it – just get memory upgrade and see how it affects performance. With many vendors you can get the memory upgrade or the whole system…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… MySQL versions. Moreover utf8 character set continues to cause significant performance overhead so you should only use it in case you… test upgrade? This may or may not be good idea. In small environments when we often care more about functionality than performance… at the same time so other has full resources (including memory) available. Another thing to mention having multiple instances of different…
Post: When is it a time to upgrade memory ?
September 16, 2008 By 11 Comments
… Pool is already 90% full, should I be thinking about upgrading memory already?” This is a wrong way to put the question…=O_DIRECT) and see how performance depends on buffer size so you get and understanding what Memory-To-Disk ratio is optimal for your application, or at which point performance drops dramatically. It is…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… performance, future performance, scalability, ability to recover from disasters? We also want to know what the operating parameters are. Can we suggest upgrades… information on the box’s hardware, including RAID controllers, installed memory, and so on in the boot output. In addition, at…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…couple few questions on how to tackle application performance. These questions are: Should we Optimize Application … server which would usually have 1-2GB of memory may be couple of SATA hard drives – …until you think about resources and risks – hardware upgrade is straightforward and can be done by …
Post: 128GB or RAM finally got cheap
August 4, 2008 By 14 Comments
… 32 memory slots, which allows to get 128GB of memory with 4GB of memory chips. This means upgrade to default configuration to 128GB of memory… are designed to have “working set to fit in memory” to perform well and such systems can avoid good consolidation factor for… CPU sockets which means 16 fast cores and 128GB of memory becomes commodity – Quite a challenge for MySQL to take 
I…
