> Hi folks, > > I just upgraded to mysql-max-3.23.52-1 because I realized that the > standard mysql does not support transactions. I still have a transaction > problem with many clients reading the same data (every read causes an > update on one column so that the read value should be unique in the > whole cluster) in a cluster even with setting transaction isolation to > TRANSACTION_SERIALIZABLE. How can I check that really innoDB is used as > I read that this table will be used as MyISAM when mysql is not > supporting it?
Try: SHOW TABLE STATUS FROM yourDBName; InnoDB should be listed as the table type. This is also handy for seeing how much space is being used... Josh > Has anyone a guess on this? I am spending loads of time on this > problem... > > Thnx, > > Lutz --------------------------------------------------------------------- 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
