are you familiar with the different MySQL table types? they are: MyISAM BDB Gemini InnoDB
but InnoDB is the most robust, supports row-level locking, ACID transactions (no dirty reads), and foreign key restraints... read up on it here: http://www.innodb.com but InnoDB does multi-versioning, so be sure to read carefully Ki Mien wrote: > Hi all, > > We need to prevent Dirty Reading. > > How can we perform transaction isolation in mySQL? Are the following: >TRANSACTION_SERIALIZABLE, TRANSACTION_REPEATABLE_READ, TRANSACTION_READ_COMMITTED, >TRANSACTION_READ_UNCOMMITTED, TRANSACTION_NONE supported by MySQL? Or has anyone >tried any other alternatives? > > cheers, > Ki Mien > > ------------------------------------------------------------------------ > Take part in the Penning on Squares Chinese Essay Writing Contest. > Submit your masterpieces or vote for your favourite works, and win attractive prizes. > Be there or be SQUARE! > http://sea.litcontest.lycosasia.com > > cOntact @ Lycos <http://contact.lycosasia.com> > = 20MB for email and filestore + lots of other goodies... > > --------------------------------------------------------------------- > 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
