2004 10:41 AM
Aihe: Re: Problem on InnoDB - Tablespace enough but engine said table full
> I try to detect using MC (Midnight Commander) and found that after
;/data4/ibdata25:1802M
>
> it won't write anymore...
>
> I remove these data file and add /ibdata1/ibdata10:1500M and
/data1/ibda
Ady,
- Alkuperäinen viesti -
Lähettäjä: "Ady Wicaksono" <[EMAIL PROTECTED]>
Vastaanottaja: "Ady Wicaksono" <[EMAIL PROTECTED]>; "Heikki Tuuri"
<[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Friday, September 03, 2004 10:41
I try to detect using MC (Midnight Commander) and found that after
;/data4/ibdata25:1802M
it won't write anymore...
I remove these data file and add /ibdata1/ibdata10:1500M and /data1/ibdata11:1500M
I believe, All data below is empty but corrupt :(
data file defintion --
#/data4/ibd
May i know, how could i know which of the data files that InnoDB MySQL engine is not
used ?
Did i i made a mistake when adding table space ?
Heikki Tuuri <[EMAIL PROTECTED]> wrote:
Ady,
InnoDB thinks that the tablespace size is 10 706 MB.
You have specified 36 782 MB of data files in the my.
Ady,
InnoDB thinks that the tablespace size is 10 706 MB.
You have specified 36 782 MB of data files in the my.cnf line :(.
Now you should figure out what are the data files that InnoDB is using, and
remove the end of the innodb_data_file_path line, as well as the unused
ibdata files. Remember t
