…for a given session, so that SELECTs will block until all previously queued … the slaves. Each slave downloads the full binlog containing all changes, but …”unsafe” slaves going to be a high performance cost? A: Connecting to …classes in North America and Europe. Join Percona and the MySQL community in…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… id 728899 localhost root Sending data select sql_calc_found_rows * from b… in InnoDB queue” or “sleeping before joining InnoDB queue”. Latest one is quite …calling fsync() for modified files. Constant high values for any of these … should be 16K – page size, for full table scan or index scan …
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
…format in MySQL 4.1 or changing JOIN evaluation in 5.0 (which could …to run comparison. The tool will run SELECT queries on both new and old … when issues would only happen at high load. You can do this in …a bit differently – upgrading one shard with full validation and when doing reckless upgrades …
Comment: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… expensive queries are against tables with a high degree of volatility so I rarely get… faster to actually parse/execute say, a select by primary key, than it is to…cache. Logic in the case of a join would be to only use the cache… of those features where I’ve gone full circle kind of like Peter has. I…
Comment: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… expensive queries are against tables with a high degree of volatility so I rarely get… faster to actually parse/execute say, a select by primary key, than it is to…cache. Logic in the case of a join would be to only use the cache… of those features where I’ve gone full circle kind of like Peter has. I…
