>> mysql-5.1.51 crashed recently and needed to be restarted. This >> doesn't happen often with mysql but does from time to time. Is this >> part of life with mysql or can it be prevented? > > This is not normal. None of my mysql instances crash frequently > > >> I don't think I've >> changed the mysql config from default besides creating the necessary >> tables although I could be wrong. /var/log/mysql/mysqld.err doesn't >> contain info about the crash but here's info from the restart: >> >> [Warning] No argument was provided to --log-bin, and --log-bin-index >> was not used; so replication may break when this MySQL server acts as >> a master and has his hostname changed!! Please use >> '--log-bin=mysqld-bin' to avoid this problem. /usr/sbin/mysqld: Table >> 'mysql.plugin' doesn't exist >> [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to >> create it. >> InnoDB: Started; log sequence number 0 43655 >> [Note] Recovering after a crash using mysqld-bin >> [Note] Starting crash recovery... >> [Note] Crash recovery finished. >> [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' >> doesn't exist >> [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. >> Created with MySQL 50070, now running 50151. Please use mysql_upgrade >> to fix this error. > > > Did you ever run mysql_upgrade as mentioned here?
I'm told I need to run mysqld with --skip-grant-tables. I'm used to using Gentoo's mysql initscript. Should 'mysqld --skip-grant-tables' work? - Grant
