On Sep 24, 2004, at 4:03 AM, MaFai wrote:
Dear [EMAIL PROTECTED]:
Here's my setting: innodb_data_file_path = ibdata1:10M:autoextend
Now the ibdata1 has been grow up to 1.3G
We try to add more ibdata file to store the data by the following setting.
innodb_data_file_path = ibdata1:1500M;ibdata2:1500M:autoextend
innodb_data_file_path = ibdata1:10M;ibdata2:10M:autoextend
The first one is closer, but you need to specify the size of the current file _exactly_ (as opposed to something a little larger than it as you have done). There's a pretty clear example in the manual:
<http://dev.mysql.com/doc/mysql/en/Adding_and_removing.html>
Good luck, Ware
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]