…multiple MySQL Query Cache instances hashed by query hash. It would help to reduce complexity dramatically. Fast Invalidation Right now when you update…in MySQL have very large number of queries doing updates through primary key and use primary key for selects. I believe in…
Post: How adding another table to JOIN can improve performance ?
August 1, 2008 By 12 Comments
…to yet another table though why it does not work for multiple group remains question to check with MySQL Optimizer team 
UPDATE…to learn about MySQL Optimizer gotchas At the same time I figured out how to make MySQL Optimizer to do what we want to…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
…To check completely in-cache scenario I created a table with just 10000 rows and wrote little stored procedure to make timing easier: mysql> DELIMITER // mysql…to keep it simple) (In reality I did multiple runs to get accurate results, but I show only one here) mysql…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
…fast…to get to old execution plans. In many cases though you can get to former execution plan either by updating…to mention having multiple instances of different MySQL…MySQL. Our focus on compatibility is indeed so high there are number of great features which are disabled by default to make…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…in different threads – using multiple cores becomes increasingly important as their number per CPU just keeps doubling. It is also rather interesting how…in INSERT IGNORE and ON DUPLICATE KEY UPDATE cases. Now In MySQL 5.1+ it is also possible to…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…In order to make working with the Flexviews easier, it includes a script called ‘convert.php’. This script makes it easy to…how Flexviews can help you ensure fast response times in your application by making access to…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…MySQL Database most people compress them – which can make a good sense in… for multiple backups, plus there are higher network bandwidth requirements to transfer … and relatively fast. In many cases however it is not fast enough and…naturally added. UPDATE: It looks like people are wondering how BZIP2 …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…to distribute splitting and/or loading among multiple nodes as well. Note that in…to 2010′; mysql> use ontime1; Database changed mysql…to raw input data), which is quite nice. Each shard contains only 128MB of data! Storage engine makes a big difference In…fast…update…
Post: MySQL: Followup on UNION for query optimization, Query profiling
August 14, 2006 By 14 Comments
…to see how counters have changed. It was quite inconvenient you could only do it on idle box so as in MySQL…multiple ages to deal with ether as BETWEEN range or as IN filesort appears and query becomes very slow: mysql…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…how to create indexes. Foreign key references may add processing time to inserts, updates…in MySQL you might be > better of using several queries than doing complicated ones. Of > course you would rather use IN…
