> After what action are you indexes becoming invalid? Are you running nightly > maintenance? What is the table type?
We are not running nightly maintenance but we do run the INSERT DELAYED as a batch during the night. The loss of cardinality seems to happen after a number of days but we have not been able to track down when exactly it happens. The table type is MyISAM. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]