Ah, you replied while I was testing

Mysql tables can sometimes get corrupted. Can be a variety of things, even when a hardrive fills up. It definitely shouldn't happen that often. Reports of table corruption here are pretty rare. If it does start to happen frequently it could be a sign of an underlying problem which you might want to talk to your host about if you're on a hosted server.