Tuesday, April 12, 2011

just installed mysql-5.6.2-labs-innodb-memcached on linux 64bits

After I installed "mysql-5.6.2-labs-innodb-memcached.tar.gz" on linux 32bits. Could not restart mysql server (error something after start Mysql), so tested it on linux 64bits. It's OK.
# mkdir build
# cd build
# CC="gcc -fPIC" cmake ../mysql-5.6.2-labs-innodb-memcached
# make
# make install
# cd /usr/local/mysql
.
.
# bin/mysqld_safe --user=mysql &
# bin/mysql < scripts/innodb_memcached_config.sql

mysql> INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';

mysql> show plugins;
+--------------------------+--------+--------------------+-----------------+---------+
| Name | Status | Type | Library | License |
+--------------------------+--------+--------------------+-----------------+---------+
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL |
| mysql_old_password | ACTIVE | AUTHENTICATION | NULL | GPL |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL |
| INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_PAGE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_PAGE_LRU | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_METRICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_TABLES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_TABLESTATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_FIELDS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_FOREIGN | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_FOREIGN_COLS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL |
| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
| daemon_memcached | ACTIVE | DAEMON | libmemcached.so | GPL |
+--------------------------+--------+--------------------+-----------------+---------+
then test to Run "memcapable" from https://launchpad.net/libmemcached but have to install memcached http://memcached.org before:
# memcapable
ascii quit [pass]
ascii version [pass]
ascii verbosity [pass]
ascii set [pass]
ascii set noreply [pass]
ascii get [pass]
ascii gets [pass]
ascii mget [pass]
ascii flush [pass]
ascii flush noreply [pass]
ascii add [pass]
ascii add noreply [pass]
ascii replace [pass]
ascii replace noreply [pass]
ascii cas [pass]
ascii cas noreply [pass]
ascii delete [pass]
ascii delete noreply [pass]
ascii incr [pass]
ascii incr noreply [pass]
ascii decr [pass]
ascii decr noreply [pass]
ascii append [pass]
ascii append noreply [pass]
ascii prepend [pass]
ascii prepend noreply [pass]
ascii stat [pass]
binary noop [pass]
binary quit [pass]
binary quitq [pass]
binary set [pass]
binary setq [pass]
binary flush [pass]
binary flushq [pass]
binary add [pass]
binary addq [pass]
binary replace [pass]
binary replaceq [pass]
binary delete [pass]
binary deleteq [pass]
binary get [pass]
binary getq [pass]
binary getk [pass]
binary getkq [pass]
binary incr [pass]
binary incrq [pass]
binary decr [pass]
binary decrq [pass]
binary version [pass]
binary append [pass]
binary appendq [pass]
binary prepend [pass]
binary prependq [pass]
binary stat [pass]

# ./bin/mysql test

mysql> select * from demo_test;
+------+------+----------------------+------+-------------------+------+------+----------+------+------+------+
| cx | cy | c1 | cz | c2 | ca | CB | c3 | cu | c4 | C5 |
+------+------+----------------------+------+-------------------+------+------+----------+------+------+------+
| NULL | NULL | test_binary_add | NULL | þÊ­Þï¾­Þ | NULL | NULL | 0 | NULL | 103 | NULL |
| NULL | NULL | test_binary_addq | NULL | þÊ­Þï¾­Þ | NULL | NULL | 0 | NULL | 104 | NULL |
| NULL | NULL | test_binary_replace | NULL | þÊ­Þï¾­Þ | NULL | NULL | 0 | NULL | 115 | NULL |
| NULL | NULL | test_binary_replaceq | NULL | þÊ­Þï¾­Þ | NULL | NULL | 0 | NULL | 126 | NULL |
| NULL | NULL | test_binary_get | NULL | test_binary_get | NULL | NULL | 0 | NULL | 129 | NULL |
| NULL | NULL | test_binary_getq | NULL | test_binary_getq | NULL | NULL | 0 | NULL | 130 | NULL |
| NULL | NULL | test_binary_getk | NULL | test_binary_getk | NULL | NULL | 0 | NULL | 131 | NULL |
| NULL | NULL | test_binary_getkq | NULL | test_binary_getkq | NULL | NULL | 0 | NULL | 132 | NULL |
| NULL | NULL | test_binary_incr | NULL | 9 | NULL | NULL | 57580232 | NULL | 142 | NULL |
| NULL | NULL | test_binary_incrq | NULL | 9 | NULL | NULL | 57580232 | NULL | 152 | NULL |
| NULL | NULL | test_binary_decr | NULL | 0 | NULL | NULL | 57580232 | NULL | 163 | NULL |
| NULL | NULL | test_binary_decrq | NULL | 0 | NULL | NULL | 57580232 | NULL | 174 | NULL |
| NULL | NULL | test_binary_append | NULL | hello world | NULL | NULL | 0 | NULL | 176 | NULL |
+------+------+----------------------+------+-------------------+------+------+----------+------+------+------+

No comments: