Table Locked when cleaning


#1

Hello,

I am processing a lot of traffic (3M pages/day) and have an issue with the old visitor log cleaning. When archiving, the cleaning locks my table and prevent Piwik from recording any traffic during that time (which can take up to 1 hour…I can’t afford to loose traffic for 1 hour)

Is there a way around this ?

Many Thanks


(Matthieu Aubry) #2

Hi there,

Can you check if your mysql tables are Innodb or Myisam? If they are not innodb, convert them to Innodb which will help.