The added complexity frightens me a little. It seems a little black-boxish to me right now. I am sure it is only a matter of getting use to and working with the architecture. The idea of a separate table-handler in the RDBMS seems very foreign when you come from the Oracle world. However, I can see where this will also allow for a lot of flexibility in design later on (anyone working on an XML data handler for MySQL?). Thanks for your comments. I think I feel comfortable enough now to proceede with using MySQL and InnoDB. Regards, Aaron
-----Original Message----- From: Philip Molter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 11:24 AM To: Heikki Tuuri Cc: [EMAIL PROTECTED] Subject: Re: innoDB confusion On Tue, Jan 15, 2002 at 08:17:53PM +0200, Heikki Tuuri wrote: : Hi! : : "Weaver, Walt" wrote in message ... : >Do a "show table status" at the mysql prompt. Under "type" you should see : >InnoDB. : : Yes, and in really problematic situations, where you have lost your .frm : files, for example, you can use innodb_table_monitor as explained in the : InnoDB online manual. This brings up an interesting point. If you've lost your .frm files, are you totally screwed, or does InnoDB contain enough information to restore those .frm files? It's not a big deal if it doesn't. That's why God gave us backups, after all. I know oftentimes, when we're doing testing with very large tables, rather than go through the hassle of cleaning stuff out, we just drop the .frm files, which causes InnoDB to "lose" the tables. Then we can recreate just fine. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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 --------------------------------------------------------------------- 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