phpMyVisites is changing into Piwik
Piwik is the next generation of phpMyVisites and aims to be an open source alternative to Google Analytics.
Try the online demo, download Piwik or find out more!
FAQ
FAQ : Known problems
The MySQB database gets bigger, in particular the table phpmv_visit : why? When will it be 'purged'?
The table phpmv_visit contains all the visitors logs. The logs are used for the statistics generation for every day, week and month. Logs of a given date stay in the database until the day is archived, and the week containing the day is archived, and the month containing this day is archived.
So in order to purge the phpmv_visit table, you have to archive all the past days, weeks and months. To do so, you can request the statistics reports of the past 3 months for example, that will archive every day of these months. You can also request the statistics reports for the last week, this will automatically compute the reports for the last 7 weeks.
Once the phpmv_visit table is emptied from all the old logs, it should have its optimal size. On a website that has a certain amount of traffic, the table size can be several MB, but this is normal.
Back to FAQ So in order to purge the phpmv_visit table, you have to archive all the past days, weeks and months. To do so, you can request the statistics reports of the past 3 months for example, that will archive every day of these months. You can also request the statistics reports for the last week, this will automatically compute the reports for the last 7 weeks.
Once the phpmv_visit table is emptied from all the old logs, it should have its optimal size. On a website that has a certain amount of traffic, the table size can be several MB, but this is normal.