Exim causing load on server

 

Login to server via SSH.

Once login then login to mysql

root@testserver24x7 [~]# 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
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

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

Database changed

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

mysql> Bye

Now, restart mysql and exim.

root@testserver[/var/lib/mysql/eximstats]# /etc/init.d/mysql restart
Shutting down MySQL………. SUCCESS!
Starting MySQL.. SUCCESS!
root@testserver[/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
root@testserver[/var/lib/mysql/eximstats]#

 

Comments are closed.