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: <0mkp8s-1lmofv1ycw-000...@mrelay.perfora.net> 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 AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/