INNODB database size

2006-04-25 Thread Todd Smith
Hello I have inherited an INNODB database. I am new to MySQL and may not be describing my problem correctly so any suggestions or questions are welcome. I have data files named ib_data_00 through ib_data_14 all of which are 2.0G. I also have ib_data_15 which is 26G. I am receiving errors saying

Re: INNODB database size

2006-04-25 Thread Pure Web Solution
Todd you need to look at how InnoDB is configured and learn a bit about how Innodb uses and manages its tablespace. if you look in the my.ini options file you should see how innodb is set up for your installation. Take a look at the link below that explains how InnoDB can be set up:

Re: INNODB database size

2006-04-25 Thread Gary Richardson
Look at your my.cnf for a configuration directive called 'innodb_data_file_path'. This is where you configure the files for the innodb table space. The last one is probably an auto-grow. My guess is that every time it complains, it's just added 8MB to the file. If you remove the auto-grow (and I