MySQL Tuning

 

  1. Go to ManageEngine\ServiceDeskPlus-MSP\bin folder
  2. Edit startdb.bat file on a wordpad and append the following parameters to the last line of the file based on the RAM size.

For 1GB RAM:

–set-variable=query-cache-type=2 –read_buffer_size=128K –read_rnd_buffer_size=1M –sort_buffer_size=1M –myisam_sort_buffer_size=4M –tmp_table_size=32M –max_heap_table_size=32M –key_buffer_size=32M –innodb_buffer_pool_size=128M –bulk_insert_buffer_size=16M –table_cache=512 –thread_cache=32 –innodb_flush_log_at_trx_commit=0 –low-priority-updates

 

For 2GB of RAM:

–set-variable=query-cache-type=2 –read_buffer_size=128K –read_rnd_buffer_size=1M –sort_buffer_size=2M –myisam_sort_buffer_size=4M –tmp_table_size=32M –max_heap_table_size=32M –key_buffer_size=32M –innodb_buffer_pool_size=256M –bulk_insert_buffer_size=16M –table_cache=512 –thread_cache=32 –innodb_flush_log_at_trx_commit=0 –low-priority-updates

 

For 3GB of RAM:

–set-variable=query-cache-type=2 –read_buffer_size=128k –read_rnd_buffer_size=1M –sort_buffer_size=2M –myisam_sort_buffer_size=8M –tmp_table_size=32M –max_heap_table_size=32M –key_buffer_size=64M –innodb_buffer_pool_size=750M –bulk_insert_buffer_size=16M –table_cache=750 –innodb_flush_log_at_trx_commit=0 –low-priority-updates

 

For 4GB of RAM:

–set-variable=query-cache-type=2 –read_buffer_size=128K –read_rnd_buffer_size=2M –sort_buffer_size=2M –myisam_sort_buffer_size=8M –tmp_table_size=32M –max_heap_table_size=32M –key_buffer_size=64M –innodb_buffer_pool_size=1024M –bulk_insert_buffer_size=16M –table_cache=900 –innodb_flush_log_at_trx_commit=0 –low-priority-updates

 

If you have followed the above instructions but still have an issue with the performance, then send the below stated log files to our Support Team for further analysis.

1. wrapper.log from  ManageEngine\ ServiceDeskPlus-MSP\bin

2. serverout0.txt,…..,serverout5.txt from ManageEngine\ServiceDeskPlus-MSP\server\default\log

 

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500