MySQL Installation, MySQL Configuration

Table 4 SysBench Options

SysBench option	Value	Description
--test	oltp	OLTP emulates operations that a read database would perform. Other
		options are CPU, threads, mutex, memory, and fileio.
--oltp-table-size	1000000	Sets the number of rows in the test table.
--mysql-engine-trx	yes	Sets the value for whether the storage engine used is transactional.
--oltp-test-mode	complex	Determines how transactions are performed. Options are simple (very
		simple SELECTs), complex (transactional), and nontrx (non-transactional).
--oltp-read-only .	on/off	Sets whether the UPDATE/DELETE/INSERT queries are used. Both cases
		were run for these tests.
--oltp-dist-type	special	Allows for the ditribution of random numbers
--max-requests	0	Sets the total number of requests allowed. The value “0” indicates
		unlimited requests are allowed.
--num-threads	varied from 1 to 128	Sets the number of worker threads.
--init-rng	on	Initializes the random number generator.
--max-time	180	Sets the limit for total execution time in seconds.

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

RPM Package	Description
MySQL-server-enterprise-gpl-5.0.46-0.rhel5.x86_64.rpm	MySQL database server (mysqld, etc)
MySQL-client-enterprise-gpl-5.0.46-0.rhel5.x86_64.rpm	MySQL client programs (mysql,
	mysqladmin, etc)
MySQL-devel-enterprise-gpl-5.0.46-0.rhel5.x86_64.rpm	MySQL header files and libraries
	(needed to build SysBench )

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

mysqld Option	Value	Description
max_connections	1600	Maximum number of connections. The default is 100.
max_connect_errors	10	Number of interrupted connections from a host after which
		connections are blocked.
table_cache	2048	Number of open tables for all threads. The default is 512.
sort_buffer_size	512K	Buffer size for each thread that needs to sort results. Increase
		for faster ORDER BY and GROUP BY operations.
binlog_cache_size	1M	Size of cache to hold SQL statements for the binary log
		during a transaction. Increase for large, multiple-statement
		transactions.