Filter
Top Products
Table 4 SysBench Options
DescriptionValueSysBench 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 numbersspecial--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
DescriptionRPM 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
DescriptionValuemysqld Option
Maximum number of connections. The default is 100.1600max_connections
Number of interrupted connections from a host after which
connections are blocked.
10max_connect_errors
Number of open tables for all threads. The default is 512.2048table_cache
Buffer size for each thread that needs to sort results. Increase
for faster ORDER BY and GROUP BY operations.
512Ksort_buffer_size
Size of cache to hold SQL statements for the binary log
during a transaction. Increase for large, multiple-statement
transactions.
1Mbinlog_cache_size
14