… 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: 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: 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: 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: 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…
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… for tuning. Also, upgrading to Percona Server, with a more advanced flushing algorithm, may give a good performance gain. If you already…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…always analyze the local system performance independently from anything else. Performance This is perhaps the most …big pain of semi-online MySQL/OS upgrades and Schema changes. Backups SAN has …external directly attached storage, SSDs, Increasing system memory as well as sharding and replication as a…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… are using MySQL because it seems to offer the neccessary performance. Are we just kidding ourselves, and should we switch to… get the highest priority. We are slowly working on the performance enhancement requests. It takes time for the patches to mature… increase the amount of system memory. We just deployed a new Linux/Mysql server for a client, upgrading their main database (from…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance….commanual shared_memory_base_nameblogpercona….
