动态:添加表空间定义文件出错不能添加第2个文件 innodb_data_file_path = /data1/ibdata1:10M:autoextend;/data1/ibdata2:1000M:a...

遇到问题:
动态:添加表空间定义文件出错不能添加第2个文件
innodb_data_file_path = /data1/ibdata1:10M:autoextend;/data1/ibdata2:1000M:autoextend





InnoDB: Error: data file ./ibdata1 is of a different size
InnoDB: 1152 pages (rounded down to MB)
InnoDB: than specified in the .cnf file 640 pages!
130426  8:46:08 InnoDB: Could not open or create data files.
130426  8:46:08 InnoDB: If you tried to add new data files, and it failed here,
130426  8:46:08 InnoDB: you should now edit innodb_data_file_path in my.cnf back
130426  8:46:08 InnoDB: to what it was, and remove the new ibdata files InnoDB created
130426  8:46:08 InnoDB: in this failed attempt. InnoDB only wrote those files full of
130426  8:46:08 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
130426  8:46:08 InnoDB: remove old data files which contain your precious data!
130426  8:46:08 [ERROR] Plugin 'InnoDB' init function returned error.
130426  8:46:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130426  8:46:08 [ERROR] Unknown/unsupported storage engine: InnoDB
130426  8:46:08 [ERROR] Aborting

原因:表格空己经涨到18M,但是指定10M出错


#bug
innodb_data_file_path = ibdata1:10M;ibdata2:10M:autoextend

修改:




[root@james data1]# ll -h
total 30M
drwx------ 2 mysql mysql 4.0K Apr 26 08:04 demo
-rw-rw---- 1 mysql mysql  18M Apr 26 09:17 ibdata1



innodb_data_file_path = ibdata1:18M;ibdata2:10M:autoextend

转载于:https://www.cnblogs.com/kaka100/archive/2013/04/27/3046291.html