…index then mysql most probably use index on “available” column only using ref access and after that filter by age. This is optimal…mysql can use index to filter records before fetching any rows. How much it will give? Not…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
…INDEXes — All about Indexing…to Rick’s talk might be: Advanced query optimizer…not sure when this was not the case at a MySQL conference. There are several MySQL HA related tutorials: Using Tungsten Replicator to…But if you’re stuck trying to choose an HA solution, then “Evaluating MySQL…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…Using index | +—-+————-+——-+——-+——————————————–+———+———+——————-+———+———-+———————————————-+ And the results in seconds of time taken to complete the above query: Here we can…
Comment: How to find wrong indexing with glance view
March 8, 2010 By 27 Comments
…Not only do these indexes slow down insert operations, the MySQL optimizer sometimes appears to become rather overwhelmed by the number of indexes and tables to choose…
Post: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 5, 2009 By 26 Comments
…choosing these engines. After initial three posts I am often asked “What is baseline ? Can we compare results with standard MySQL…indexes: – load of data is getting slower; – to design proper indexes is additional research, especially when MySQL optimizer is not…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…can‘t help but wonder if some tweaks could be made to the page flushing algorithm to be more effective there in choosing…to the disk. I’m not sure why this is still useful if you can use Linux native AIO. These can…
Comment: When should you store serialized objects in the database?
January 22, 2010 By 47 Comments
…to fit in is where blobs are located off-page, but can not…to columns. The problem with when you choose to convert, is that you can…to see you’re in one of the “when is it a good idea” cases. @Angelo – That indexing…to run anywhere. There’s lots of optimizations… used to (mysql cli, etc). I then have to…
