I have a MySQL database installed on a OpenSuse 11.1 server (it is a Bitnami image).
The database works fine, it can stay many days without any error, but when MySQL receives a huge amount of transactions, it dies immediately. The next screen shows the error:
Moreover, I don't know how to restart MySQL. I have tried this:
But it doesn't work, that gives me the next output:
110209 17:09:01 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! 110209 17:09:01 [ERROR] Aborting 110209 17:09:01 [Note] /opt/bitnami/mysql/bin/mysqld.bin: Shutdown complete
It doesn't matter which kind of statements are executing, if they are a huge amount, MySQL dies. The MySQL server version is 5.1.30
What can be causing these sudden failures?