Hey john, Yes you can add it but safe to keep auto-extend at the end and monitor the disk space as well.
"Now when i run the same show table status command, the comment field says: InnoDB free: 6144 kB Is that telling me that I only have 6MB of storage left even though I increased the table space by 8GB?" About the above - it is saying 6144 KB so it is 6.1 GB. On Tue, Aug 3, 2010 at 12:05 AM, Johnny Withers <joh...@pixelated.net>wrote: > I recently ran out of table space on a production server that had the > following configuration line: > > > innodb_data_file_path=ibdata1:1G;ibdata2:1G;ibdata3:1G;ibdata4:1G;ibdata5:1G;ibdata6:2G:autoextend:max:8G > > Before I changed this line and restarted the server, I ran SHOW TABLE > STATUS > LIKE 'table' on one of the databases and the comment filed said: > InnoDB Free: 3NNN kB (I don't remember the exact number, but know it > started > with 3 and had 4 digits. > > I modified the configuration line above to: > > > innodb_data_file_path=ibdata1:1G;ibdata2:1G;ibdata3:1G;ibdata4:1G;ibdata5:1G;ibdata6:2G:autoextend:max:16G > > Now when i run the same show table status command, the comment field says: > InnoDB free: 6144 kB > > Is that telling me that I only have 6MB of storage left even though I > increased the table space by 8GB? > > Also, If I wanted to add another file to this file_path variable, can I > just > add it to the end like so: > > > innodb_data_file_path=ibdata1:1G;ibdata2:1G;ibdata3:1G;ibdata4:1G;ibdata5:1G;ibdata6:16G; > *ibdata7:16G* > > Or will that cause MySQL to complain the file size isn't correct the next > time it starts? > > > Thanks for any help! > > > -- > ----------------------------- > Johnny Withers > 601.209.4985 > joh...@pixelated.net > -- Thanks Suresh Kuna MySQL DBA