MyISAM
On Wed, Feb 8, 2012 at 11:43 AM, Steve Meyers <[email protected]> wrote: > On 2/8/12 11:32 AM, Merrill Oveson wrote: >> My mysql database just shutdown today. >> >> I had to reboot the machine. >> >> Upon reboot I get the following: >> >> >> * Starting mysql ... >> * Strange, the socket file already exist in >> "/var/run/mysqld/mysqld.sock" >> * it will be removed now and re-created by the MySQL server >> * BUT please make your checks. >> * Starting mysql (/etc/mysql/my.cnf) >> * MySQL NOT started (0) >> >> >> It says MsSQL not started. But it did start. >> Anybody know what's going on? > > I believe that the init script checks the pid file (location varies by > distribution). I believe that safe_mysqld writes the pid file. > > Also, because of what I assume was a hard reboot (MySQL didn't shut down > cleanly), it could take it a while to do crash recovery. It could be > just fine, but the init script wasn't patient enough waiting for it to > be available. > > I would check your MySQL error logs, they may have some clues. They're > probably in /var/log/mysql. > > Are you primarily using InnoDB or MyISAM? > > Steve > > /* > PLUG: http://plug.org, #utah on irc.freenode.net > Unsubscribe: http://plug.org/mailman/options/plug > Don't fear the penguin. > */ /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
