Search found 1193 matches

by pdwalker
02 Apr 2015 11:58
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance

ok, I've gone from 1/7 the speed to 1/2 the speed (vm vs physical machine mysql performance). I have two arrays in the vm host, a 2 drive raid1 array and a 6 drive raid6 array. The raid6 array has a faster readwrite performance than the raid1 array. The raw vm image for efa was on the slower raid1 a...
by pdwalker
02 Apr 2015 11:16
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance - benchmarking mysql

I've used sysbench to do some performance testing on mysql. Short version: - MySQL performance inside my efa kvm is 1/7th the speed of the mysql performance on another older physical machine. - io wait % in the physical machine (and vm host machine) is very low. - io wait % inside the vm is very hig...
by pdwalker
02 Apr 2015 08:56
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance

times without and with --no-sync # su - apache -bash-4.1$ time /usr/local/bin/sa-learn -p /etc/MailScanner/spam.assassin.prefs.conf --ham --file /var/spool/MailScanner/quarantine/20150402/nonspam/07A1B181E17.A009C Learned tokens from 1 message(s) (1 message(s) examined) real 1m7.466s user 0m2.987s s...
by pdwalker
02 Apr 2015 08:45
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance

I made the following change in /var/www/html/mailscanner/functions.php just to get an idea of how long the UI was taking to train diff -c functions.php functions.php.org *** functions.php    2015-04-02 15:59:20.040362566 +0800 --- functions.php.org    2015-04-02 16:00:15.688371543 +0800 ************...
by pdwalker
02 Apr 2015 05:34
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance

[edit: ignore this]
Is there an address I can send the results to? A lot of this information cannot be posted in public form, and there is too much to sanitize.
by pdwalker
02 Apr 2015 04:55
Forum: 3.x Bugs
Topic: do you know ImageCerberusPLG4 ?
Replies: 8
Views: 6367

customizing spamassassin scores: local.cf

shawniverson wrote:You can add a spamassassin rule to local.cf to override this score...
being pendantic; the file is in:
/etc/mail/spamassassin/local.cf
Question: do we need to restart spamassassin after changing the rules?
by pdwalker
02 Apr 2015 04:51
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance

shawniverson wrote:Try running sa-learn with --no-sync and report back please.
like so?

Code: Select all

sa-learn --no-sync --{ham|spam} -f /var/spool/MailScanner/quarantine/<date>/{spam|nonspam}/<queuefile>
by pdwalker
02 Apr 2015 04:47
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance

Agreed it is too slow. Don't know why. Still working on it.
by pdwalker
31 Mar 2015 04:54
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance

You're seeing the same thing I am. While the system is running sa-learn, the rest of the system grinds to a halt, or becomes very slow and unresponsive. It is like the whole system waits until sa-learn completes. It seems to take about 30 seconds per message for sa-learn to run. It's not an SQL tabl...
by pdwalker
30 Mar 2015 03:11
Forum: Discussion
Topic: Feature request
Replies: 4
Views: 2017

Re: Feature request

The UI is called "mailwatch" ( https://sourceforge.net/projects/mailwatch/ ) and does not appear to be terribly active at the moment. It might be worth giving the author a prod over there.
by pdwalker
30 Mar 2015 03:06
Forum: How-to
Topic: Update-Behaviour
Replies: 6
Views: 5732

Re: Update-Behaviour

added to the wiki
by pdwalker
28 Mar 2015 03:32
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance

First, edit your post and remove the password.

What was the load average during that time? And was top showing iowait during that time?

If so, we're both experiencing the same thing.

I'm still looking.
by pdwalker
27 Mar 2015 19:01
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance

Can you run the following command a couple of times and tell me what kind of queries to which database you are seeing? mysqladmin -uroot -p<EFA mysql root password from /etc/EFA-Config> processlist run it 5 or 10 times. what ones in the "db" column show active queries? ("Command" column = "Query") T...
by pdwalker
27 Mar 2015 17:11
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance

todd,

Do you get a lot of non English language mail into your system?
by pdwalker
27 Mar 2015 16:55
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance

Shawn, I expect if he does as you say, the load will drop to near 0.

I'm now almost certain that the problem is because of an unoptimal mysql configuration. I'm playing with the configurations now to see if I can improve the performance without making too many changes.
by pdwalker
27 Mar 2015 16:01
Forum: How-to
Topic: [howto] Installing and using opendkim with EFA 3.0.0.7
Replies: 54
Views: 464938

Re: [howto] Installing and using opendkim with EFA 3.0.0.7

Isn't the internet a wonderful invention? (except for spam, of course)
by pdwalker
27 Mar 2015 15:46
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance

It should be plenty of hardware, that's not the problem. The problem is elsewhere.

I'm doing some testing now to see if I can isolate the issue.
by pdwalker
27 Mar 2015 15:43
Forum: Discussion
Topic: MailScanner Max Children
Replies: 9
Views: 4179

Re: MailScanner Max Children

The page marked 125 is 141 pages in. There is another document added to the front of the PDF which throws off the page numbering.

As for the 16 processes, with a max of 10 set in EFA, I'm not sure. I'd have to dig in and look.
by pdwalker
27 Mar 2015 13:50
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance

It looks like the mailscanner process is getting hung up on i/o somewhere.

I have an idea. I'll test it in a couple of hours and let you know if it makes a difference for me.
by pdwalker
27 Mar 2015 13:24
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance - findings

SA Learn causes a lot of IO wait for me
by pdwalker
27 Mar 2015 12:55
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance

Hmmm...

Interesting. I am getting slower performance now. I am seeing a lot of iowait.

Let me see if I can figure this out...
by pdwalker
27 Mar 2015 12:39
Forum: Discussion
Topic: message marked as spam gives a razor error
Replies: 38
Views: 13731

Re: message marked as spam gives a razor error

3.0.0.7, build from the centos netinstall selecting the SA Learn option of "As Spam+Report" results in the same error warn: reporter: razor2 report failed: No such file or directory report requires authentication at /usr/local/share/perl5/Mail/SpamAssassin/Plugin/Razor2.pm (sorry, I didn't save the ...
by pdwalker
27 Mar 2015 05:41
Forum: How-to
Topic: Improving my EFA Performance
Replies: 47
Views: 13850

Re: Improving my EFA Performance

As a wild ass guess, I'd suspect mysql being the bottleneck to mailscanner. Perhaps there is a way to debug the time it takes for Mailscanner to handle requests. That information could give you a better indication of where Mailscanner is being held up. Once you know that, then solving the problem be...
by pdwalker
27 Mar 2015 05:35
Forum: Discussion
Topic: MailScanner Max Children
Replies: 9
Views: 4179

Re: MailScanner Max Children

If you look at page 141 of the MailScanner User Guide and Training Manual , you can see their recommendations. So how many should you use? It'll depend on the workload and where the processes are contending for resources. I'd be inclined to go with 1 or 2 per CPU core (3 for hyperthreaded cores) and...