HELP: Table piwik_log_link_visit_action is marked as crashed and should be repaired

Support & Bugs
1

Hello,

Recently I am working with Piwik. (Around 200,000 visits per day)
Piwik version: 3.2.0
MySQL version: 5.5.57
PHP version: 5.6.30-0+deb8u1
Problem:
Table piwik_log_link_visit_action is marked as crashed and should be repaired. :sob:
I followed the piwik documentation and the following command solved the problem.

myisamchk -r -q ./piwik_log_link_visit_action --sort_buffer_size=4G

Also, this command worked in another ceash.
myisamchk -r -v -f ./piwik_log_link_visit_action --sort_buffer_size=4G

but this problem happened again next day and again the day after that! Table size is around 50G.
Do you have any idea how can I find the source of problem and solve it?

Thank you in advance for your kind attention and supports.
Absolutely new member,:face_with_head_bandage:
Web Tester

Update: Table is ok only few hours!! then it crashes again!

04-Nov-2017:
Is it a good idea to change the MyISAM tables to InnoDB ?
if yes, Alter table … is ok?

2

Hi,

I can’t help much as I have little experience with larger MySQL databases.
But it seems like this error is occurring outside of Piwik (or any PHP at all) but rather the files MySQL saves the database in get corrupted.
I’m not sure what to do but maybe check if there are file system errors, if the disk is working correctly and there is enough space left.