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.

Related posts:

1. Setting default MySQL storage engine (InnoDB or MyISAM) in PhpMyAdmin
2. Solution for DBD::mysql::db do failed: MySQL server has gone away at mysqlhotcopy line 528.

Posted in Sysadmin, Tutorial