Re: InnoDB: What happens when a single AUTOEXTEND file goes past 2GB?

2006-12-03 Thread Paul DuBois
At 11:34 AM +1100 12/4/06, Daniel Kasak wrote: 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,

Re: InnoDB: What happens when a single AUTOEXTEND file goes past 2GB?

2006-12-03 Thread Daniel Kasak
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 fi

Re: InnoDB: What happens when a single AUTOEXTEND file goes past 2GB?

2006-12-03 Thread Paul DuBois
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

Re: InnoDB: What happens when a single AUTOEXTEND file goes past 2GB?

2006-12-03 Thread Daniel Kasak
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

Re: InnoDB: What happens when a single AUTOEXTEND file goes past 2GB?

2006-12-03 Thread Carlos Proal
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/

InnoDB: What happens when a single AUTOEXTEND file goes past 2GB?

2006-12-03 Thread Daniel Kasak
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,