mysql job failed to start_修改my.cnf后，mysql不能启动，提示“start: Job failed to start”...

1)在my.cnf的mysqld块中加入以下三行配置后，重启mysql，不能正常启动提示“start:Jobfailedtostart”innodb_doublewrite=1innodb_flush_log_at_trx_commit=1sync_binlog=12)err.lo...

1)在my.cnf的mysqld块中加入以下三行配置后，重启mysql，不能正常启动提示“start: Job failed to start”

innodb_doublewrite=1

innodb_flush_log_at_trx_commit=1

sync_binlog=1

2)err.log的内容如下所示

130918 13:52:34 [Note] /usr/sbin/mysqld: Normal shutdown

130918 13:52:34 [Note] Event Scheduler: Purging the queue. 0 events

130918 13:52:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 1854 user: 'test'

130918 13:52:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 1853 user: 'test'

130918 13:52:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 1852 user: 'test'

130918 13:52:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 1851 user: 'test'

130918 13:52:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 1850 user: 'test'

130918 13:52:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 1849 user: 'test'

130918 13:52:37 InnoDB: Starting shutdown...

130918 13:52:38 InnoDB: Waiting for 11 pages to be flushed

130918 13:52:41 InnoDB: Shutdown completed; log sequence number 152979412

130918 13:52:41 [Note] /usr/sbin/mysqld: Shutdown complete

3)将新加入的三行配置注掉，再重启mysql，还是报一样的错误，并且日志不记新的了。

求解答，特别着急，在线等，谢谢各位·！

展开