for backup purposes (using xtrabackup for online backups of the tables) I’d like to convert the piwik tables to innodb too. Each myisam table (especially in this size ;-)) makes the backup aching slow and taking longer.
But as Piwik is using the MyISAM format by default I’m wondering if anyone has any experiences doing that move?
Are there any special things in Piwik requiring MyISAM tables or will it work without troubles?
We haven’t tested Piwik with innodb but it should work fine. You can always try to convert them, see how it is behaving, and report here. It will always be possible to convert them back to myisam