MySQL Configuration

[chrislynch8]

Hi all,

In gerneral what are the main settings you change for mysql to get the max performance from SugarCRM. i.e. Max_Connections, Table_Cache, Query_Cache_Limit, Query_Cache_Size etc..

Rgds
Chris

[jmertic]

Perhaps this article could be a good guide:

SugarCRM Developer Blog » Blog Archive » Improving SugarCRM client-side performance: The server

Also, check out the MySQL Performance Blog for MySQL tips and tricks in general.

MySQL Performance Blog