I'm the Administrator of a Moodle site which had its Users table corrupted and it became unusable.
Luckily, a simple
REPAIR TABLE mdl_user made it work back again. The thing is that I don't know why it actually crashed and made it unusable, and I want to make sure that I'm better prepared next time.
I'm not a thoroughly experienced DBA — I'm just a developer who does a lot of stuff, so please bear with me.
I could just restore a backup, but I guess there are ways to prevent crashes.
Those tables are utf8_general_ci and using MyISAM.
Why does a MySQL table crash? What can I do to prevent that from happening?