Page 1 of 1
Check active transactions
Posted: Thu 25 Jul 2013 09:26
by miguelenguica
Hi.
Is there a way to check the number of active transactions (on the database, not on the local UniConnection component) at any given time, using MySQL + UniConnection?
Thanks.
Re: Check active transactions
Posted: Fri 26 Jul 2013 09:30
by DemetrionQ
Hello.
TUniConnection allows to retrieve the information about the state of the current connection only. As for questions concerning retrieving information about all transactions for all connections to the server, please forward them to MySQL support.
If you need to check if the table is locked, you can do this using the 'SHOW OPEN TABLES' SQL command (
http://dev.mysql.com/doc/refman/5.1/en/ ... ables.html ), for example:
Code: Select all
SHOW OPEN TABLES WHERE in_use <> 0 AND `Table` = 'YourTable' AND `Database` = 'YourDatabase';