Print Page | Close Window

SQL Problem?

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5044
Printed Date: 07 June 2025 at 5:34am


Topic: SQL Problem?
Posted By: kspare
Subject: SQL Problem?
Date Posted: 04 February 2005 at 11:28am

I'm noticing that on out spamfilter server, the cpu is maxed out. The only thing I can figure is that it is having a problem with the database to deliver messages that were sent through from the web.

 

I keep closing and restarting it to try and deliver all the messages. What's going on?


Replies:
Posted By: Desperado
Date Posted: 04 February 2005 at 11:33am

Kevin,

What "Process" is using all the CPU?

Dan



-------------
The Desperado
Dan Seligmann.
Work: http://www.mags.net
Personal: http://www.desperado.com

Posted By: kspare
Date Posted: 04 February 2005 at 11:33am
spamfilter

Posted By: LogSat
Date Posted: 04 February 2005 at 4:50pm
Kevin,

What database platform are you using on the backend (SQL, MySQL, Access or Oracle)? Is the DB server installed on the same server as SpamFilter? If not, could you please check the database server to see if it is able to keep up with the flow of queries that SpamFilter is issuing to it? If the DB transactions get queued, SpamFilter may be forced to slow down it pace, and that could cause high CPUs.

What kind of traffic are you receiving (emails/day, concurrent connections at any second)?


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP

Posted By: kspare
Date Posted: 06 February 2005 at 10:27pm

I am running a SQL backend. It's on a different server.I didn't get a chance to check if the sql server was maxed out, but there was no connectivy, I blocked it at the firewall, so it was doing nothing but trying to deliver messages....kinda weird.

Just so you know, every once in awhile my auto whitelist gets wiped out still.

Posted By: LogSat
Date Posted: 07 February 2005 at 5:21pm
For the AutoWhiteList problem, can you please check your SpamFilter.ini file for the entry:

AutoWhiteListForceDeliveryFileName=

and make sure the filename is specified with a full path (i.e. c:\program files\SpamFilter\AutoWhiteListForceDelivery.txt). If not, it may be that SpamFilter is trying to use different copies of the file scattered thruout the hard drive, if Windows changes the default directory when SpamFilter runs.

For the high CPU, if SpamFilter is configured to use a database, and you have however stopped the connectivity, normally that is not a problem as SpamFilter shold realize the problem and suspend writes to the DB. But just in case, have you tried disabling the DB functionality within SpamFilter?


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP

Posted By: CyberBob
Date Posted: 08 February 2005 at 11:17am

Have you been changing your RegEx in the keyword filter lately?

I've caught myself a couple times entering invalid or very agressive rules that have nearly crippled my processors on the server.

We also have SpamFilter on one server and SQL on another.

May help or may not?

Bob


Print Page | Close Window