Carlos Proal wrote:
Daniel, innodb data files keep growing as needed, it even be of 20Gb or more.
I was under the impression that you should avoid files > 2GB on 32 bit systems, which have to do some dodgy stuff to support files bigger than 2GB. Does this advice apply?
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
Yeah I've been reading that. It says that if we have an autoextend file ( which we do ), then it's current size ( around 500MB now ) will be the limit for all subsequent autoextend files. I'd like to be able to set a limit of 1 or 2 GB, instead of 500MB, for each file. Maybe I'm being a bit nit-picky, but it would be nice. The only thing I can think of at the moment is to import stuff in lots of little bits and pieces, and when my ibdata1 file gets to around 1GB, I shut down MySQL, define a whole heap of other ibdata files in /etc/mysql/my.cnf, delete the log files, and the restart MySQL.
Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
