MySQL Forums
Forum List  »  InnoDB

my.cnf and innodb_data_file_path character limit problems
Posted by: M B
Date: December 06, 2007 05:22PM

I have a database with the current configuration:

in the my.cnf, the innodb_data_file_path is as follows

innodb_data_file_path = ibdata1:1000M;ibdata2:1000M;ibdata3:1000M;ibdata4:1000M;ibdata5:1000M;ibdata6:1000M;ibdata7:1000M;ibdata8:1000M;ibdata9:1000M;ibdata10:1000M...

This continues up to ibdata261.

The problem i am having is as follows, I need to add more innodb table space, but i can't add any more data files or the autoextend option to the innodb_data_file_path line because i hit the character limit... if i try and add either, i get an error in the log file and mysql won't show up... example error if i try and add autoexted at the end is:

071205 8:01:17 [ERROR] /usr/local/libexec/mysqld: unknown option '--oextend'


and if i try and add another data file it is:

071205 20:10:43 [ERROR] /usr/local/libexec/mysqld: unknown option '--ata262:1000M'


Any suggestions on how i can add table space without taking a massive database outage?

Options: ReplyQuote


Subject
Views
Written By
Posted
my.cnf and innodb_data_file_path character limit problems
3633
M B
December 06, 2007 05:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.