在用tpcc-mysql做压测的过程当中,碰到这样一个问题
加载数据是报错
./tpcc_load localhost tpcc1000 root "mysql123" 1000
./tpcc_load: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory
当时我socket文件没在/var/lib/mysql下,我还以为是这个原因,随后我做了个软连接,结果还是一样的错
执行./tpcc_load --help
./tpcc_load: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory
还是同样的错,表示无语啊!
从上面的提示可以知道个大概,加载共享库文件的时候找不到文件libmysqlclient.so.18
于是执行了一下
locate libmysqlclient.so.18
/mnt/mysql/lib/libmysqlclient.so.18
/mnt/mysql/lib/libmysqlclient.so.18.1.0
/root/soft/mysqlsoft/mysql-5.6.24/libmysql/libmysqlclient.so.18
/root/soft/mysqlsoft/mysql-5.6.24/libmysql/libmysqlclient.so.18.1.0
加上文件共享目录
vi /etc/ld.so.conf
include ld.so.conf.d/*.conf
/root/soft/mysqlsoft/mysql-5.6.24/libmysql
然后使用ldconfig使之生效
[root@iZ236u31846Z tpcc-mysql]# ./tpcc_load --help
*************************************
*** ###easy### TPC-C Data Loader ***
*************************************
usage: tpcc_load [server] [DB] [user] [pass] [warehouse]
OR
tpcc_load [server] [DB] [user] [pass] [warehouse] [part] [min_wh] [max_wh]
* [part]: 1=ITEMS 2=WAREHOUSE 3=CUSTOMER 4=ORDERS
接下来初始化数据库并加载数据
当执行这个命令的时候又出了问题,包一下错误
./tpcc_load localhost tpcc root "mysql123" 1000
1197, HY000, Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again
Retrying ....
Loading Stock Wid=1
解决办法:
增大max_binlog_cache_size=100M
修改/etc/my.cnf
重启mysqld
阅读(2016) | 评论(0) | 转发(0) |