 | | | Adding extra ibdata file for a database with last ibdata file with autoextend op | Adding extra ibdata file for a database with last ibdata file with autoextend op 2005-02-15 - By Carol Leung
Back
According to the http://dev.mysql.com/doc/mysql/en/Adding_and_removing.html,
If your last data file was defined with the keyword autoextend, the procedure
to edit my.cnf must take into account the size to which the last data file has
grown. You have to look at the size of the data file, round the size downward
to the closest multiple of 1024 * 1024 bytes (= 1MB), and specify the rounded
size explicitly in innodb_data_file_path. Then you can add another data file.
Remember that only the last data file in the innodb_data_file_path can be
specified as auto-extending.
I am wondering if any data will be lost by rounding the size DOWNLOAD to the
closest multiple of 1024 * 12024 bytes (=1MB). Should it be round UP?
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Earn $52 per hosting referral at Lunarpages.
|
|
|