Filter
Top Products
Table 6 MySQL Test Configuration (continued)
DescriptionValuemysqld Option
Buffer size for joins that do not use indices and require a
full table scan.
1Mjoin_buffer_size
Number of server threads to cache for reuse.16thread_cache_size
Per-thread stack size. The default is 192K.192Kthread_stack
Amount of memory allocated for caching query results. The
value “0” disables query cache.
0query_cache_size
Minimum length of the word to be included in a full-text
index.
4ft_min_word_len
Maximum size of in-memory temp tables. Increase for
GROUP BY.
64Mtmp_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.
1900Minnodb_buffer_pool_size
Number of bytes of memory pool used to store the data
dictionary information and data structures. The default is
1M.
20Minnodb_additional_mem_pool_size
Size of each log file in log group. The default is 5MB.900Minnodb_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.
2innodb_flush_log_at_trx_commit
Controls next-key locking in search and index scans. The
default is 0 (disabled).
1innodb_locks_unsafe_for_binlog
Number of threads currently inside the innodb engine. The
default varies with the MySQL version.
1000innodb_thread_concurrency
Number of 'free tickets' to allow re-entry into the innodb
engine.
500innodb_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.
8MInnodb_log_buffer_size
Specifies whether InnoDB locks a table internally. The
default is 1 (enabled).
0innodb_table_locks
Specifies whether InnoDB supports XA transactions. The
default is 1 (supported).
0innodb_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-doublewriteinnodb_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-checksumsinnodb_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