Problem Statement
Joomla website stopped working
Error Message
Joomla php index page was rendering as text.
Error: <p>Table './measure1_joomla_3_3/table_name' is marked as crashed and should be repaired.
Solution
Upon further checking, if you have found the following log, you can try given below Recommendations:
<ffffffff800cb679>] out_of_memory+0x8e/0x2f3
Out of memory: Killed process 29116, UID 101, (mysqld).
Usually, you receive above error when MySQL database table corruption. Following are some of the reasons why MySQL database tables are corrupted.
- Unexpected MySQL server crash due to hardware failure, power failures or bad memory.
- MySQL service is killed by other process
- Insufficient space while performing large database operation.
- MySQL service interruption while performing any database operation.
- Server goes out of memory and it kills MySQL process. This was the root cause for your server.
Recommendations
- Upgrade memory of your server if you are facing such issue frequently.
- Take MySQL database backup in your local system so that in case of serious corruption, you can directly restore database from your local system.
- Navigate to MySQL database directory. In most cases, database are stored at following path;
/var/lib/mysql/dbname/ - Run following command
myisamcheck -r *.MYI
