The log_rotation table contains configuration details for log rotation at the domain level.

Column Descriptions
id – links to id in domains table
period_type – can be by_time or by_size
period – which interval to run log rotation
max_number_of_logfiles – how many log files to leave in place besides the current one
compress_enabletrue if logs should be compressed after rotation, otherwise false
email – contains e-mail address if old logs should be e-mailed, otherwise empty
turned_ontrue if enabled, otherwise disabled

Table Structure

CREATE TABLE `log_rotation` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `period_type` enum('by_time','by_size') NOT NULL default 'by_time',
 `period` varchar(50) character set ascii collate ascii_bin default NULL,
 `max_number_of_logfiles` bigint(20) unsigned default '0',
 `compress_enable` enum('false','true') NOT NULL default 'false',
 `email` varchar(255) character set utf8 default NULL,
 `turned_on` enum('false','true') NOT NULL default 'false',
 PRIMARY KEY  (`id`)

Related documentation