MySQL Forums
Forum List  »  InnoDB

Re: Increase INNODB Datafiles
Posted by: Aftab Khan
Date: March 18, 2009 06:07AM

>i have 10 datafiles each 1 GB (10GB summary). My tables grow over month, so no space left in datafiles now.

looks like it you haven't used autoextend option

if you want to add more data files, the steps are as follow

Edit my.cnf(.ini)

innodb_data_file_path = /ibdata/ibdata1:2G;/disk2/ibdata2:2G:autoextend

When you add a new file to the tablespace configuration, make sure that it does not exist. InnoDB will create and initialize the file when you restart the server.

Options: ReplyQuote


Subject
Views
Written By
Posted
4380
January 27, 2009 03:13AM
2001
January 28, 2009 08:28PM
Re: Increase INNODB Datafiles
1948
March 18, 2009 06:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.