Much has been written about the new InnoDB pluggable storage engine, which Innobase released at the MySQL conference last month. We’ve written posts… show some status information about InnoDB. Here are the tables: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE ‘INNODB%’; +—————————————-+ | Tables_in_INFORMATION… fully documented in the InnoDB plugin manual, along with extensive examples of how to use them to find out what is…
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
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…
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
…many active transactions running concurrently? I hope with pluggable storage engine interface Sun/MySQL spends some time to make things consistent…. portable across storage engines – for example something with meaning of “Storage engine is out of resources” together with ability for storage engine to…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… concern a developer the most. MySQL supports a “pluggable storage engine API”, but it seems that not all the storage engine vendors are able to keep… create a .frm file. One extreme example of this is PBXT recovery. When MySQL calls the engine “init” method on startup it is…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…my list 1. Be Pluggable Unlike many OpenSource projects MySQL was single chunk…storage engines as plugins. Two aspects why I’m especially interested about it is Sphinx which is currently implemented as storage engine for MySQL… example Query Cache support for Prepared Statements is only fixed in MySQL…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…how to get it. Most distributed engines work with rows. They break the… partition elimination. The mapper is pluggable. On each storage node (or a mapped subset …speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s law…algebra rewrites So, here is an example of such a plan for a…
