Tag Archives: innodb

MySQL: Unknown table engine ‘InnoDB’

mysql> show innodb status
Unknown table engine ‘InnoDB’

I got this message when tried to allocate a huge size of memory on remote server,
innodb_buffer_pool_size = 8000M

after i have looked for memory:
free -m
and have found that there are only 4gb,

change option to:
innodb_buffer_pool_size = 2000M

and mysql has been start fine with innodb.

MySQL: Transactions in MyISAM and InnoDB

Test

CREATE TABLE `t01` (
`column_of_t01` int(11) DEFAULT NULL
) ENGINE=MyISAM;

CREATE TABLE `t02` (
`column_of_t02` int(11) DEFAULT NULL
) ENGINE=InnoDB;
start transaction;
insert into t01(column_of_t01) values(666);
insert into t02(column_of_t02) values(666);
select * from t01;
select * from t02;
rollback;
select * from t01;
select * from t02;

Continue reading MySQL: Transactions in MyISAM and InnoDB