MariaDBstorageengines_MySQL

來(lái)源：懂視網(wǎng) 責(zé)編：小采時(shí)間：2020-11-09 19:16:02

MariaDBstorageengines_MySQL

MariaDBstorageengines_MySQL:MariaDB This is a list of MariaDB storage engines that are not distributed with MySQL. I think that most of them will work with MySQL, but not all – at least CassandraSE doesnt.EngineDescriptionIntroducedXtraDBA fully-compatible fork ofIn

推薦度：

點(diǎn)擊下載本文 文檔為doc格式

導(dǎo)讀MariaDBstorageengines_MySQL:MariaDB This is a list of MariaDB storage engines that are not distributed with MySQL. I think that most of them will work with MySQL, but not all – at least CassandraSE doesnt.EngineDescriptionIntroducedXtraDBA fully-compatible fork ofIn

MariaDB

This is a list of MariaDB storage engines that are not distributed with MySQL. I think that most of them will work with MySQL, but not all – at least CassandraSE doesn’t.

Engine	Description	Introduced
XtraDB	A fully-compatible fork ofInnoDB, mantained by Percona	Big Bang
Aria	A crash-sageMyISAM, also used for internal temptables	Big Bang
TokuDB	A transactional engine with innovative buffers and high compression, by TokuTek	10.0
mroonga	Supports fulltext searches with Chinese, Japanese and Korean languages	10.0
SPIDER	Shards tables through multiple servers	10.0
OQGRAPH	Used to implement tree structures	10.0
Sequence	Returns a sequence of numbers as a resultset	10.0
CONNECT	Support several external data sources (data files, DBMS’s…)	10.0
CassandraSE	A bridge to Apache Cassandra	10.0
SphinxSE	A bridge to Sphinx	5.2
FederatedX	A richer fork ofFederated	Big Bang

Notes:

XtraDB is the default and should be preferred to InnoDB, unless it has a bug which affects you (but XtraDB fixes several InnoDB bugs).

OQGRAPH was introduced during the Big Bang or soon after, but disabled in 5.5. Seethis post.

FederatedX is called Federated, so it’s possible that you are already using it and you don’t know.

CONNECT will hopefully obsoleteCSVand FederatedX, but some features are still missing. For example, CONNECT cannot store NULL values in flat files.

With MariaDB you need to specifySQL_MODE='NO_ENGINE_SUBSTITUTION'. If you mistype the engine name, or try to use a disabled engine, you want to get an error, rather than silently switch to XtraDB.

Obsolete storage engines:

PBXT(Big Bang – 5.3) – A transactional engine which aimed to be “somewhere between InnoDB and MyISAM”. Seemed to support foreign keys better than InnoDB (I couldn’t reproduce a tirgger+FK bug and it had more options), but alas it’s dead.

Enjoy!

聲明：本網(wǎng)頁(yè)內(nèi)容旨在傳播知識(shí)，若有侵權(quán)等問(wèn)題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

MariaDBstorageengines_MySQL

推薦度：

點(diǎn)擊下載本文 文檔為doc格式

標(biāo)簽： mysql storage engine

熱門焦點(diǎn)

MariaDBstorageengines_MySQL

MariaDBstorageengines_MySQL

MariaDBstorageengines_MySQL

最新推薦

猜你喜歡

熱門推薦