Re: Howto check whether really innoDB is used
> 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
Howto check whether really innoDB is used
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? Has anyone a guess on this? I am spending loads of time on this problem... Thnx, Lutz -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! - 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
