+-----------------------+------------------------+
| Variable_name | Value |
+-----------------------+------------------------+
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | /var/lib/mysql/ |
+-----------------------+------------------------+
There is one defined, since I have innodb tables in there, very small
ones. But the one I need know will grow easily to 5GB of data and will
archive rows that are 30+ days old once every week.
Since I am not running out of space on the machine, I though I could
give 10GB to the datafile that will contain this new table... Should I
do something like ?
innodb_data_file_path = ibdata1:10M:autoextend;ibdata2:10240M
Will this keep the data in ibdata1 intact ?
Is it good to create a separate tablespace like this ?
> -----Original Message-----
> From: Nils Meyer [mailto:meyer@stripped]
> Sent: Wednesday, February 21, 2007 11:33 AM
> To: mysql@stripped
> Subject: Re: Growing innodb size
>
> 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: This email contains privileged and confidential information and is intended only
for the individual to whom it is addressed. If you are not the named addressee, you
should not disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this transmission by mistake and delete this
communication from your system. E-mail transmission cannot be guaranteed to be secured or
error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses.
AVIS: Le pr
