Hi! ----- Original Message ----- From: "PR" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, September 05, 2002 5:31 PM Subject: innodb questions about message board apps
> 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. There has been discussion about InnoDB tables in vBulletin discussion forums. vBulletin runs on MySQL. COUNT(*) is the main problem which can be partially solved using SHOW TABLE STATUS to determine an approximate number of rows. Also deadlocks can happen. Jelsoft should tune vBulletin code so that it would be better suited for transactional tables. > 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. InnoDB supports BLOBs up to 4 GB in size. > 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. Not that I heard of. > Thx. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query --------------------------------------------------------------------- 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
