1. Why would MySQL server shutdown?
What would cause the MySQL server to just shutdown, apparently on its own?
This server is running on a Linux (RH 7.3) (Dell) box with 512mb RAM and a
SCSI RAID array. The MySQL version is 3.23.53, installed from RPM's. The
RPM's were downloaded from a MySQL mirror (did not install the versions on
the RH CD). The installation was done with RH's GUI and is a straight server
install (not a custom).
When the server was installed, the server started as one would expect and we
gave root a password then ran a set of scripts to create and populate some
The server ran for about 7 days, then abruptly shutdown. A check of the log
(/var/log/mysqld.log) indicated it was simply a shutdown, and we could find
no further information. The tech restarted the box (he works with Windoze a
lot), thinking mysql would restart. It did not.
At first, I thought there may be a runaway cronjob (the first shutdown was
about 24 hrs after one of the students tried to setup a cronjob do a
database backup with a shell script he had written), but that doesn't seem
to be the case.
He uninstalled MySQL with the RH Package Manager, then re-installed the same
RPM set. It came up normally, he set a root password, and
recreated/populated the databases. It ran fine for about 5 days, then
shutdown again, and would not start on a restart. Again, no error messages,
no evidence of an unclean shutdown, no ???
Again, we removed/reinstalled, it came up and is running fine.
Needless to say, this is driving us nuts. Any suggestions or ideas will be
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
2. MMPM/2 Help!!!
3. MySQL Server - automatic shutdown
4. Netgear routers with SPI
5. "Thou shalt use 'Shutdown Abort' whenever you shutdown the database." Makes sense?
6. Tekelec Chameleon 32
7. Unexpected server shutdown
8. formatting number
9. Server shutdown
10. Mysqladmin can't shutdown server
11. CURRENT TIME causes server to shutdown connection
12. Timeout and shutdown of BizTalk server when accessing database
13. MySQL Server as Linked Server to MSSQL Server?