Benoit, ----- Original Message ----- From: "Benoit St-Jean" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, March 21, 2003 4:54 AM Subject: Stopping InnoDb recovery and fixed columns
> I recently had a bad experience with a "feature" of > InnoDb. Whenever the server crashes, on the next > startup InnoDb detects that the server ended > abnormally and performs a > repair/rollback/magic/whatever before allowing you to > connect to the server. > > Unfortunately, I had to create an index on a 45 > million rows table and the server crashed (after 36 > hours!). When the server was restarted, guess what? > I had to wait for a zillion years again because InnoDb > was "un-doing" that index creation. Is there any way > I could have told the server "just forget it and DROP > that index" ? please see http://www.innodb.com/ibman.html#Forcing_recovery about ALTER TABLE. CREATE INDEX is internally an ALTER TABLE. > Secondly, how can I tell MySQL **NOT** to silently > convert CHAR(x) to VARCHAR(x) columns when I know that > the data is that column is ALWAYS going to be of a > fixed length (for instance, a social security number)? > I have a few tables with that problem/feature and > because of that, instead of having fixed format rows I > have dynamic ones. In a table with a few millions > rows, it can make a big difference! > > tia > > filter: mysql, sql, table, database > > ===== > ------------------------- > Benoit St-Jean Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-4.0 from http://www.mysql.com sql query > [EMAIL PROTECTED] > Yahoo! Messenger: bstjean > http://cactus.swiki.net > ------------------------- > > --------------------------------------------------------------------- > 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
