Help : Syslog plugin tab taking long time to load. #28
Description
My syslog tab under cacti is taking long time to load. Message processing from syslog_incoming seems to be working correctly.
Log frequency per poller cycle is 1100 to 1600.
Cacti Version - 1.1.6
Syslog Version - 2.1
Table - InnoDB
PARTITION - Per Day
==================================
mysql> show create table syslog;
+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| syslog | CREATE TABLE syslog (
facility_id int(10) unsigned DEFAULT NULL,
priority_id int(10) unsigned DEFAULT NULL,
program_id int(10) unsigned DEFAULT NULL,
host_id int(10) unsigned DEFAULT NULL,
logtime datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
message varchar(1024) NOT NULL DEFAULT '',
seq bigint(20) unsigned NOT NULL AUTO_INCREMENT,
KEY seq (seq),
KEY logtime (logtime),
KEY program_id (program_id),
KEY host_id (host_id),
KEY priority_id (priority_id),
KEY facility_id (facility_id)
) ENGINE=InnoDB AUTO_INCREMENT=55207 DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (TO_DAYS(logtime))
(PARTITION d20170422 VALUES LESS THAN (736807) ENGINE = InnoDB,
PARTITION d20170423 VALUES LESS THAN (736808) ENGINE = InnoDB,
PARTITION d20170424 VALUES LESS THAN (736809) ENGINE = InnoDB,
PARTITION d20170425 VALUES LESS THAN (736810) ENGINE = InnoDB,
PARTITION d20170426 VALUES LESS THAN (736811) ENGINE = InnoDB,
PARTITION d20170427 VALUES LESS THAN (736812) ENGINE = InnoDB,
PARTITION d20170428 VALUES LESS THAN (736813) ENGINE = InnoDB,
PARTITION d20170429 VALUES LESS THAN (736814) ENGINE = InnoDB,
PARTITION d20170430 VALUES LESS THAN (736815) ENGINE = InnoDB,
PARTITION d20170501 VALUES LESS THAN (736816) ENGINE = InnoDB,
PARTITION d20170502 VALUES LESS THAN (736817) ENGINE = InnoDB,
PARTITION d20170503 VALUES LESS THAN (736818) ENGINE = InnoDB,
PARTITION d20170504 VALUES LESS THAN (736819) ENGINE = InnoDB,
PARTITION d20170505 VALUES LESS THAN (736820) ENGINE = InnoDB,
PARTITION d20170506 VALUES LESS THAN (736821) ENGINE = InnoDB,
PARTITION d20170507 VALUES LESS THAN (736822) ENGINE = InnoDB,
PARTITION d20170508 VALUES LESS THAN (736823) ENGINE = InnoDB,
PARTITION d20170509 VALUES LESS THAN (736824) ENGINE = InnoDB,
PARTITION d20170510 VALUES LESS THAN (736825) ENGINE = InnoDB,
PARTITION d20170511 VALUES LESS THAN (736826) ENGINE = InnoDB,
PARTITION d20170512 VALUES LESS THAN (736827) ENGINE = InnoDB,
PARTITION d20170513 VALUES LESS THAN (736828) ENGINE = InnoDB,
PARTITION d20170514 VALUES LESS THAN (736829) ENGINE = InnoDB,
PARTITION d20170515 VALUES LESS THAN (736830) ENGINE = InnoDB,
PARTITION d20170516 VALUES LESS THAN (736831) ENGINE = InnoDB,
PARTITION d20170517 VALUES LESS THAN (736832) ENGINE = InnoDB,
PARTITION d20170518 VALUES LESS THAN (736833) ENGINE = InnoDB,
PARTITION d20170519 VALUES LESS THAN (736834) ENGINE = InnoDB,
PARTITION d20170520 VALUES LESS THAN (736835) ENGINE = InnoDB,
PARTITION d20170521 VALUES LESS THAN (736836) ENGINE = InnoDB,
PARTITION d20170522 VALUES LESS THAN (736837) ENGINE = InnoDB,
PARTITION d20170523 VALUES LESS THAN (736838) ENGINE = InnoDB,
PARTITION dMaxValue VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */ |
+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
bind-address=127.0.0.1
key_buffer = 2048M
innodb_data_file_path = ibdata1:10M:autoextend
max_heap_table_size=4G
max_allowed_packet=16777216
tmp_table_size=64M
join_buffer_size=64M
innodb_buffer_pool_size=16760M
innodb_additional_mem_pool_size=2048M
innodb_flush_log_at_timeout=4
innodb_read_io_threads=32
innodb_write_io_threads=16
innodb_doublewrite=OFF
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid