Stress Testing for MYSQL

Welcome to the Linux community forum, and interact with 2 million technical staff. 1. Install supersmack [url] vegan. nettonysupersmack [url] and summarize the problems I encountered. Remember to copy libmysqlclient. so.16 to usrlib, so you do not need to change the MakeFile when making.

Welcome to the Linux community forum and interact with 2 million technical staff> go to 1. Install supersmack [url] http://vegan.net/tony/supersmack/#/url]. The installation process and summary of problems encountered in the process are all here. Remember to copy libmysqlclient. so.16 to/usr/lib, so that MakeFile does not need to be changed during make.

Welcome to the Linux community forum and interact with 2 million technicians>

1. Install supersmack

[Url] http://vegan.net/tony/supersmack/#/url]

The installation process and summary of the problems I encountered are all here.

Remember to copy libmysqlclient. so.16 to/usr/lib, so that you do not need to change the MakeFile file during make.

[Root @ localhost super-smack-1.3] # cp/usr/local/mysql/libmysqlclient. so.16/usr/lib

I encountered the following problems:

Error while loading shared libraries: libmysqlclient. so.16: cannot open shared object file: No such file or directory

I saw this post from Beijing WOLF:

[Url] http://bbs.chinaunix.net/archiver? Tid-638662.html [/url]

[Root @ localhost super-smack-1.2] #./configure -- with-mysql

Configure: error: installation or configuration problem: C ++ compiler cannot create executables.

C ++ compiler Not Installed

[Root @ localhost rpmpackage] # rpm-ivh libc-client-2004g-2.2.1.i386.rpm

Preparing... ######################################## ### [100%]

1: libc-client ##################################### ###### [100%]

[Root @ localhost rpmpackage] # rpm-ivh libc-client-devel-2004g-2.2.1.i386.rpm

Preparing... ######################################## ### [100%]

1: libc-client-devel ################################### ####### [1, 100%]

[Root @ localhost rpmpackage] # rpm-ivh libstdc ++-devel-4.1.1-52.el5.i386.rpm

Preparing... ######################################## ### [100%]

1: libstdc ++-devel ################################### ####### [1, 100%]

[Root @ localhost rpmpackage] # rpm-ivh gcc-c ++-4.1.1-52. el5.i386. rpm

Preparing... ######################################## ### [100%]

1: gcc-c ++ ################################### ####### [1, 100%]

[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!

Then make; make install

Other questions

[Url] http://vegan.net/tony/supersmack/faq.php#/url]

2. Perform actual tests.

Copy the sample file.

[Root @ localhost super-smack-1.3] # cp-r smacks // usr/local/bin/

Change the user name and password to your own

The default value is to test the performance of the MYISAM table.

[Root @ localhost smacks] # super-smack-d mysql select-key.smack 10 1000

Error running query select count (*) from http_auth: Table 'test. http_auth 'doesn' t exist

Creating table 'HTTP _ auth'

Loading data from file '/var/smack-data/words. dat 'into table 'HTTP _ auth'

Table http_auth is now ready for the test

Query Barrel Report for client smacker1

Connect: max = 156 ms min = 0 ms avg = 21 ms from 10 clients

Query_type num_queries max_time min_time q_per_s

Select _ index 20000 0 0 16299.96

[1] [2]