Dear Dan, > I have a database that, I now realize, could use the benefits of > row-locking and non-blocking SELECTs. So, I guess I need to change over > to InnoDB tables. How do I convert my existing data structures (and the > data they contain) into InnoDB tables?
ALTER TABLE mytable TYPE=innodb > Also, Is there anything that MyISAM tables support (query-wise, like > INSERT DELAYED), that is not supported by InnoDB that I might need to > look out for in my application(s)? Yep. "INSERT DELAYED" will not work with InnoDB, and this applies to some of the other MySQL extensions that function as workarounds for the fact that MyISAM tables cannot handle row level locking (LOW_PRIORITY etc.). You will get error 1031 if you use those extensions with InnoDB tables. Possible problems can derive from INSERT, UPDATE, DELETE, and even SELECT, so you better check the manual (http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Da ta_Manipulation) for MySQL extensions with these DML words. Use the SQL command line to find out which of these will still work with InnoDB and which of these won't. (This is not as clear as one might think, e. g. SELECT HIGH_PRIORITY still works, INSERT DELAYED doesn't work, INSERT LOW_PRIORITY _does_ work!) HTH! -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Dan Cumpian" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, December 08, 2002 10:38 PM Subject: MyISAM -> InnoDB > Hello, > > I have a database that, I now realize, could use the benefits of > row-locking and non-blocking SELECTs. So, I guess I need to change over > to InnoDB tables. How do I convert my existing data structures (and the > data they contain) into InnoDB tables? > > Also, Is there anything that MyISAM tables support (query-wise, like > INSERT DELAYED), that is not supported by InnoDB that I might need to > look out for in my application(s)? > > Thanks, > Dan Cumpian > > > > > --------------------------------------------------------------------- > 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
