Our mail server has been suffering performance problems due to excessive use of the local MySQL server in the various configurations. Looking over the Amavisd-new configuration, I see that SQL Logging is enabled via:
@storage_sql_dsn = @lookup_sql_dsn; The lookups are necessary, but as we don't use $*_quarantine_method='sql' anywhere, and we aren't using the penpals feature, I would like to turn the SQL logging off. Once I do that, I want to clean out the tables used by SQL Logging. Based on README.sql.txt, I am led to believe that the @storage_sql_dsn is the sole user of the following tables: maddr msgs msgrcpt quarantine Currently the sizes of these tables are several hundred megs each (except for quarantine, which is empty). My question is twofold: First, I can just comment out or remove the @storage_sql_dsn line in amavisd.conf in order to disable SQL Logging? Second, will I cause any problems by deleting all the rows from the 4 tables above? Are they used in any other way? Thanks in advance for your help. -DH ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
