List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:August 2 2010 6:35pm
Subject:InnoDB Tablespace
View as plain text  
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
johnny@stripped

Thread
InnoDB TablespaceJohnny Withers2 Aug
  • Re: InnoDB TablespaceSuresh Kuna2 Aug
    • Re: InnoDB TablespaceJohnny Withers3 Aug
      • Re: InnoDB TablespaceSuresh Kuna3 Aug
  • Re: InnoDB TablespaceJohan De Meersman5 Aug