was trying to track down issues with an email that got in (score 0,
tests []) and I could not find out why...
but found something else.
select * from msgs where message_id = 1 and quar_loc != '' limit 1\G
(just to get one)
partition_tag: 0
mail_id: 0+2FKYCeclnp
secret_id: QyQvOzmKqcto
am_id: 20120-12
time_num: 1231774707
time_iso: 2009-01-12 15:38:27
sid: 12508351
policy:
client_addr: 74.208.4.194
size: 77395
content: S
quar_type: Q
quar_loc: 0+2FKYCeclnp
dsn_sent: N
spam_level: 7.08
message_id: 1
(I selected on in quarantine so I could see the full mail)
Message-Id: <[email protected]>
running amavisd 2.6.2, freebsd 6.4, mysql 5.1, (not using partitioning yet).
I don't THINK I have any weird select queries.
to let you know how MANY are like this:
select count(*) from msgs;
+----------+
| count(*) |
+----------+
| 2228043 |
+----------+
select count(*) from msgs where message_id=1;
+----------+
| count(*) |
+----------+
| 136411 |
+----------+
so, 136K out of 2.2MM records do this.
--
Michael Scheidell, CTO
Phone: 561-999-5000, x 1259
> *| *SECNAP Network Security Corporation
* Certified SNORT Integrator
* King of Spam Filters, SC Magazine 2008
* Information Security Award 2008, Info Security Products Guide
* CRN Magazine Top 40 Emerging Security Vendors
_________________________________________________________________________
This email has been scanned and certified safe by SpammerTrap(r).
For Information please see http://www.secnap.com/products/spammertrap/
_________________________________________________________________________
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
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/
