|Dear All,
As subject, Actually i've been ever meet this case
when i see :
InnoDB: Error: tablespace size stored in header is 877184 pages, but
InnoDB: the sum of data file sizes is 953856 pages
And Mr. Heikki tell me to do these steps:
(953856 - 877184) / 64 = 1198 MB
1) Stop the mysqld server.
2) Add a new 1198M ibdata file at the end of innodb_data_file_path.
3) When you start mysqld, InnoDB will write that new ibdata file full of
zeros, and increment the tablespace size stored in the tablespace header by
1198M.
4) Then stop the mysqld server, remove the extra 1198M ibdata file from
innodb_data_file_path and delete that extra ibdata file.
5) Start mysqld again.
6) Voila! Now the tablespace size stored in the tablespace header agrees
with the combined size of the files in innodb_data_file_path!
BUT
With my case (1056000-640000) / 64 = 6500 Mbyte
It's bigger than a single file in my Linux (2 Gbyte).
My InnoDB data path is:
------------------------
innodb_data_file_path =
/rsv1/ibdata1:2000M;/rsv1/ibdata2:2000M;/rsv1/ibdata3:2000M;/rsv1/ibdata4:2000M;/rsv1/ibdata5:500M;/r
sv3/ibdata6:2000M;/rsv3/ibdata7:2000M;/rsv3/ibdata8:2000M;/rsv3/ibdata9:2000M;
Any solutions?
|
|--
Regards,
Ady Wicaksono
HP: +628562208680
|
