mysql启动后台服务时占用磁盘使用率100% 如何解决? 本帖最后由 imergang 于 2011-02-18 19:49:32 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 装了两个mysql?先得确认哪个在工作。 看一下MYSQL的错误日志,贴出来以供分析。 把此命令结果贴上来看看Show engine innodb status\G; [code=SQ]110218 17:53:09 [Note] Plugin 'FEDERATED' is disabled.InnoDB: The first specified data file D:\MySQL Datafiles\ibdata1 did not exist:InnoDB: a new database to be created!110218 17:53:09 InnoDB: Setting file D:\MySQL Datafiles\ibdata1 size to 10 MBInnoDB: Database physically writes the file full: wait...InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytesInnoDB: than specified in the .cnf file 0 10485760 bytes!110218 17:53:09 [ERROR] Plugin 'InnoDB' init function returned error.110218 17:53:09 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.110218 17:53:09 [ERROR] Unknown/unsupported table type: INNODB110218 17:53:09 [ERROR] Aborting110218 17:53:09 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete110218 18:05:19 [Note] Plugin 'FEDERATED' is disabled.InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytesInnoDB: than specified in the .cnf file 0 10485760 bytes!110218 18:05:19 [ERROR] Plugin 'InnoDB' init function returned error.110218 18:05:19 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.110218 18:05:19 [ERROR] Unknown/unsupported table type: INNODB110218 18:05:19 [ERROR] Aborting110218 18:05:19 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete110218 18:13:17 [Note] Plugin 'FEDERATED' is disabled.InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytesInnoDB: than specified in the .cnf file 0 10485760 bytes!110218 18:13:17 [ERROR] Plugin 'InnoDB' init function returned error.110218 18:13:17 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.110218 18:13:17 [ERROR] Unknown/unsupported table type: INNODB110218 18:13:17 [ERROR] Aborting110218 18:13:17 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete110218 18:14:35 [Note] Plugin 'FEDERATED' is disabled.InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytesInnoDB: than specified in the .cnf file 0 10485760 bytes!110218 18:14:35 [ERROR] Plugin 'InnoDB' init function returned error.110218 18:14:35 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.110218 18:14:35 [ERROR] Unknown/unsupported table type: INNODB110218 18:14:35 [ERROR] Aborting110218 18:14:35 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete110218 18:21:22 [Note] Plugin 'FEDERATED' is disabled.InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytesInnoDB: than specified in the .cnf file 0 10485760 bytes!110218 18:21:22 [ERROR] Plugin 'InnoDB' init function returned error.110218 18:21:22 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.110218 18:21:22 [ERROR] Unknown/unsupported table type: INNODB110218 18:21:22 [ERROR] Aborting110218 18:21:22 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete110218 18:27:05 [Note] Plugin 'FEDERATED' is disabled.InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytesInnoDB: than specified in the .cnf file 0 10485760 bytes!110218 18:27:05 [ERROR] Plugin 'InnoDB' init function returned error.110218 18:27:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.110218 18:27:05 [ERROR] Unknown/unsupported table type: INNODB110218 18:27:05 [ERROR] Aborting110218 18:27:05 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete110218 18:34:10 [Note] Plugin 'FEDERATED' is disabled.InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytesInnoDB: than specified in the .cnf file 0 10485760 bytes!110218 18:34:10 [ERROR] Plugin 'InnoDB' init function returned error.110218 18:34:10 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.110218 19:23:29 [Note] Plugin 'FEDERATED' is disabled.InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytesInnoDB: than specified in the .cnf file 0 10485760 bytes!110218 19:23:30 [ERROR] Plugin 'InnoDB' init function returned error.110218 19:23:30 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.110218 21:29:24 [Note] Plugin 'FEDERATED' is disabled.InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytesInnoDB: than specified in the .cnf file 0 10485760 bytes!110218 21:29:24 [ERROR] Plugin 'InnoDB' init function returned error.110218 21:29:24 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.110219 9:50:42 [Note] Plugin 'FEDERATED' is disabled.InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytesInnoDB: than specified in the .cnf file 0 10485760 bytes!110219 9:50:42 [ERROR] Plugin 'InnoDB' init function returned error.110219 9:50:42 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.[/code] 回复3楼 因为mysql启动不了了 Show engine innodb status\G;命令无法执行 回复2楼 err日志太大了 只把这2天的帖了出来 这个文件在这里下载下载 保存7天 修改 C:\Program Files\MySQL\MySQL Server 5.1\my.ini成innodb_data_file_path=ibdata1:autoextendinnodb_log_file_size=25165824innodb_buffer_pool_size=1G试试 磁盘空间满了吧,把err日志删了再启吧。 新手求助:如何判断ABCD档,并送到指定的表中 求一本讲解数据库的工具书 insert into 很慢!!! 一个排序怎么解决? xp使用mysql出现的问题 请教,如何有导入*.sql文件. 问高手:计算机突然断电后,select命令执行时出现数据文件瘫痪,怎么解决? 我的全文索引,只要使用表连接,就不使用索引了 mysql 服务无法启动 java连接到mysql [求]帮忙推荐一款数据库建模工具 【新手提问】为什么Linux下MySQL的data目录下没有information_schema数据库的文件
先得确认哪个在工作。
Show engine innodb status\G;
InnoDB: The first specified data file D:\MySQL Datafiles\ibdata1 did not exist:
InnoDB: a new database to be created!
110218 17:53:09 InnoDB: Setting file D:\MySQL Datafiles\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
110218 17:53:09 [ERROR] Plugin 'InnoDB' init function returned error.
110218 17:53:09 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110218 17:53:09 [ERROR] Unknown/unsupported table type: INNODB
110218 17:53:09 [ERROR] Aborting110218 17:53:09 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete110218 18:05:19 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
110218 18:05:19 [ERROR] Plugin 'InnoDB' init function returned error.
110218 18:05:19 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110218 18:05:19 [ERROR] Unknown/unsupported table type: INNODB
110218 18:05:19 [ERROR] Aborting110218 18:05:19 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete110218 18:13:17 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
110218 18:13:17 [ERROR] Plugin 'InnoDB' init function returned error.
110218 18:13:17 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110218 18:13:17 [ERROR] Unknown/unsupported table type: INNODB
110218 18:13:17 [ERROR] Aborting110218 18:13:17 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete110218 18:14:35 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
110218 18:14:35 [ERROR] Plugin 'InnoDB' init function returned error.
110218 18:14:35 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110218 18:14:35 [ERROR] Unknown/unsupported table type: INNODB
110218 18:14:35 [ERROR] Aborting110218 18:14:35 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete110218 18:21:22 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
110218 18:21:22 [ERROR] Plugin 'InnoDB' init function returned error.
110218 18:21:22 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110218 18:21:22 [ERROR] Unknown/unsupported table type: INNODB
110218 18:21:22 [ERROR] Aborting110218 18:21:22 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete110218 18:27:05 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
110218 18:27:05 [ERROR] Plugin 'InnoDB' init function returned error.
110218 18:27:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110218 18:27:05 [ERROR] Unknown/unsupported table type: INNODB
110218 18:27:05 [ERROR] Aborting110218 18:27:05 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete110218 18:34:10 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
110218 18:34:10 [ERROR] Plugin 'InnoDB' init function returned error.
110218 18:34:10 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110218 19:23:29 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
110218 19:23:30 [ERROR] Plugin 'InnoDB' init function returned error.
110218 19:23:30 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110218 21:29:24 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
110218 21:29:24 [ERROR] Plugin 'InnoDB' init function returned error.
110218 21:29:24 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110219 9:50:42 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
110219 9:50:42 [ERROR] Plugin 'InnoDB' init function returned error.
110219 9:50:42 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[/code]
回复2楼 err日志太大了 只把这2天的帖了出来 这个文件在这里下载下载 保存7天
成
innodb_data_file_path=ibdata1:autoextend
innodb_log_file_size=25165824
innodb_buffer_pool_size=1G
试试
磁盘空间满了吧,把err日志删了再启吧。