As a preventive maintenance and the handle fragmentation running a nightly mysqltablecheck may prove to be beneficial.
-----Original Message----- From: Jude Insley To: [EMAIL PROTECTED] Sent: 5/21/04 7:10 AM Subject: RE: Index cardinality lost > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
