InnoDB: How to increase table/DB size after the fact?
Hello, To use InnoDB you have to put how large of a file MySQL is allowed to make by putting an entry in /etc/my.cnf such as the one I used: innodb_data_home_dir = /var/lib/mysql/innodb innodb_data_file_path = indb1:200M;indb2:200M that of course gives us 400M total. I have not yet found in the documentation just what we will need to do when our tables fill up and we need more space. Because of the way the InnoDB tables are created initially I get the impression that you can't increase the size shown in /etc/my.cnf later on. Or am I wrong - do we just increase the MB shown in /etc/my.cnf? Do we add a third fiels there (Example: innodb_data_file_path = indb1:200M;indb2:200M;indb3:500MB ) ? TIA Jonathan Wilson System Administrator Cedar Creek Software http://www.cedarcreeksoftware.com Central Texas IT http://www.centraltexasit.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[solved] Re: InnoDB: How to increase table/DB size after the fact?
Ah, I finally found mention of this in the manual. Sorry to bother everyone. Thanks. --- Hello, To use InnoDB you have to put how large of a file MySQL is allowed to make by putting an entry in /etc/my.cnf such as the one I used: innodb_data_home_dir = /var/lib/mysql/innodb innodb_data_file_path = indb1:200M;indb2:200M that of course gives us 400M total. I have not yet found in the documentation just what we will need to do when our tables fill up and we need more space. Because of the way the InnoDB tables are created initially I get the impression that you can't increase the size shown in /etc/my.cnf later on. Or am I wrong - do we just increase the MB shown in /etc/my.cnf? Do we add a third files there (Example: innodb_data_file_path = indb1:200M;indb2:200M;indb3:500MB ) ? TIA Jonathan Wilson System Administrator Cedar Creek Software http://www.cedarcreeksoftware.com Central Texas IT http://www.centraltexasit.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
