When you get the error Table piwik_log_visit is marked as crashed and last (automatic?) repair failed.
it means that the Mysql tables got partially corrupt and must be repaired. This problem may occur for various reasons (such as missing space on the disk) but it should occur very rarely.
It is possible to solve this problem by connecting to your Mysql server and executing the following queries:
<code>REPAIR TABLE piwik_log_visit; </code>
(replace piwik_log_visit
with the name of your crashed table as it appears in the error message)
This may not work, in which case use the following solution:
<code>cd /var/lib/mysql/your_piwik_database myisamchk -r -v -f ./piwik_log_visit </code>
Your tables should now be repaired and Piwik up and running!
If the above failed, you can use -o option, which is the safemode
*taken from http://piwik.org/faq/troubleshooting/faq_19363/