HPOS 3.5 - Tuning MySQL parameters for HPOS

HP Output Server 3.5 5
Tuning MySQL parameters for HP Output Server
Solution
• read_rnd_buffer_size
This parameter helps in pdls queries. During pdls queries, data is selected randomly and not through
sequential queries. Increase the value by 20 to 50 percent of 256 KB (the current value).
Parameters that affect CPU
• innodb_sync_spin_loops
This parameter balances the CPU time wasted while running spin locks with unnecessary context switches. If the
spin lock setting is high, the CPU time wasted will increase. Alternatively, if spin lock setting is low, it results in
unnecessary context switches.
• innodb_thread_concurrency
This parameter increases the InnoDB kernel execusion threads, which use the CPU efficiently.
You can further increase the performance by setting the innodb_flush_logs_at_trx_commit parameter
to 0 instead of 1 (1 is the default value).
CAUTION: This could lead to disk or operating system crash and, therefore, a loss of data.
The recommended memory setting for a MySQL database server is 256 MB. However, large enterprise installations
can benefit from having a second my.cnf file with the tuning parameter for the MySQL server set to 512 MB.
Parameters that affect disk
• innodb_data_file_path ibdata1
This parameter specifies the value in the ibdata1 file.
• innodb_autoextend_increment
This parameter specifies the amount of disk space to be extended to the current tablespace. By default, the
amount of disk space is extended by increments of 8 MB.
• innodb_log_file_size
This parameter specifies the log file size.