开发者

MySQL: Will a column-oriented engine be available in MySQL 5.5?

Will a column-oriented storage engine (e.g. InfiniDB) be available in the开发者_Go百科 core release of MySQL 5.5?

Meaning, not as a plugin but available with the core MySQL 5.5 bundle.


You can't just plug a column-based engine into MySQL. The reason for this is that its optimiser only understands row-based engines which support conventional indexes.

So the column-based engines (Infobright, infinidb and Kickfire) all use their own modification to the mysql core which makes it use their optimiser instead of the standard one (in some cases for some queries only).

Whereas other row-based engines (Tokutek, PBXT etc) can simply operate as plugins.

The storage engine API does not really work properly (efficiently, at least) for column-engines.

Column-engines don't support conventional indexes, which means the optimiser cannot know how to optimise for them.

So ummm, no.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜