I am working with Matomo. (Around 100,000 visits per day)
Matomo version: 3.3.0
MySQL version: 5.5.57
PHP version: 5.6.30-0+deb8u1
Some tables of Piwik were marked as crashed and … finally repaired.
After this issue, I had some strange report tables, (attached picture, left side)
Then I removed the report tables, and force the Matomo to regenerate it.
The strange point is that the reports for 2017-08 and 2017-07 are missing.
In another action, I invalidated the reports for last year (using invalidate plugin). but still missing some reports.
(attached picture, right side).
I checked the ‘piwik_log_link_visit_action’ table, and it contains the data for the mentioned period.
Are there any tools/scripts/tests to be sure that stored data are correct and there is no data conflict?
Especially in piwik_log_visit, piwik_log_action, and piwik_log_link_visit_action tables.
Do you have any idea, experience or suggestion?
Thank you in advance for your kind attention and supports.