We have a desktop application on Windows OS that installs with MariaDB server 10.4.10. Sometimes the client loses power and after restarting of PC MariaDB database becomes corrupted and Windows Server is not starting. The logs show that some tables are randomly broken. The server configuration is the default, not heavily loaded with one request per 1-5sec. I'm wondering if there are some configuration changes that can help avoid or at least decrease the probability of this issue?
Most likely it is because of Windows
write caching. While caching provides speed, it also defers writing to disk. You dont normally want to remove it for everything.
One way to fix it,
- create a new partition on your disk
- move the database files onto it
- disable write caching.
Note that there is the
Flush command in MariaDB, that you could try.