May 25, 2012

Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine

Much has been written about the new InnoDB pluggable storage engine, which Innobase released at the MySQL conference last month. We’…

Post: Power of MySQL Storage Engines

… 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… innovation at this point is the fact MySQL has only Storage Engine pluggable but SQL layer is kind of fixed same for all…

Post: Paul McCullagh answers your questions about PBXT

… evaluate a storage engine my key acceptance criteria are things like backup, concurrency, ACID compliance and crash recovery. As a storage engine developer, what… engine is easy. So I would say that these are the criteria that 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 all…

Post: MySQL Error Message Nonsenses

… too InnoDB: many active transactions running concurrently? I hope with pluggable storage engine interface Sun/MySQL spends some time to make things consistent… be portable across storage engines – for example something with meaning of “Storage engine is out of resources” together with ability for storage engine to pass as…

Post: Monty unviels Maria and starts Blogging

… (when he will call it stable) and as soon as Pluggable Storage Engine API works well it should not require any official support… is only first version – further version to include full transactional storage engine with MVCC and row level locks functionally close to Innodb… (so there is backup) or turn not to be transactional storage engine of choice for future MySQL. Again, Congratulations Monty, these are…

Comment: MySQL Quality of old and new features

… the issue of storage engine testing I think this is one of those issues that really makes it clear that pluggable storage engines are not the silver bullet. Of course all the storage engines use common infrastructure, but to…

Comment: The Doom of Multiple Storage Engines

… this is exactly the reasoning why PostgreSQL only has one storage engine to rule them all. It seems like the Drizzle project… types of performance issues, but they are keeping support for pluggable storage engines (MyISAM notably absent) and even extending it. I wonder what… around some of them (perhaps by rigidly defining how a storage engine must behave/store data to avoid the copying issues?). If…

Comment: The Doom of Multiple Storage Engines

… MySQL would not offer pluggable storage engines. Even Innodb itself could only be brought to users because MySQL had a storage engine interface Innodb could…

Comment: Sphinx: Going Beyond full text search

…, What do you think about using this? SphinxSE as a pluggable storage engine for mysql? Currently we have a forum with about 17million…

Comment: The Doom of Multiple Storage Engines

… proper – not in any particular storage engine. Essentially this means that if you want to develop a storage engine yourself that needs specific table… optimizer? Shouldn’t the optimizer be extensible and pluggable too? Column-oriented storage engine vendors like infobright and calpont all had to put…