以前写的一个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;