distal-attribute
distal-attribute
distal-attribute
distal-attribute

Engines in create table form

Tadas posted 8 months ago in General

Engines in create table form

I'm using MariaDB. It has storage engine XtraDB. Pity that it is not listed. Also would be greate to skip this option, because MariaDB could has default storage engine, now it's impossible to leave this field empty.

Thanks.

ansgar posted 8 months ago

Probably I can add a "Default" option in the engine drop down, which then leaves the ENGINE=xyz clause just away from the CREATE TABLE code.

ansgar posted 8 months ago

r5153 adds such a "Server default" drop down item, which then leaves the ENGINE clause away. This is also the new default when creating a new table.

Tadas posted 8 months ago

Thanks.

Would it be possible to append "XtraDB" to engines list?

ansgar posted 8 months ago

If XtraDB would show up in the result of

SHOW ENGINES;

... then it should already be displayed. But if I understand the documentation right, XtraDB is a drop-in-replacement for the InnoDB engine, and it replaces InnoDB, instead of offering a new engine. With the SHOW ENGINES query, you have to watch out in the Comment field of the InnoDB row, to see whether it's InnoDB or XtraDB. Here's my result on a MariaDB 10.0.25 server, copied to clipboard with HeidiSQL's grid export dialog, in Markdown format:

ENGINES

Engine Support Comment Transactions XA Savepoints
CSV YES CSV storage engine NO NO NO
InnoDB DEFAULT Percona-XtraDB, Supports transactions, row-level locking, and foreign keys YES YES YES
MEMORY YES Hash based, stored in memory, useful for temporary tables NO NO NO
MyISAM YES MyISAM storage engine NO NO NO
MRG_MyISAM YES Collection of identical MyISAM tables NO NO NO
PERFORMANCE_SCHEMA YES Performance Schema NO NO NO
Aria YES Crash-safe tables with MyISAM heritage NO NO NO
Tadas posted 8 months ago

OK. Thank you.

Please login to leave a reply, or register at first.