MySQL Forums
Forum List  »  InnoDB

Re: Different ibdata files for every database
Posted by: aftab ali
Date: July 01, 2010 12:01AM

thanks for reply.

there is one more thing i would like to ask.

i want to create new ibdata file like

innodb_data_file_path=ibdata1:50M;ibdata2:50M:autoextend (currently this line is not in my.ini file i will add this line)


my question is that currently ibdata1 file has size 388 gb
how would i mention that(the size of ibdata1 file) in my.ini and ibdata2 is autoextend that means it will extend after 50M automatically ?
what will be the syntax of innodb_data_file_path= ?



how can i create new ibdata file after every week ?

thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Different ibdata files for every database
2197
July 01, 2010 12:01AM


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.