amoeba 问题

孙轩

   安装amoeba并配置好连接数据库后发现使用mysqlslap来做测试会报错
mysqlslap: Cannot run query CREATE TABLE `t1` (intcol1 INT(32) ,charcol1 VARCHAR(12) ERROR : No database selected
mysqlslap -a --only-print 后语句为
DROP SCHEMA IF EXISTS `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
use mysqlslap;
CREATE TABLE `t1` (intcol1 INT(32) ,charcol1 VARCHAR(12);
然后手动连接amoeba后运行
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7611421
Server version: 5.1.45-mysql-amoeba-proxy-3.0.4-BETA Source distribution

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> DROP SCHEMA IF EXISTS `mysqlslap`;
Query OK, 0 rows affected (0.01 sec)

CREATE SCHEMA `mysqlslap`;
mysql> CREATE SCHEMA `mysqlslap`;
Query OK, 1 row affected (0.00 sec)

mysql> use mysqlslap;
Database changed
mysql> CREATE TABLE `t1` (intcol1 INT(32) ,charcol1 VARCHAR(12);
ERROR 1046 (3D000): No database selected





通过实验发现amoeba 里用use `databasename`;有很大机率会失效，并且该语句会在下个语句运行时才运行：

mysql> use mysasdf;
Database changed
mysql> show tables;
ERROR 1049 (42000): Unknown database 'mysasdf'. [error from mysqlServer:127.0.0.1:3305]

amoeba的稳定性不会这么烂吧，我一直还怀疑amoeba把两个语句分两个连接完成了，不过测试默认的mysql库又都是成功的,很费解求高手