|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
Reply by me.
How stupid i'm :(
I've finished this warning error problem by adding
4 files -- 3 file each 3 Gbyte and 1 file 500Mbyte
Thx mr. heiiki :D
Sorry
Ady Wicaksono wrote:
|Dear All,
As subject, Actually i've been ever meet this case
when i see :
InnoDB: Error: tablespace size
Ian,
- Original Message -
From: Ian Grant [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, January 05, 2005 4:47 PM
Subject: Re: InnoDB: Error: tablespace size stored in header is 17024 pages,
Dear Heikki
Many thanks for your reply.
On Mon, 3 Jan 2005 20:41:22
On Thu, 6 Jan 2005 11:30:33 +0200
Heikki Tuuri [EMAIL PROTECTED] wrote:
innodb_data_file_path = ibdata2:7M;ibdata1:10M:autoextend
You have to add new data files to the end of the line, not to the
start. Please follow the instructions at
Dear Heikki
Many thanks for your reply.
On Mon, 3 Jan 2005 20:41:22 +0200
Heikki Tuuri [EMAIL PROTECTED] wrote:
are you sure that you copied the complete ibdata1 file to the new
place? It is strange how 7 MB can be missing from the file end.
I have just checked the tar file I used to do the
://www.innodb.com/order.php
Order MySQL technical support from https://order.mysql.com/
- Original Message -
From: Ian Grant [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, December 31, 2004 5:26 PM
Subject: InnoDB: Error: tablespace size stored in header is 17024 pages
Dear MySQL people
I have a question regarding the error:
InnoDB: Error: tablespace size stored in header is 17024 pages, but
InnoDB: the sum of data file sizes is only 16576 pages
which appeared when I upgraded from 4.0.7 to 4.1.7.
Somehow I am 448 pages (7M) short of table space.
Can I fix
Hi, we're using Innodb here and I just upped the number of datafiles
that innodb was using. When I did a show table status I noticed that I
didn't get all the space that I had added. When I looked at the error
log, I got recieved the following error.
InnoDB: Error: tablespace size stored
Shakeel,
- Original Message -
From: Shakeel Sorathia [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, November 13, 2002 9:39 PM
Subject: InnoDB: Error: tablespace size stored in header
Hi, we're using Innodb here and I just upped the number of datafiles