关于在ubuntu linux下mysql服务自动关闭的解决办法

InnoDB: Error: log file ./ib_logfile0 is of different size 05242880 bytes
InnoDB: than specified in the .cnf file 0 134217728 bytes!
100703  9:28:54 [ERROR] Plugin ‘InnoDB’ initfunction returned error.
100703  9:28:54 [ERROR] Plugin ‘InnoDB’registration as a STORAGE ENGINE failed.
100703  9:28:54 [Note] Found 1 preparedtransaction(s) in SPIDER

只要删除MySQL目录下的ib_logfile0和ib_logfile1两个文件，重启mysql就可以解决问题了。如果用的是ubuntu的话目录在/var/lib/mysql下