Jesper, what may have happened is that InnoDB created the data files, but because memory ran out, it did not have time to update the tablespace header to reflect the size increase by those two data files.
Later when you added yet another data file, it increased the size stored in the tablespace header. The new data you have added has probably gone to those two data files you added first. InnoDB is aware of the data files you specify, but it thinks that the tablespace size is smaller than the combined size of the data files! What to do? The safest solution is to dump your tables and recreate the whole InnoDB tablespace. If you can afford losing the data in the database, then you can experiment by removing 1 or 2 last files from innodb_data_file_path and look if the database crashes in an assertion failure when you insert new data. Regarding your other question about my.cnf parameter, section 2 of http://www.innodb.com/ibman.html is your best help. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB ----- Original Message ----- From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, April 22, 2002 3:35 PM Subject: InnoDB data files created but not used...how to fix ? > Hi! > > A couple of days ago I stopped a MySQL server to change a couple of > parameters in the my.cnf file and to add 2 data files (InnoDB). > > When restarting it, MySQL exited because I'd resized the log file size but > forgot to delete/move the old ones. Secondly, I had another error because I > allocated more memory than ulimit allowed. > I fixed both, restarted, but then it exited because it had created the > first datafile with a size of 0. > I deleted the ibdata file and restarted, and now it created both data files > and started correctly. However, the two new datafiles are not used, and the > data they were supposed to add doesn't show up in a "show table status". > I've later created another data file, and this one works. > > ...so the question is : How to fix those two ? > > Can I just shutdown MySQL, rename them and then re-start MySQL and have the > files re-created, or is there another solution ? > > > /Jesper > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
