Engines in create table form

Tadas's profile image Tadas posted 7 years ago in General Permalink

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's profile image ansgar posted 7 years ago Permalink

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.

Code modification/commit b480606 from ansgarbecker, 7 years ago, revision 5153
Add "<server default>" to the engine drop down on the table editor, and make that the new default, so we leave the ENGINE=.. clause away. See https://www.heidisql.com/forum.php?t=23363
ansgar's profile image ansgar posted 7 years ago Permalink

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's profile image Tadas posted 7 years ago Permalink

Thanks.

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

ansgar's profile image ansgar posted 7 years ago Permalink

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's profile image Tadas posted 7 years ago Permalink

OK. Thank you.

naoma123's profile image naoma123 posted 5 years ago Permalink

Hi, I'm using HeidiSQL for PostgreSQL 11 on Windows 10 and am having trouble with the engines. The engine is currently set to &lt;Server defualt&gt; (not sure what that is?) and there are no other options for it. My main problem is that currently foreign keys are not allowed with this server. When I click on the foreign key tab of my table it says "The selected table engine (&lt;server default&gt;) does not support foreign keys.

Is there a way to change this?

Running the query

SHOW ENGINES;

gives the error:

ERROR: unrecognized configuration parameter "engines"

Thanks very much.

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