HP 5992-4755 - Manual (Page 15)

Table 6 MySQL Test Configuration (continued)
Description Value mysqld Option
Buffer size for joins that do not use indices and require a
full table scan. 1M join_buffer_size
Number of server threads to cache for reuse. 16 thread_cache_size
Per-thread stack size. The default is 192K. 192K thread_stack
Amount of memory allocated for caching query results. The
value “0” disables query cache. 0 query_cache_size
Minimum length of the word to be included in a full-text
index. 4 ft_min_word_len
Maximum size of in-memory temp tables. Increase for
GROUP BY. 64M tmp_table_size
Path to innodb data files and sizes. Increase size from 10MB
to 100MB. ibdata1:100M\
:autoextend innodb_data_file_path
Number of bytes of the memory buffer to cache data and
indices. 1900M innodb_buffer_pool_size
Number of bytes of memory pool used to store the data
dictionary information and data structures. The default is
1M. 20M innodb_additional_mem_pool_size
Size of each log file in log group. The default is 5MB. 900M innodb_log_file_size
Determines how the log buffer is written to the disk. The
value “2” means data is flushed on every commit, but no
disk flush occurs. The default is 1. 2 innodb_flush_log_at_trx_commit
Controls next-key locking in search and index scans. The
default is 0 (disabled). 1 innodb_locks_unsafe_for_binlog
Number of threads currently inside the innodb engine. The
default varies with the MySQL version. 1000 innodb_thread_concurrency
Number of 'free tickets' to allow re-entry into the innodb
engine. 500 innodb_concurrency_tickets
The size of buffer InnoDB used in the memory to write the
log files. Ranges from 1MB to 8MB. Large log buffer saves
disk I/O operations. 8M Innodb_log_buffer_size
Specifies whether InnoDB locks a table internally. The
default is 1 (enabled). 0 innodb_table_locks
Specifies whether InnoDB supports XA transactions. The
default is 1 (supported). 0 innodb_support_xa
InnoDB stores all data twice by default. Disable it by using
the --skip-innodb-doublewrite parameter when starting the
MySQL server. skip-innodb-doublewrite innodb_doublewrite
Checksum validation is used on all data pages by default.
Disable it by using the --skip-innodb-checksums parameter
when starting the MySQL server. skip-innodb-checksums innodb_checksums
Benchmark Results
For each read-only or read/write test, SysBench was run with a varying number of thread
connections to determine the maximum transactions per second (tps). The tests were conducted
on both the internal storage with the battery backed write cache option (BBWC) and the Fibre
Channel attached Storage Area Network.
Benchmark Results 15