I need help with performance tuning of my mysql db.
I'm using a Sugarcrm CE on a machine with the below config Processor: Xeon E5-2630v3 8 core x 2 RAM: 16 GB DDR4 Hard disk: SAS 1 TB Raid OS: Ubuntu 14.04 LTS SugarCRM version: 6.5.10 CE DB: mysql DB size: 5 GB Database engine: MyISAM
Sometimes the crm application becomes very slow and takes forever to open the pages. I checked some of the server parameters and observed that whenever the mysql Threads goes close to 150 it becomes very slow (please refer to the attachment). The max the threads goes to is 153. I increased the max_connections to 300 but the no. of Threads still do not go over 153 and become really slow when it reaches that limit.
I did a top command and saw that more the load does not exceed 6-7 in my 16 core server. About 50% memory is also available. CPU is available. So my guess is that it has something to do with the Threads.Seeking advice on how to troubleshoot and fix this issue. Any help would be appreciated. Thanks in advance.