MySQL max_join_size bug
It seems several current versions of MySQL have a bug: MySQL Bugs: #35346: max_join_size default value
This seems to include 5.0.67 which Zimbra uses. MySQL Bugs: #39093: Warning message about wrong 'max_join_size' value on startup
No idea on a solution, but I noticed it in the logger_mysql and mysql_error logs.
Culley
Mail | Dell 2950III | 2x Quad Core 5420 | 8gb RAM | 6x 146gb SAS RAID 0+1 | Red Hat 5.3 | Zimbra 6.0.10 Network Edition
Test | VMware ESXi Whitebox | Phenom II Black 3.2ghz | 12gb RAM | 6x 1tb SATA RAID 0+1 | CentOS 5.4 | FOSS, Not in use now