以前写的一个NOSQL服务的操作日志记录. 由于上个月VPS被重置，导致部署的文件都没有了，把相关的操作日志放在这里，备忘。
xCache 是一个支持MYSQL协议的NoSQL服务，目的是提供一个数据结构服务器框架，支持动态加载自定义的数据结构，
像REDIS只支持固定的几种数据结构，xcache 支持多种数据结构（map/hash/list），也支持从外部加载数据结构引擎模块插件。
mysql> create(table, testtb,map);
Query OK, 1 row affected
mysql> test.testtb.insert(kk,111111111);
1399 - can not find table testtb
mysql> show(tables);
1399 - can not find table b
mysql> create(table, testtb,map);
Query OK, 1 row affected
mysql> test.testtb.insert(kk,111111111);
1399 - can not find table testtb
mysql> show(tables);
+---------+------+------+
| table | type | size |
+---------+------+------+
| testtb | map | 0 |
+---------+------+------+
1 row in set
mysql> create(table, testtb,map);
Query OK, 1 row affected
mysql> show(tables);
+---------+------+------+
| table | type | size |
+---------+------+------+
| testtb | map | 0 |
+---------+------+------+
1 row in set
mysql> test.testtb.insert(kk,111111111);
1399 - can not find table testtb
mysql> show(tables);
+---------+------+------+
| table | type | size |
+---------+------+------+
| testtb | map | 0 |
+---------+------+------+
1 row in set
mysql> test.testtb.insert(kk, 111111111);
1399 - can not find table testtb
mysql> testtb.insert(kk, 111111111);
2003 - Can't connect to MySQL server on '192.168.132.128' (10061)
mysql> test.testtb.insert(kk, 111111111);
2003 - Can't connect to MySQL server on '192.168.132.128' (10061)
mysql> create(table, testtb,map);
Query OK, 1 row affected
mysql> create(table,testtb,map);
Query OK, 1 row affected
mysql> show(tables);
+---------+------+------+
| table | type | size |
+---------+------+------+
| testtb | map | 0 |
| testtb | map | 0 |
+---------+------+------+
2 rows in set
mysql> test.testtb.insert(kk, 111111111);
Query OK, 1 row affected
mysql> show(tables);
+---------+------+------+
| table | type | size |
+---------+------+------+
| testtb | map | 0 |
| testtb | map | 1 |
+---------+------+------+
2 rows in set
mysql> test.testtb.insert(k222, 22222222222);
Query OK, 1 row affected
mysql> show(tables);
+---------+------+------+
| table | type | size |
+---------+------+------+
| testtb | map | 0 |
| testtb | map | 2 |
+---------+------+------+
2 rows in set
mysql> test.testtb.find(*);
+------+--------------+
| key | value |
+------+--------------+
| k222 | 22222222222 |
| kk | 111111111 |
+------+--------------+
2 rows in set
mysql> test.testtb.size();
+------+
| size |
+------+
| 2 |
+------+
1 row in set
mysql> test.testtb.max_size();
+--------------------+
| max_size |
+--------------------+
| 384307168202282325 |
+--------------------+
1 row in set
mysql> test.testtb.empty();
+-------+
| empty |
+-------+
| 0 |
+-------+
1 row in set
mysql> test.testtb.erase(kk);
Query OK, 1 row affected
mysql> test.testtb.find(*);
+------+--------------+
| key | value |
+------+--------------+
| k222 | 22222222222 |
+------+--------------+
1 row in set
mysql> create(table, testtb,map);
Query OK, 1 row affected
mysql> show(tables);
+-----------+------+------+
| table | type | size |
+-----------+------+------+
| testtb | map | 0 |
+-----------+------+------+
1 row in set
mysql> create(table, testtb,map);
Query OK, 1 row affected
mysql> show(tables);
+-----------+------+------+
| table | type | size |
+-----------+------+------+
| testtb | map | 0 |
+-----------+------+------+
1 row in set
mysql> create(table, testtb,map);
Query OK, 1 row affected
mysql> show(tables);
+--------+------+------+
| table | type | size |
+--------+------+------+
| testtb | map | 0 |
+--------+------+------+
1 row in set
mysql> test.testtb.find(*);
Empty set
mysql> test.testtb.insert(k222, 22222222222);
Query OK, 1 row affected
mysql> test.testtb.insert(k11,111111111111);
Query OK, 1 row affected
mysql> test.testtb.insert(k2,22);
Query OK, 1 row affected
mysql> test.testtb.find(*);
+------+--------------+
| key | value |
+------+--------------+
| k11 | 111111111111 |
| k2 | 22 |
| k222 | 22222222222 |
+------+--------------+
3 rows in set
mysql>
mysql> show(tables);
+--------+------+------+
| table | type | size |
+--------+------+------+
| testtb | map | 3 |
+--------+------+------+
1 row in set
mysql> test.testtb.find(k2);
+----+
| k2 |
+----+
| 22 |
+----+
1 row in set
mysql> test.testtb.find(k11);
+--------------+
| k11 |
+--------------+
| 111111111111 |
+--------------+
1 row in set
mysql> test.testtb.find(k222);
+--------------+
| k222 |
+--------------+
| 22222222222 |
+--------------+
1 row in set
mysql> create(table, testtb,map);
1399 - can not parase Cmd create
mysql> create(table, testtb,map);
1399 - can not parase Cmd create
mysql> create(table, testtb,map);
Query OK, 1 row affected
mysql> show(tables);
+--------+------+------+
| table | type | size |
+--------+------+------+
| testtb | map | 0 |
+--------+------+------+
1 row in set
mysql> test.testtb.insert(k2,22);
Query OK, 1 row affected
mysql> test.testtb.insert(k3, 22dsdsds );
Query OK, 1 row affected
mysql> test.testtb.find(*);
+-----+----------+
| key | value |
+-----+----------+
| k2 | 22 |
| k3 | 22dsdsds |
+-----+----------+
2 rows in set
mysql> test.testtb.insert(k4, "ddsf dfgfdg ");
Query OK, 1 row affected
mysql> test.testtb.find(*);
+-----+--------------+
| key | value |
+-----+--------------+
| k2 | 22 |
| k3 | 22dsdsds |
| k4 | ddsf dfgfdg |
+-----+--------------+
3 rows in set
mysql> create(table, testtb,map);
Query OK, 1 row affected
mysql> test.testtb.insert(k4, "ddsf dfgfdg ");
Query OK, 1 row affected
mysql> test.testtb.insert(k2,22);
Query OK, 1 row affected
mysql> test.testtb.find(*);
+-----+--------------+
| key | value |
+-----+--------------+
| k2 | 22 |
| k4 | ddsf dfgfdg |
+-----+--------------+
2 rows in set
mysql> testtb.insert(k5, "5555");
2003 - Can't connect to MySQL server on '192.168.132.128' (10061)
mysql> use(test);
Database changed
mysql> show(tables);
Empty set
mysql> create(table, testtb,map);
Query OK, 1 row affected
mysql> show(tables);
+--------+------+------+
| table | type | size |
+--------+------+------+
| testtb | map | 0 |
+--------+------+------+
1 row in set
mysql> testtb.insert(k5, "5555");
2003 - Can't connect to MySQL server on '192.168.132.128' (10061)
mysql> show(tables);
Empty set
mysql> use(test);
Database changed
mysql> show(tables);
Empty set
mysql> create(table, testtb,map);
Query OK, 1 row affected
mysql> testtb.insert(k5, "5555");
Query OK, 1 row affected
mysql> test.testtb.find(*);
+-----+-------+
| key | value |
+-----+-------+
| k5 | 5555 |
+-----+-------+
1 row in set
mysql> testtb.insert(k1, "111 22222222");
Query OK, 1 row affected
mysql> testtb.insert(k2, "2222222 fdddd");
Query OK, 1 row affected
mysql> testtb.insert(k3, "23333333333333");
Query OK, 1 row affected
mysql> test.testtb.find(*);
+-----+----------------+
| key | value |
+-----+----------------+
| k1 | 111 22222222 |
| k2 | 2222222 fdddd |
| k3 | 23333333333333 |
| k5 | 5555 |
+-----+----------------+
4 rows in set
mysql> test.testtb.de(*);
1399 - fun not allowed de
mysql>
create(table, t_test);
show databases;
use test;
create(table, t_test);
show databases;
show databases;
use test;
create(table, t_test);
create(table, t_test);
create(table, t_test, map);
show tables;
t_test.insert(wwwwwww, rrrrrrrrr);
t_test.find(*);
show tables;
show engines;
show engines map;
INSTALL PLUGIN mapa SONAME libtest.so;
show engines map;
show engines;
create table t_test1 map-a;