Recommended MySQL Settings

Depending of your MySQL Server setup (if it is a dedicated server or not) there are different my.cnf files you should deploy.

Since Razuna is using the InnoDB Engine for it databases you should apply some specific InnoDB settings to the MySQL Server. If you don't know InnoDB here is a short description;

InnoDB provides MySQL with a transaction-safe (ACID compliant) storage engine that has commit, rollback, and crash recovery capabilities. InnoDB does locking on the row level and also provides an Oracle-style consistent non-locking read in SELECT statements. These features increase multi-user concurrency and performance.

You can find out more on InnoDB at the official MySQL InooDB documentation.

Adding specific InnoDB settings

For the best performance for Razuna you should add/modify the following settings to the my.cnf file:

innodb_open_files = 500
innodb_file_per_table
innodb_buffer_pool_size = 250M
innodb_flush_log_at_trx_commit = 2
innodb_thread_concurrency = 8
innodb_lock_wait_timeout = 500
interactive_timeout = 20
back_log = 75
thread_cache = 32
wait_timeout = 30
connect_timeout = 10

This ensures that the MySQL Server behaves the most efficient way in regards to InnoDB tables. We have run this settings at different production setups and have had very good feedback from customers.

Make sure that you restart the MySQL server to apply the above settings.