… following an upgrade — instead, the server would remain stopped after the upgrade was completed …library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this … the upstream bug #68845 which could unnecessarily increase contention on log_sys->mutex in write…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this …Fixed the upstream bug #68845 which could unnecessarily increase contention on log_sys->mutex in write… only affected clean RPM installations and not upgrades. We have pushed the fixed packages to…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
… I guess is how much should I see performance improved in case I increase memory say from 16GB to 32GB. The benefit indeed… fits in 16GB you may not see any significant gains upgrading memory to 32GB. Interesting enough similar can happen for very large… 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: When is it a time to upgrade memory ?
September 16, 2008 By 11 Comments
…already 90% full, should I be thinking about upgrading memory already?” This is a wrong way to put…or may be just because amount of queries increased dramatically or may be because queries changed their… and see how performance depends on buffer size so you get and understanding what Memory-To-Disk …
Post: When to use Hardware upgrade instead of Software Optimization
December 5, 2008 By 5 Comments
… boost later down the road when you need a major performance increase and do not have a time for big application changes… well enough ? Do not advice hardware upgrade as the first thing when you can triple performance by simple my.cnf change. Well… use to understand what needs to be done (gettings SSD, upgrading memory, upgrading CPUs). There are number of balancing questions you have to…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…questions on how to tackle application performance. These questions are: Should we …the cost is going to be increasing dramatically after certain hardware size. …would usually have 1-2GB of memory may be couple of SATA hard … about resources and risks – hardware upgrade is straightforward and can be …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… get the highest priority. We are slowly working on the performance enhancement requests. It takes time for the patches to mature… may need to increase size of your Innodb log files to be able to use a lot of memory for write buffering… rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql server for a client, upgrading their main…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… above) do not matter a lot, and performance is mostly defined by available memory and the I/O subsystem. Also, it seems… a performance standpoint. If you are LRU list bound, the strategy which will give the biggest benefit is: Install more memory or upgrade… flushing algorithm, may give a good performance gain. If you already use Percona Server, then increasing innodb_log_file_size may help…
Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
February 4, 2013 By 10 Comments
… you are not out of available memory, you can consult the manual …as part of a MySQL version upgrade, we might incorrectly (but justifiably) …further minutes or hours of unacceptable performance degradation while the buffer pool warms… a very handy way to immediately increase the resource limits for a …
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… analyze the local system performance independently from anything else. Performance This is perhaps the most… pain of semi-online MySQL/OS upgrades and Schema changes. Backups SAN has …evaluate external directly attached storage, SSDs, Increasing system memory as well as sharding and replication …
