MySQL Forums
Forum List  »  InnoDB

Re: Active seconds
Posted by: MURALI MARIAPPAN
Date: September 01, 2015 08:57AM

mysql> SHOW VARIABLES LIKE 'innodb_lock_wait_timeout';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| innodb_lock_wait_timeout | 120 |
+--------------------------+-------+
1 row in set (0.00 sec)

We are using clients with AUTOCOMMIT=0;

For read transactions we are not committing, but we are closing the connection anyway.

Options: ReplyQuote


Subject
Views
Written By
Posted
1912
August 15, 2015 03:07AM
943
August 16, 2015 12:15PM
949
August 17, 2015 12:01AM
836
August 18, 2015 09:27PM
1084
August 26, 2015 11:07PM
927
August 29, 2015 09:24AM
Re: Active seconds
886
September 01, 2015 08:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.