We’ve recently upgraded our huge Piwik installation to Piwik 1.12 and activated the Device Detection feature. Turns out that enabling the plugin will on-demand adding fields within the database. It was defently not nice while our database is nearly 1 TB in size with automatic deletion enabled (realy a huge installation). So after the planned shutdown of two hours for the upgrade we’ve another outage of 2 hours because of plugins actions.
Another problem is that after upgrading to 1.12 our dedicated database server (2 processors with 8*2 core each) is permanently hitting a load of 24 (was 5 with 10 at peaks). May caused by the Device Detection, may caused by Piwik itself. Tracking mostly comes through but the admin/report interface is nearly unusable (database connection timeout, too many connections, etc.).
I’m afraid that disableing Device Detection could again change the database structure so we have another outage.
Can you give me any hints? Will Device Detection change the database structure again?