Originally Posted by madunix
Lately I got this messgae in my errorLog file on my old mysql server, need more datails why the DB was restarted!
120711 19:42:06 mysqld restarted
120711 19:42:06 [Warning] Asked for 196608 thread stack, but got 126976
120711 19:42:07 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
120711 19:42:07 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 4 4031987031.
InnoDB: Doing recovery: scanned up to log sequence number 4 4031987031
InnoDB: Last MySQL binlog file position 0 78062804, file name ./abc-bin.000097
120711 19:42:07 InnoDB: Flushing modified pages from the buffer pool...
120711 19:42:07 InnoDB: Started; log sequence number 4 4031987031
/usr/sbin/mysqld: ready for connections.
Version: '4.1.14-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
No idea, and there's little chance anyone can tell you from what you've posted. The message is clear: MySQL wasn't shut down normally. So, either someone killed the process, instead of doing a "mysqld stop", or the server was powered off/shut down incorrectly.
Check the MySQL logs for info, check your system uptime, and look at the .bash_history logs for your users (and root, too), to see if someone killed the DB process.