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
Subject
Views
Written By
Posted
4883
June 30, 2010 11:32AM
1379
June 30, 2010 06:46PM
1437
June 30, 2010 09:45PM
2050
June 30, 2010 10:58PM
1465
June 30, 2010 11:28PM
Re: Different ibdata files for every database
2197
July 01, 2010 12:01AM
1662
July 01, 2010 08:10PM
2082
July 08, 2010 01:37AM
3421
July 08, 2010 10:19AM
1653
July 01, 2010 04:15AM
1473
July 05, 2010 01:16AM
1563
July 05, 2010 02:07AM
2486
July 05, 2010 12:06PM
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.