… 29 – November 2, 2012. See http://store.percona.com/catalog.php?category=17 for details on this training…relevant to current versions of MySQL. Q: How do the upcoming changes in MySQL 5.6 change … EXPLAIN report. Hopefully, the size of this interim result set is relatively small, after the GROUP BY…
Comment: Blob Storage in Innodb
February 16, 2010 By 13 Comments
… and some stored externally. This is not clearly documented neither can be hinted or seen.” Last year as a result of docs Bug#29042 (http://bugs.mysql.com/bug.php?id=29042) we did identify that… the overflow list where the rest of the value is stored.” That doesn’t address newer storage formats provided by InnoDB…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… that cause data corruption, crashes, or wrong query results get the highest priority. We are slowly working…only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle… Q30: Question about using solid state disks for storing ib_log* files; I know that innodb …
Comment: Cache Performance Comparison
August 10, 2006 By 74 Comments
… what I like with my current implementation, just perl and mysql is needed – no additional mumbojumbo elsewhere 
But just exchanging… get back with results. Regarding ‘%abc%’ optimization I tried to create a permuted table (for example word “abcd” is stored as “abcd… boost I was hoping for. More info at http://forums.mysql.com/read.php?24,107503,107522#msg-107522
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
…box (2Ghz AMD Sempron CPU) using MySQL 4.1 and PHP 5.0. For memcached access memcache extension… and results will be wrong. So what is about results and how we can use them for MySQL Performance tuning…caches and so you might be better off storing your data on network with memcached. Memcache performs…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…PHP applications abstraction layer is > not the main performance problem, also benefit from persistent > connections can be much more modest. DVD Store… to use query and external caching of result sets is generally a good … background. > Things are different with MySQL. Good design will help dictate …
Post: Caching techinques
August 8, 2006 By 11 Comments
… ofload sending cache result to the client by web server (instead of doing it from PHP). The other… once underlying information is updated. This is how MySQL Query Cache works by removing all queries derived… site which has many blogs published. You may store blog version which is updated on each blog…
Page: Presentations
May 3, 2006 By
…stored in database focusing on delivering high performance for large databases. We look at performance properties of MySQL…results outdate pretty quickly. Download MySQL Performance 5.0 vs 4.1 MySQL…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… effort may well still bring its results but you may waste a lot …thing is number of times which are stored for request. wall clock time – is… spend a lot of time optimizing PHP code but because it takes only … mutliple components (like sphinx and MySQL) or multiple MySQL Servers because in these cases…
Comment: MySQL wins C'T Database Contest
September 12, 2006 By 27 Comments
… the MySQL results in the PR as 3,663opm was different from the result(1967opm) in Dell’s publication for the DVD online store test on the Dell PowerEdge2800 at: http://www.dell.com/downloads/global/solutions/mysql_network_2800.pdf? Is there any HWs configuration, or MySQL/PHP/driver source(is it different…
