Database Activity¶

In general, we recommend using the InnoDB storage engine for ExpressionEngine’s MySQL tables, and that is what is used by default when ExpressionEngine is installed. While ExpressionEngine will run fine with MyISAM, the MyISAM storage engine has to lock an entire table when it inserts a new row. Especially in extreme traffic events, this characteristic of MyISAM can bring a database server to its knees.

There are a few optional tracking features of ExpressionEngine that will update tables on every page load. These trackers are not enabled by default, but if you have enabled them, and experience an extreme traffic event, you may want to disable them to help ease the load on the server.

These can be disabled in your Control Panel Tracking Preferences. If you are unable to access your site due to the traffic, you or your server administrator can manually override these features in your config.php file as follows:

config.php Extreme Traffic Overrides¶

$config['enable_online_user_tracking']

(y/n) - Corresponds to Enable Online User Tracking?

$config['enable_hit_tracking']

(y/n) - Corresponds to Enable Template Hit Tracking?

$config['enable_entry_view_tracking']

(y/n) - Corresponds to Enable Channel Entry View Tracking?

$config['log_referrers']

(y/n) - Corresponds to Enable Referrer Logging?

$config['dynamic_tracking_disabling']

(numeric) - Corresponds to Suspend ALL tracking when number of online visitors exceeds:

$config['disable_all_tracking']

(y/n) - config.php only preference which can be set to y in an emergency, which will disable all of the above. This is useful for server administrators who need a way to respond immediately and can’t access the control panel.

Disk I/O¶

ExpressionEngine’s caching mechanisms can help reduce database load in most situations. However if you use file-based caching, that may transfer some of the resources saved from the database server to the web server. Thus, it is recommended that you use either the Memcached or Redis caching driver instead of the file driver, especially on high-traffic sites. The increased disk i/o from file caches being created and destroyed during a high traffic event consumes significantly more server resources than the memory-based caching drivers.

If you are running in a PHP environment without Opcode caching, saving templates as files can marginally increase disk i/o as each template must be retrieved from disk. We recommend running PHP 7 or greater so that this type of file activity is managed better by the server.