KnowledgeBase

Below are some suggested optimizations for MySQL servers that host our software.

For MyISAM tables:

 bulk_insert_buffer_size=32M
 join_buffer_size=4M
 key_buffer_size=128M
 max_allowed_packet=32M
 query_cache_limit=4M
 read_buffer_size=1M
 read_rnd_buffer_size=2M
 sort_buffer_size=8M
 table_cache=128
 tmp_table_size=32M

These are modest values. They can be doubled or more based on a client's server setup.

For InnoDB tables:

 innodb_buffer_pool_size=1G
 innodb_flush_log_at_trx_commit=0

The buffer pool size should always be 25-50% of your server's RAM, if not more. Programs like TrioLive and SwiftTraction use InnoDB, and TrioLive especially benefits a lot from the extra RAM.  Our other software uses MyISAM for most or all of their tables.

• Print
• Export PDF
• Share