Paul DuBois wrote:
At 10:57 AM +1100 12/4/06, Daniel Kasak wrote:
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
That's not how I read it. How did you draw this conclusion?
OK. Upon 2nd reading, it seems like I was wrong. The size of the current
autoextend file only affects the final size of *that* ibdata file; not
subsequent ones. So therefore I can do something like:
innodb_data_file_path =
ibdata1:512M;ibdata2:1024M;ibdata3:1024M;ibdata4:1024M
... all the way to 30 of them :)
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
