…memory, you can consult the manual for a possible OS-dependent bug. The canonical solution to this issue, if you do…do an upgrade. Odds are that we’re not going to reboot the whole machine to do this upgrade…/proc/`pidof mysqld`/limits So what have we learned … will likely be the new way of doing …
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…changes into a log, it will be faster to do on the fly as transactions come…numbers are relevant from the BUFFER POOL AND MEMORY section of SHOW ENGINE INNODB STATUS: Database … are not flushed. This, in essence, is what fuzzy checkpointing is. The checkpoint process … reasons to consider an upgrade…
Post: Three key things to know about moving MySQL into the cloud.
July 13, 2009 By 11 Comments
The question “what problems will I have when migrating to the cloud” gets asked often … store, it costs $2094 to upgrade an R900 from 4G memory to 64G (or $4378 to upgrade to 128G) which justifies that some problems are best solved by just throwing memory at them. With EC2, you can’t do…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…I remember LiveJournal with 4GB of memory per box doing sharding 5 years ago…. well …cases even with super optimistic assumptions application will do just fine with single “cluster” even …upgrades etc) and troubleshoot. Remember for every single “role” in such setup you need to understand what to do…
Post: SELECT LOCK IN SHARE MODE and FOR UPDATE
August 6, 2006 By 51 Comments
… think how these modifiers can be user and what do we expect from them in practice. LOCK …will ensure you get write locks for all rows at once which reduces chance of deadlocks – lock will not need to be upgraded… tables but it will still need to set row level locks which is memory and CPU overhead…
Post: Why you don't want to shard.
August 6, 2009 By 34 Comments
… – The amount of memory you require to keep your frequently accessed data loaded exceeds what you can (economically)… to fix any of the problems mentioned above. What you do is pick a few very busy tables,… correctly when you are rolling through an upgrade where the schema will not be the same on all …
Post: Group commit and real fsync
May 3, 2006 By 9 Comments
…customers upgrading to MySQL 5.0 and having serious performance slow downs, up to 10 times in certain cases. What… call the data is only written to the drives memory and so can be lost if power goes down…. This will write and fsync the same page and you should see how many requests/sec it is doing. …
Post: Intel Nehalem vs AMD Opteron shootout in sysbench workload
April 25, 2011 By 41 Comments
…6. I will probably will need to rerun benchmark after upgrade Cisco to CentOS 6 ( will be … the moment. All data fits into memory, so it is full CPU bound benchmark… much slower then Intel Nehalem, I do not see it in results. Both … in next run I will try to get more information what is most used “wait…
Post: MySQL caching methods and tips
April 4, 2011 By 5 Comments
…is invalidated, response time will be significantly impacted. The…them into the cache. Additionally, memory pressure may cause unexpected …due to a restart, crash, upgrade or power loss) then… forces one query to do the computation while others …accessed very frequently. Use what you need Both Memcached…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… if data size is close to memory size), generally slower writes, slower blob …until it is worked around. Operations What is good for MyISAM kills Innodb…for MyISAM but will start taking way too much time to do restore for…running MyISAM but instantly break upon upgrading to Innodb. Features The MyISAM …
