AnsweredAssumed Answered

MySQL optimization

Question asked by Nicolas Afonso Employee on Oct 2, 2015
Latest reply on Oct 9, 2015 by Nicolas Afonso

Hi folks !


My question of the day : which is the optimal configuration for the MySQL database hosting Gateway's conf & policies ?


I am currently "tuning" our API Gateway environment, databases are one of the important element to consider for enhancing global performances.


So what are your recommendations : MyISAM vs InnoDB, cache size, max connections, concurrent thread number, MySQL log management, ...


Please share your configurations and experiences


Thank you