对sql语句进行优化后,因为Mysql 5.1的版本太低发挥不出它的性能,故升级成MariaDB 5.5(msyql的一个分支),但升级之后居然无法启动。
刚开始提示是不能以root用户直接启动,这个好解决,指定用户或者直接以--user=root参数强制启动即可。
但随后报出来以下错误:
mysqld: Too many arguments (first extra is 'started'). 101116 15:01:51 [ERROR] Aborting 101116 15:01:51 InnoDB: Starting shutdown... 101116 15:01:52 InnoDB: Shutdown completed; log sequence number 7 1210783078 101116 15:01:52 [Note] mysqld: Shutdown complete
不明所以,完全没有具体的错误信息,看提示大致是参数错了,但我才刚装完啥都没改过,怎么会多出来参数?
用安全模式启动,
./mysqld_safe &
一样的错误,但是多出一点信息,有个日志文件输出在 /var/lib/mysql/AY140303093130432ccbZ.err
打开该日志文件,看到有如下信息:
140929 13:59:58 mysqld_safe mysqld from pid file /var/lib/mysql/AY140303093130432ccbZ.pid ended 140929 14:00:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140929 14:00:46 InnoDB: The InnoDB memory heap is disabled 140929 14:00:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140929 14:00:46 InnoDB: Compressed tables use zlib 1.2.3 140929 14:00:46 InnoDB: Using Linux native AIO 140929 14:00:46 InnoDB: Initializing buffer pool, size = 128.0M 140929 14:00:46 InnoDB: Completed initialization of buffer pool 140929 14:00:46 InnoDB: highest supported file format is Barracuda. 140929 14:00:46 InnoDB: Waiting for the background threads to start 140929 14:00:47 Percona XtraDB (http://www.percona.com) 5.5.38-MariaDB-35.2 started; log sequence number 1597945 140929 14:00:47 [Note] Plugin 'FEEDBACK' is disabled. 140929 14:00:47 [Note] Server socket created on IP: '0.0.0.0'. 140929 14:00:47 [Note] Event Scheduler: Loaded 0 events 140929 14:00:47 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.39-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 140929 14:03:52 [Note] /usr/sbin/mysqld: Normal shutdown 140929 14:03:52 [Note] Event Scheduler: Purging the queue. 0 events 140929 14:03:52 InnoDB: Starting shutdown... 140929 14:03:53 InnoDB: Shutdown completed; log sequence number 1597945 140929 14:03:53 [Note] /usr/sbin/mysqld: Shutdown complete
其中一行 140929 14:00:46 InnoDB: highest supported file format is Barracuda.
看样子是数据文件的格式不同,不支持啊,幸好之前备份了sql文件,
将目录下的数据文件删除重新建立(或者直接删除后重装),再启动MariaDB,终于正常了
接着把sql数据导入,收工!