Ubuntu下MySQL性能测试之super-smack

1.安装MySQL
不要使用apt-get install mysql-server-5.x
使用编译安装或者解压安装MySQL

2.安装配置super-smack
wget http://vegan.net/tony/supersmack/super-smack-1.3.tar.gz
tar zxvf super-smack-1.3.tar.gz
cd super-smack-1.3

3.修改源代码,不然会在安装过程中报错
cd src
nano dictionary.h
添加
#include <cstring>

4.安装flex
apt-get install flex

5.安装Yacc
wget http://invisible-island.net/datafiles/release/byacc.tar.gz
tar zxvf byacc.tar.gz
cd byacc
./configure
make
make install

6.配置
./configure --prefix=/usr/local/supersmack --with-mysql --with-mysql-lib=/usr/local/mysql/lib --with-mysql-include=/usr/local/mysql/include

7.复制make所需
cp /usr/local/mysql/libmysqlclient.so.16 /usr/lib

8.make
没有出现错误则配置成功

9.make install

10.配置测试
cp /usr/share/smacks/select-key.smack /usr/local/supersmack/bin/select-key.smack
cp /usr/share/smacks/update-select.smack /usr/local/supersmack/bin/update-select.smack

修改数据库用户名和密码
nano /usr/local/supersmack/bin/select-key.smack
nano /usr/local/supersmack/bin/update-select.smack
1)word.data修改为http_auth.data
2)gen_data_file "/usr/local/supersmack/bin/gen-data -n 90000 -f %12-12s%n       %25-25s %n      %d";
中","用TAB
3)delim用TAB替换","

11.测试
测试MYISAM表的性能
/usr/local/supersmack/bin/super-smack -d mysql /usr/local/supersmack/bin/select-key.smack 10 1000
/usr/local/supersmack/bin/super-smack -d mysql /usr/local/supersmack/bin/select-key.smack 100 1000
/usr/local/supersmack/bin/super-smack -d mysql /usr/local/supersmack/bin/update-select.smack 10 1000
/usr/local/supersmack/bin/super-smack -d mysql /usr/local/supersmack/bin/update-select.smack 100 1000
测试innodb 表
mysql -uroot -proot
use test
alter table http_auth engine innodb;
/usr/local/supersmack/bin/super-smack -d mysql /usr/local/supersmack/bin/select-key.smack 10 1000
/usr/local/supersmack/bin/super-smack -d mysql /usr/local/supersmack/bin/select-key.smack 100 1000
/usr/local/supersmack/bin/super-smack -d mysql /usr/local/supersmack/bin/update-select.smack 10 1000
/usr/local/supersmack/bin/super-smack -d mysql /usr/local/supersmack/bin/update-select.smack 100 1000

12.测试结果
Query Barrel Report for client smacker1
connect: max=6ms  min=1ms avg= 3ms from 100 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    200000  5       0       36085.05

如果不能生成测试数据手动导入测试数据
/usr/local/supersmack/bin/gen-data -n 90000 -f %12-12s%n,%25-25s,%n,%d > /var/smack-data/http_auth.dat
mysqlimport -L -uroot -proot test /var/smack-data/http_auth.dat