… 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: 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 …
Post: MySQL caching methods and tips
April 4, 2011 By 4 Comments
…memory pressure may cause unexpected invalidation of items, once again resulting in unpredictable, and therefore undesirable performance. If the cache is emptied (perhaps due to a restart, crash, upgrade… to be rebuilt with some increasing probability as the request time …
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
…server increases. Vadim runs lots of benchmarks that measure what happens under increasing concurrency…data for this. The modeling I performed is Universal Scalability Law modeling, which… has two Intel SSDs, 64GB of memory, and 4 x 12-core …few years ago, when you could “upgrade” from 4 to 8 cores and…
