…using the vanilla MySQL server, you would see an entry like this in the slow… are actually invocations of 167 different queries. Following that there are …: # Full scan 100% yes, 0% no # String: # Databases wp_blog_one (264/84%), …Those are the two important things that you would probably like to fix …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
…more “database options” beyond just those two. Again my goal is to… for storing data. A tool like Tokyo Tyrant may not be for…stored a comma delimited string to represent the row.  Mysql was running with …showing the performance of a couple of different Tokyo database formats would also be …
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
…MySQL parsing may be performance bottleneck, assuming PHP opcode cache is not used. Also different applications may have different… of error control or other precausions like string escaping which you will need in …file cache is – there are actually two very different cases – when cached data set fits…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…only which can store one of two values – NULL or Empty String. Lets see how these 3 different table format look in …char(0) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 mysql> show table status like “%bool%” \G *************************** 1. row *************************** Name: bbool Engine: …
