最近遇到mysql 启动问题
[root@localhost mysql]# /etc/init.d/mysqld start
Starting MySQL.........The server quit without updating PID file (/app/mysql/localhost.localdomain.pid).[FAILED]
可以在mysql errorlog中看到
140508 14:15:19 mysqld_safe Starting mysqld daemon with databases from /app/mysql
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
140508 14:15:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140508 14:15:19 InnoDB: The InnoDB memory heap is disabled
140508 14:15:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
这个时候需要检查basedir和datadir。配置的值得和初始化时的值一致。
因而,若要修改datadir的值,则需要重新初始化数据库:
/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/app/mysql
使用innodb对于日志的基本配置:
innodb_data_home_dir = /app/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /app/mysql