Hello everyone, I have a question with regards to the InnoDB data files. I have the following in my.ini file.
innodb_data_file_path = ibdata1:200M innodb_data_home_dir = c:/innodb_data I just want to know the following. Does it mean that I have 200Mb allocated space to store all the InnoDB data in? What happens if I exceed 200Mb? Can I alter the size in the future, once I define a size for it? Also, if I had innodb_data_file_path = ibdata1:200M; ibdata2:200M And my data exceeded 200M, would the rest of the data transfer over to data2? What is the best configuration, having multiple datafiles that are small in size or have one datafile which will be big. Thanks, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 9:59 AM To: Demirchyan Oganes-AOD098 Subject: Re: Mysql Innodb data files Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hello everyone, I have a question with regards to the InnoDB data files. I have the following in my.ini file. innodb_data_file_path = ibdata1:200M innodb_data_home_dir = c:/innodb_data I just want to know the following. Does it mean that I have 200Mb allocated space to store all the InnoDB data in? What happens if I exceed 200Mb? Can I alter the size in the future, once I define a size for it? Also, if I had innodb_data_file_path = ibdata1:200M; ibdata2:200M And my data exceeded 200M, would the rest of the data transfer over to data2? What is the best configuration, having multiple datafiles that are small in size or have one datafile which will be big. Thanks, Oganes Demirchyan Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] --------------------------------------------------------------------- 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
