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?
you can probably set that in your mysqld config file, unless piwik explicitly sets myisam, which i doubt:
[mysqld]
default-storage-engine=innodb