List:General Discussion« Previous MessageNext Message »
From:Nils Meyer Date:February 21 2007 4:32pm
Subject:Re: Growing innodb size
View as plain text  
Hi,

Jean-Sebastien Pilon wrote:
> I would like to grow my innodb table space, the only problem that I have
> is that I did not declare any size in the config file since we were not
> using it to start with. If I modify the config file, will this override
> the current innodb file or will it grow it ? Or should dump all the
> data, modify the config file and re-import everything ?

Chances are that innodb isn't even functional if you did not specify a 
tablespace any way. You can check with:
mysql> SHOW VARIABLES LIKE LIKE 'innodb_data%';

If there is a data path given you'll see how it has been set up. Do you 
want a fixed size or should it grow automatically?

Anyways, you might want to check this documentation:
http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html

NOTICE: You should not send privileged and confidential information to a 
maillinglist ;)

regards
Nils
Thread
Growing innodb sizeJean-Sebastien Pilon21 Feb
  • Re: Growing innodb sizeNils Meyer21 Feb
    • RE: Growing innodb sizeJean-Sebastien Pilon21 Feb
      • RE: Growing innodb sizeJean-Sebastien Pilon24 Feb
        • Re: Growing innodb sizeCarlos Proal24 Feb