Database Crashing on Spiritual Gleam - Inconsistent Table Access

[Dev Joe]

Hello everyone,

I’m managing a website called Spiritual Gleam, which focuses on symbolism and spiritual meanings. Recently, I’ve been encountering an issue where the MySQL database crashes randomly, and certain tables become inaccessible. When this happens, rows in the affected tables either disappear or cannot be retrieved properly. I’ve noticed that this tends to happen during high traffic periods.

Here’s what I’ve checked so far:

InnoDB engine is being used, and I’ve optimized the tables.
I’ve increased the max_connections in the MySQL config to handle more traffic, but the issue persists.
Checked MySQL logs, but nothing conclusive beyond the standard “table crashed” error.
Has anyone faced similar database crashes, especially with websites handling larger datasets? Any suggestions on how to prevent these table crashes and avoid losing data?

Thanks in advance!