blob: bcf1dad68060225299a817435978e6ff3d8148e9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
install plugin innodb soname 'ha_innodb';
Warnings:
Warning 1105 Cannot enable tc-log at run-time. XA features of InnoDB are disabled
select engine,support,transactions,xa from information_schema.engines where engine='innodb';
engine support transactions xa
InnoDB YES YES NO
create table t1 (a int) engine=innodb;
start transaction;
insert t1 values (1);
insert t1 values (2);
commit;
show status like 'Handler_prepare';
Variable_name Value
Handler_prepare 0
drop table t1;
uninstall plugin innodb;
|
