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;/
data0/ibdata6:1500M;/data0/ibdata7:1500M;/data1/ibdata8:1500M;/data1/ibdata9:1500M;/data4/ibdata25:1802M;/data3/ibdata25:1802M
;/data4/ibdata25.data3:576M;/data1/ibdata10:1500M;/data1/ibdata11:1500M;/data1/ibdata12:1500M;/data1/ibdata13:1500M;/data2/ibd
ata14:1500M;/data2/ibdata15:1500M;/data2/ibdata16:1500M;/data2/ibdata17:1500M;/data2/ibdata18:1500M;/data2/ibdata19:1500M;/dat
a3/ibdata20:1500M;/data3/ibdata21:1500M;/data3/ibdata22:1500M;/data3/ibdata23:1500M;/data3/ibdata24:1500M;
What i don't understand is :
after ibdata1 -> ibdata9 full is go to /data4/ibdata25 ... (1802Mbyte)
But it's not continues to write to /data4/ibdata25.data3... /data1/ibdata10 and so on
but said table .... is full when i try to write data to table
The question is why ?
Secondly
What is the meaning of
InnoDB: Error: tablespace size stored in header is 685184 pages, but
InnoDB: the sum of data file sizes is 2354048 pages
Thx
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
