SQL Problem? |
Post Reply 
|
| Author | |
kspare 
Senior Member 
Joined: 26 January 2005 Location: Canada Status: Offline Points: 334 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: SQL Problem?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? |
|
 |
|
|
Desperado
Senior Member
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
kspare
Senior Member
Joined: 26 January 2005 Location: Canada Status: Offline Points: 334 |
Post Options
Thanks(0)
Quote Reply
Posted: 04 February 2005 at 11:33am |
|
spamfilter
|
|
|
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4106 |
Post Options
Thanks(0)
Quote Reply
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)? |
|
|
|
|
kspare
Senior Member
Joined: 26 January 2005 Location: Canada Status: Offline Points: 334 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4106 |
Post Options
Thanks(0)
Quote Reply
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? |
|
|
|
|
CyberBob
Groupie 
Joined: 26 January 2005 Status: Offline Points: 43 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.132 seconds.