Optimizing your ActiveCampaign mysql database for improved import speed

If setup incorrectly, ActiveCampaign’s import system can be incredibly slow. I put together some tips for ensuring you have the best settings possible.

1. Make sure you are using INNODB for a table engine instead of MyISAM. The table level locking of MyISAM can make inserts very slow on import.
2. Find and open your MySQL config file. On linux this is typically at /etc/my.cnf. On Windows this is typically a file in your MySQL folder named my.ini
3. Add a line (or update if it is there) with the following:
   innodb_flush_log_at_trx_commit=0
4. Add a line (or update if it is there) with the following:
   innodb_buffer_pool_size=1G
5. Set the above size to 50% of the available memory on the server. In the above we set it to “1G” for if you have 2GB available on the server. If you have 8 GB on the server you could set this to “4G”
6. You MUST restart MYSQL on the server for these changes to be used.

Changing Timezone on CentOS via NTP

If your server is showing the wrong date/time due to using the incorrect timezone, you can modify it quite easily.

For example, the time on my east coast servers were running on Central Time.

[root@app-1]# date
[root@app-1]# Wed Aug 18 11:05:13 CST 2010

First browse to the folder of timezones and locate yours

[root@app-1]# cd /usr/share/zoneinfo/

Now you will copy the correct timezone over the currently used incorrect zone at /etc/localtime.
For example mine is /usr/share/zoneinfo/US/Eastern

[root@app-1]# cp /usr/share/zoneinfo/US/Eastern /etc/localtime
[root@app-1]# cp: overwrite '/etc/localtime'? y

[root@app-1]# date
[root@app-1]# Wed Aug 18 12:05:13 EDT 2010