> Message_id 0 is even worse. select count(*) from msgs where message_id = 0; +----------+ | count(*) | +----------+ | 2091627 | +----------+ 1 row in set (4.06 sec)
mysql> select count(*) from msgs where message_id = 1; +----------+ | count(*) | +----------+ | 137409 | +----------+ 1 row in set (1.66 sec) mysql> select count(*) from msgs; +----------+ | count(*) | +----------+ | 2229041 | +----------+ 1 row in set (10.62 sec) -- Michael Scheidell, CTO >|SECNAP Network Security Winner 2008 Network Products Guide Hot Companies FreeBSD SpamAssassin Ports maintainer > > (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. > _________________________________________________________________________ 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/
