I am using Piwik since 1 year now and I have a lot of data into my database.
When new visitors are coming on my website, some inserts / updates queries are running on MySQL. My problem is that when I analyze my datas, I make a lot of select queries and MySQL locked a lot of insert queries (untill all the answers are done).
My suggestion was: what do you think to change the Piwik queries from:
Do you have some optimization problems you too ?
Did you ever try the “delayed” option ?