From: Date: February 15 2005 5:11am
Subject: Adding extra ibdata file for a database with last ibdata file with autoextend option (mysql 3.x)
List-Archive: http://lists.mysql.com/win32/16579
Message-Id: <20050215041103.44809.qmail@web52308.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-750185502-1108440663=:44739"

--0-750185502-1108440663=:44739
Content-Type: text/plain; charset=us-ascii

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 
--0-750185502-1108440663=:44739--