Exim causing load on server
Login to server via SSH.
Once login then login to mysql
[email protected] [~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1851
Server version: 5.1.65-cll MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Now in mysql run use eximstats command it will look like
mysql> use eximstats;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Now, type show tables. it will look like
mysql> show tables;
| Tables_in_eximstats |
| defers |
| failures |
| sends |
| smtp |
4 rows in set (0.00 sec)
Now, start deleting data from above tables. These tables having failure attempts etc.
mysql> delete from defers;
Query OK, 757 rows affected (0.02 sec)
mysql> delete from failures;
Query OK, 24901 rows affected (0.06 sec)
mysql> delete from sends;
Query OK, 47625 rows affected (0.06 sec)
mysql> delete from smtp;
Query OK, 59861 rows affected (0.10 sec)
Type ctrl+D to exit mysql
Now, restart mysql and exim.
[email protected][/var/lib/mysql/eximstats]# /etc/init.d/mysql restart
Shutting down MySQL.......... SUCCESS!
Starting MySQL.. SUCCESS!
[email protected][/var/lib/mysql/eximstats]# /etc/init.d/exim restart
Shutting down clamd: [ OK ]
Shutting down exim: [ OK ]
Shutting down spamd: [ OK ]
Starting clamd: [ OK ]
Starting exim: [ OK ]
/usr/local/cpanel/scripts/update_sa_rules: running in background