…in painful warmup time and/or costly cache stampedes. Cache stampedes can be mitigated through application…php, 1 box with memcache or mysql started PHP script Zend framework libmemcached PECL module Zend_Cache…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…in MySQL you might be better of using several queries than doing complicated ones. Of course you would rather use IN…PHP applications use test database with reasonable amount of data in it. And do run EXPLAIN for your queries, especially if you see them in…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…: http://bugs.mysql.com/bug.php?id=67647 Metadata locking behaves differently for queries that are serviced from the Query Cache, let’s… the application was using MySQL version < 5.5 as the datastore. There was another interesting case this time with how Active MQ uses MySQL when in…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…In my first post in this series, I described materialized views (MVs). An MV is essentially a cached result set at one point in…In cases where this is not useful, simply ignore this column. It is used to prevent wide innodb primary keys on the MV. mysql…in your application…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… of queries to MySQL parsing may be performance bottleneck, assuming PHP opcode cache is not used. Also different applications may have different cache hit ratios which… wish to use APC Cache as L1 cache and File cache as L2 cache if you have large amount of data in long term cache. If you…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… presentation on “Read/Write Splitting with PHP” for Percona Webinars. If you missed it… Another solution that could be used independently of application language would be MySQL Proxy with a RW …in a persistent database. Q: Can you compare / contrast this approach with using a write-through cache?…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
… application growths larger and you need to have multiple servers you may decide ether to grow system in MySQL+Apache pairs or split MySQL And Web Server and place them on different boxes. Generally using separate boxes for MySQL and… (php,perl,python) per box (which is probably bad idea anyway). The good use for such extra memory is probably caching – Web page caching…
Post: Caching techinques
August 8, 2006 By 11 Comments
…PHP). The other case when caching in files can be very helpful is caching…cache efficiency for some applications. These are of course only some of the approaches which you can use, and in…
Post: MySQL Prepared Statements
August 2, 2006 By 21 Comments
…used in textual protocol, which not only consumed time but also required extra memory consumption both on server and client. So in MySQL…cache prepared statements in your application (avoid closing and recycle). Note in some cases it still can be better to use…
Page: Consulting for MySQL
July 31, 2006 By
…In many cases web application performance issues lie outside of MySQL. We’re ready to work with you on PHP code optimization, Server Side caching…
