Database Crashing on Spiritual Gleam - Inconsistent Table Access
Posted by:
Dev Joe
Date: September 24, 2024 02:35AM
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!
Subject
Views
Written By
Posted
Database Crashing on Spiritual Gleam - Inconsistent Table Access
132
September 24, 2024 02:35AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.