Chinaunix

标题: 渴望与有mysql innodb+memcache开发经验的人交流、学习 [打印本页]

作者: mickey_51 时间: 2012-12-11 18:12
标题: 渴望与有mysql innodb+memcache开发经验的人交流、学习
本帖最后由 mickey_51 于 2012-12-13 10:25 编辑

在 mysql-5.6.8-rc/plugin/innodb_memcached/innodb_memcache/scripts/innodb_memcached_config.sql的文件中添加几个规则
1. 主键为int 其他为varchar（失败）
INSERT INTO innodb_memcache.containers VALUES ("demo", "test", "demo","c1", "c2",  "c3", "c4", "c5", "PRIMARY");
CREATE TABLE test.demo (c1 int,c2 VARCHAR(1024),c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))ENGINE = INNODB;

2. 主键为varchar 其他为int（失败）
INSERT INTO innodb_memcache.containers VALUES ("demo1", "test", "demo1","c1", "c2",  "c3", "c4", "c5", "PRIMARY");
CREATE TABLE test.demo1 (c1 VARCHAR(32),c2 int,c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))ENGINE = INNODB;

3. 主键为int 其他为int（失败）
INSERT INTO innodb_memcache.containers VALUES ("demo2", "test", "demo2","c1", "c2",  "c3", "c4", "c5", "PRIMARY");
CREATE TABLE test.demo2 (c1 int,c2 int,c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))ENGINE = INNODB;

4. 主键为varchar 其他为varchar（成功）
INSERT INTO innodb_memcache.containers VALUES ("demo3", "test", "demo3","c1", "c2",  "c3", "c4", "c5", "PRIMARY");
CREATE TABLE test.demo3 (c1 VARCHAR(32),c2 VARCHAR(1024),c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))ENGINE = INNODB;

5. 主键为varchar 其他为varchar date（失败）
INSERT INTO innodb_memcache.containers VALUES ("demo4", "test", "demo4","c1", "c2,createdate",  "c3", "c4", "c5", "PRIMARY");
CREATE TABLE test.demo4 (c1 VARCHAR(32),c2 VARCHAR(1024),createdate datetime NOT NULL,c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))ENGINE = INNODB;

难道这版本就只能使用varchar char来作为表的字段了吗？

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)