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

Outcomes