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" ? 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 [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
