… have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take… on which range condition is applied cannot be used for filtering records. For example, suppose you have a key defined as: KEY…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
…MySQL Storage Engines, and pluggable storage engines as MySQL 5.1 lays ? It is very much advertised this allows third parties to create their own storage engines…search engine . As MySQL 5.1 and plugable storage engine interface matures I hope we’ll see more storage engines…
Post: Full text search for all MySQL Storage Engines
June 26, 2006 By 37 Comments
… limits. Today Sphinx Search plugin for MySQL was released which now provides fast and easy to use full text search solution for all storage engines. This version… list for complete picture. And if you do not feel like patching MySQL or use MySQL 5.1 beta to use sphinx as MySQL Storage Engine…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… – unlike MySQL Storage Engines, some of which as InfoBright or KickFire take over execution after parsing, Sphinx MySQL support has nothing to do with MySQL…;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer. For the tests I used the table from the forum search engine, leaving just…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… – now there are plugable storage engines (something even PostgreSQL does not have) as well as Full Text Search parses but there is very… of storage engines as plugins. Two aspects why I’m especially interested about it is Sphinx which is currently implemented as storage engine for MySQL but…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… to see Innodb as the main storage engine because it makes life much simpler in the end for most users – you do not… typically Full Text Search and RTREE indexes/GIS with Full Text being much more common. There are workarounds for both of them… so common paths in the MySQL server – in particular Optimizer may have harder time because costs between storage engines may not be well…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… Text Search indexes which are not supported for Innodb tables. So what can you do ? Leave Tables as MyISAM The beauty of MySQL storage engines is you do not have to convert all tables at once. In some cases full text search is used… have stale data in search results it can work pretty well. Use Sphinx or other external full text search engine This is what…
Page: Consulting for MySQL
July 31, 2006 By
…Storage engine development assistance If you’re developing MySQL Storage Engine, Appliance or Extensions we’re happy to work with you offering our expertise in MySQL…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially …engine_logsblogpercona.commanual Com_show_engine_mutexblogpercona.commanual Com_show_engine…_locks_unsafe_for_binlogblogpercona.commanual ….commanual optimizer_search_depthblogpercona.commanual … standaloneblogpercona.commanual storage_engineblogpercona.commanual …
Comment: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… MIME-typed blobs. I’ve written a MySQL storage engine for it, available at http://fallenpegasus.com/code/mysql-awss3/ One of the things in…, S3 has some interesting key search sematics, and there are some very interesting large database key search REST APIs from utility computing…
