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;
Warnings:
Warning	1620	Plugin is busy and will be uninstalled on shutdown