I noticed today, that piwik archive tables engine types are mixed. We moved to a new server a couple of months ago, upgraded Mysql and many things more. I think, InnoDB is nowadays default format of mysql. Since then, the archive tables are created in InnoDB format:
…
piwik_archive_blob_2012_04 MyISAM
piwik_archive_blob_2012_05 MyISAM
piwik_archive_blob_2012_06 MyISAM
piwik_archive_blob_2012_07 InnoDB
piwik_archive_blob_2012_08 InnoDB
piwik_archive_blob_2012_09 InnoDB
…
Is this good/bad/doesn’t matter? What’s your recommendation? (Ignore/Convert all to …?)
Since it wasn’t a problem for the last couple of months, I guess it wouldn’t become one in the future
Anyway, I still have changed the engine of the 2012 innodb tables to MyISAM now. Reason: Smaller tables, frequent selects & no inserts into the old tables.
I know, new new 2013 tables will be created in innodb format by piwik since it is mysql default, but that’s not a problem. It’s just a minor optimization, so I probably will just convert the again in a couple of months.
More important: I also changed the type of the Tracker tables (from MyISAM) to avoid lock waits:
alter table piwik_log_link_visit_action ENGINE=innodb;
alter table piwik_log_visit ENGINE=innodb;
alter table piwik_log_action ENGINE=innodb;
…
I had an awful lot of lock waits before that change. Ok, it was not that bad, but still.
show global status like ‘Table_locks_%’;