Daniel, innodb data files keep growing as needed, it even be of 20Gb or more. If you want several data files (mainly because performance) you need to add them in the my.cnf following the instructions in:
14.2.7. Adding and Removing InnoDB Data and Log Files http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html Hopes this help. Carlos On 12/3/06, Daniel Kasak <[EMAIL PROTECTED]> wrote:
Hi all. I'm about to import a LOT of data ( 20 GB ) into some InnoDB tables. At the moment, I have: innodb_data_file_path = ibdata1:10M:autoextend in my /etc/mysql/my.cnf The ibdata1 file is 499MB at the moment. What happens when this goes past 2GB? Do I automatically get allocated another, ibdata2, or something, or do I have to manually add one by shutting down MySQL, adding the extra file to the line above, and restarting? Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]