Set Default "new Table" Type

[Dominik Deobald]

I don't think there's an option for that right now: I'd really love to see an option to change the default “Table Type” when creating a new table.

So far – if I (as usually) forget to change the table type manually – all tables get created as InnoDB, which usually is so much slower than MyISAM in my “many reads, few writes” web-applications.

[peterlaursen]

It gets created as InnoDB in your case because this is the default setting for this particular server. Can't you change the server default??

A setting in SQLyog 'preferences' ahs the problem that you cannot always tell what table types ('engines') is available for a server (it is not a big problem at the moment, but it will increasing be with Maria, PBXT, ExtraDB and Falcon etc. engines spreading in both offcal an unoffical mySQL builds). So ideally it should then be a 'per server' setting, I think.

[Author]

Posts