Defaulting newly created tables to innodb?


(Thomas Seifert) #1

I’m using InnoDB for the large tables (mainly for online-backup and scalability causes) and currently manually convert the new archive tables once they are created.
Is there a way, maybe some hidden setting ;-), to default new tables to innodb to avoid that manual part?


#2

you can probably set that in your mysqld config file, unless piwik explicitly sets myisam, which i doubt:


[mysqld]
default-storage-engine=innodb