HP 5992-4755 - Manual (Page 14)

Table 4 SysBench Options
Description Value SysBench option
OLTP emulates operations that a read database would perform. Other
options are CPU, threads, mutex, memory, and fileio. oltp --test
Sets the number of rows in the test table. 1000000 --oltp-table-size
Sets the value for whether the storage engine used is transactional. yes --mysql-engine-trx
Determines how transactions are performed. Options are simple (very
simple SELECTs), complex (transactional), and nontrx (non-transactional). complex --oltp-test-mode
Sets whether the UPDATE/DELETE/INSERT queries are used. Both cases
were run for these tests. on/off --oltp-read-only .
Allows for the ditribution of random numbers special --oltp-dist-type
Sets the total number of requests allowed. The value “0” indicates
unlimited requests are allowed. 0 --max-requests
Sets the number of worker threads. varied from 1 to 128 --num-threads
Initializes the random number generator. on --init-rng
Sets the limit for total execution time in seconds. 180 --max-time
MySQL Installation
The MySQL Certified Software, downloaded from the MySQL Network, provides the
mysql-enterprise-gpl-5.0.46-0.rhel5.x86_64.tar
file for RHEL5 on x86_64 servers.
Table 5 lists the components contained in the tar file.
Table 5 MySQL Installation Packages
Description RPM Package
MySQL database server (mysqld, etc) MySQL-server-enterprise-gpl-5.0.46-0.rhel5.x86_64.rpm
MySQL client programs (mysql,
mysqladmin, etc) MySQL-client-enterprise-gpl-5.0.46-0.rhel5.x86_64.rpm
MySQL header files and libraries
(needed to build SysBench ) MySQL-devel-enterprise-gpl-5.0.46-0.rhel5.x86_64.rpm
MySQL Configuration
The example configuration file (my-large.cnf) that is provided with the MySQL database
server, was used as the basis of the my.cnf test file.
Table 6 lists the changes that were made to
the mysqld configuration.
Table 6 MySQL Test Configuration
Description Value mysqld Option
Maximum number of connections. The default is 100. 1600 max_connections
Number of interrupted connections from a host after which
connections are blocked. 10 max_connect_errors
Number of open tables for all threads. The default is 512. 2048 table_cache
Buffer size for each thread that needs to sort results. Increase
for faster ORDER BY and GROUP BY operations. 512K sort_buffer_size
Size of cache to hold SQL statements for the binary log
during a transaction. Increase for large, multiple-statement
transactions. 1M binlog_cache_size
14