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
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
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
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
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
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,
