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 -ADatabase 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.