|
1、安装supersmack http://vegan.net/tony/supersmack/ 安装过程以及我中间遇到问题的总结都在这里。 之前记得把libmysqlclient.so.16拷贝到/usr/lib中去，这样make 的时候不用改MakeFile文件。 [root@localhost super-smack-1.3]# cp /usr/local/mysql/libmysqlclient.so.16 /usr/lib [root@localhost rpmpackage]# cd ../sourcepackage/super-smack-1.2 [root@localhost super-smack-1.2]# ./configure --with-mysql loading cache ./config.cache checking for a BSD compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... yes ... updating cache ./config.cache creating ./config.status creating Makefile creating src/Makefile creating config.h Building with the following options: MySQL Support..................... yes PostgreSQL Support................ no Oracle Support.................... no If this is not what you intended, please re-run configure. Thanks for using super-smack! 然后make;make install 2、进行实际测试。 拷贝示例文件。 [root@localhost super-smack-1.3]# cp -r smacks/ /usr/local/bin/ 修改用户名和密码为自己的 [root@localhost smacks]# super-smack -d mysql select-key.smack 10 10000 10 是连接客户的数目，每个客户有10000次轮询。 默认是测试MYISAM表的性能。 mysql> alter table http_auth engine myisam; Query Barrel Report for client smacker1 connect: max=358ms min=0ms avg= 93ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 36678.87 Query Barrel Report for client smacker1 connect: max=2ms min=0ms avg= 0ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 36312.06 下来测试innodb表，修改表类型 mysql> alter table http_auth engine innodb; Query Barrel Report for client smacker1 connect: max=50ms min=0ms avg= 16ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 39852.46 Query Barrel Report for client smacker1 connect: max=8ms min=0ms avg= 3ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 38331.63 接下来内存类型 mysql> alter table http_auth engine memory; Query Barrel Report for client smacker1 connect: max=243ms min=0ms avg= 26ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 45608.34 Query Barrel Report for client smacker1 connect: max=139ms min=0ms avg= 55ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 43428.97 接下来测试集群的 mysql> alter table http_auth engine ndb; Query Barrel Report for client smacker1 connect: max=0ms min=0ms avg= 0ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 19831.67 Query Barrel Report for client smacker1 connect: max=2ms min=0ms avg= 0ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 20116.44 这个测试结果怎么表名MYISAM表的SELECT比INNODB的还差，MEMORY最快，毕竟是用内存。 看一下update的。 [root@localhost smacks]# super-smack -d mysql update-select.smack 10 10000 (责任编辑：IT) |