Re: Innodb row level locking

[niranjan joshi]

Hi Vinod
Thanks for ur replay i am pasting output of command u want


mysql> show create table tab1;
+-------+-----------------------------------------------------------------------
------------------+
| Table | Create Table
|
+-------+-----------------------------------------------------------------------
------------------+
| tab1 | CREATE TABLE `tab1` (
`i` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+-----------------------------------------------------------------------
------------------+
1 row in set (0.00 sec)


mysql> show variables like 'innodb_locks_unsafe_for_binlog';
+--------------------------------+-------+
| Variable_name | Value |
+--------------------------------+-------+
| innodb_locks_unsafe_for_binlog | OFF |
+--------------------------------+-------+
1 row in set (0.00 sec)