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:
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.