ve got a problem with piwik 0.99 on a webserver. This piwik installation is used for a large community, a few days ago the databased crashed and i spent many hours to repair it (on the server wasnt enough space to repair the db so i had to copy it with scp and so on).
At the moment the size of the repaired database is 116GB, which can be seen here: http://pastebin.com/Z7U06kx1
ve ran the following commands two times, but the table doesnt want to get smaller :
DELETE piwik_log_visit, piwik_log_link_visit_action FROM piwik_log_visit INNER JOIN piwik_log_link_visit_action WHERE piwik_log_visit.idvisit = piwik_log_link_visit_action.idvisit AND visit_server_date <= CURRENT_DATE() - 5
optimize table piwik_log_visit
optimize table piwik_log_link_visit_action
Now my idea is to flush the table piwik_log_visit. but is there any data lost if i will exec the command to do this?
Do you have any other ideas?