mir ストレージエンジンができたよー(^^/
恒例の名前だけ変えた奴ができました。
[test]> install plugin mir soname 'libmir_engine.so'; Query OK, 0 rows affected (0.10 sec) [test]> create table t1 (c1 int) engine = mir; Query OK, 0 rows affected (0.01 sec) [test]> show create table t1\G *************************** 1. row *************************** Table: t1 Create Table: CREATE TABLE `t1` ( `c1` int(11) DEFAULT NULL ) ENGINE=MIR DEFAULT CHARSET=utf8 1 row in set (0.00 sec)
show enginesにも出てる。
[information_schema]> show engines; +------------+---------+----------------------------------------------------------------+--------------+-----+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +------------+---------+----------------------------------------------------------------+--------------+-----+------------+ | InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | | MIR | YES | Mir storage engine | NO | NO | NO | | FEDERATED | YES | Federated MySQL storage engine | NO | NO | NO | | ARCHIVE | YES | Archive storage engine | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO | +------------+---------+----------------------------------------------------------------+--------------+-----+------------+ 9 rows in set (0.00 sec)
さて次はちゃんとmyisamをpluggableにw