Heiki
Thx... it's work :D
Sorry, one liner
Heikki Tuuri [EMAIL PROTECTED] wrote:
Ady,
- Alkuperäinen viesti -
Lähettäjä: Ady Wicaksono
Vastaanottaja: Ady Wicaksono ; Heikki Tuuri
Kopio:
Lähetetty: Friday, September 03, 2004 10:41 AM
Aihe: Re: Problem on InnoDB - Tablespace enough
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 --
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 AM
Aihe: Re: Problem on InnoDB - Tablespace enough but engine said
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
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
I have MySQL for heavy duty job .
here is my InnoDB table space definition
innodb_data_file_path =
/data0/ibdata1:10M;/data0/ibdata2:10M;/data0/ibdata3:1082M;/data0/ibdata4:1500M;/data0/ibdata5:1500M;/