June 18, 2013

Comment: SimCity outages, traffic control and Thread Pool for MySQL

…x clusters with not just simple queries or simple transactions but high …sanity and stability than life back in the days of MySQL 5.0…MySQL clustering performance: http://themattreid.com/wordpress/2013/03/01/building-a-…rapidly scalable NDB clusters (commence with inserting a shameless plug that users …

Post: MySQL Query Cache

queries is small so cache duplication is not the problem. Finally I do not want to hack wordpressquery cache overhead is of course inserts so you can see how much of inserted queries are used: Qcache_hits/Qcache_inserts

Comment: When should you store serialized objects in the database?

WordPress has been using this technique for many years now. Though I’m not 100% in agreement with the way WordPress…going to need to be searched using SQL queries, then you may want to consider the …settings is a TEXT. One other important note, inserts/updates with TEXT/BLOGs are slower, so only…