Hi all, I've been reading a bit on the innodb table type for mysql here and on the site and some other board sites and just wanted to ask a quick question or two in general about it, as it relates mostly to message boards and compared to myisam. Is the only gotcha in forum code generally the select count(*) queries? It's the only code I've seemed to see here that has to be dealt with differently by setting a field for a counter or something similar. Or are there other things in general I need to watch out for.
Second, the only general thing I can see is an apparent limit on the record size of, I think, something like 32k in fairly recent versions. If there's a post as part of a record that exceeds this limit, does it get truncated (and what fields would get truncated - that specific fields or the last ones in the table), will it crash the server, anyone have any idea of what happens. Or am I reading this all wrong. I'm thinking about trying it out on a friends board for him to take advantage of the row level locking, so I'm also wondering, has anyone run into problems converting back to myisam if it didn't work out to really improve performance. Thx. --------------------------------------------------------------------- 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
