…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: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 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 73 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: 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 19 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…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…(plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation …application programming to do efficiently in distributed manner. Of course there are summary tables and other tricks we use…saying about Prepared Statements in MySQL 4.1 which came without query cache support but even…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 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: mk-query-digest, query comments and the query cache
…at this past MySQL Conference and Expo. In this talk I presented my Instrumentation-for-PHP class as a demonstration instrumentation application for …the query cache, but would like better instrumentation in your queries, consider using Percona Server and turning on the –strip-query-cache-comments …