…to see limited gains – if your working set already fits in 16GB you may not see any significant gains upgrading memory to… If you would like to be more scientific there are couple of other things you can do. First … 10 years and load data for 5 years only to compare performance you may get misleading …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… were bunch of micro optimizations in Innodb in 5.0 series. Also note the “Auto Increment Issue”… way to split memory between INNODB buffers and OS?†Of course this depends on all kinds of things,… amount of system memory. We just deployed a new Linux/Mysql server for a client, upgrading their main …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…to recover from disasters? We also want to know what the operating parameters are. Can we suggest upgrades…if you want to allocate a lot of memory to mysqld. Next…to use in some cases): vmstat 5 5 iostat -dx 5 5 If you don’t know how to… things to have us fix, which to fix themselves, and which to just…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… design. Another thing to consider – even if you have unlimited money to spend there are… unlikely will be able to solve the problem by CPU upgrade. For single thread…which would usually have 1-2GB of memory may be couple of SATA hard drives… would cost $5-10K or some $500 a month if you want to lease …
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… are some important things which we have to consider on case by… if data size is close to memory size), generally slower writes, slower blob… upon upgrading to Innodb. Features The MyISAM features which forbid moving to Innodb… not switch table to MyISAM because it gives 5% performance improvement but…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…to shard moves further and further away. I remember LiveJournal with 4GB of memory per box doing sharding 5…to maintain (upgrades etc) and troubleshoot. Remember for every single “role” in such setup you need to understand what to…have to look at failures caused by other things – wrong code pushed to …
Comment: Watch out for Marketing benchmarks
August 24, 2006 By 7 Comments
… Speaking about MySQL 4 -> 5 upgrade there are variants. 1) If you application was not… things – it is close to one but more subtle. Also you could get improvement using Innodb tables due to…to memory size – in this case saving 10-20% space is very important. 3) The way to benefit from MySQL 5.0 is to…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
… and the server has two Intel SSDs, 64GB of memory, and 4 x 12-core AMD Opteron 6172 … this benchmark. Maybe they wrote the paper before 5.5 went GA. The following are plots of the …thing I want to point out here is the dramatic improvement over just a few years ago, when you could “upgrade” from 4 to…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
… with rolling restarts, even software upgrades. The exceptions I see is (…to be in memory but… that about the same with InnoDB, at least the active dataset needs to… way to reduce cross-node interactions. How do you manage things like …use PostGIS, I completely agree. 2.5 I have done many NDB …
Post: Group commit and real fsync
May 3, 2006 By 9 Comments
…cases of customers upgrading to MySQL 5.0 and having serious performance slow downs, up to 10 times…() call the data is only written to the drives memory and so can be lost …thing RAID with battery backed up cache are becoming really inexpensive. You also probably want to know if this bug is going to…
