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 becom
> 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 no
After what action are you indexes becoming invalid? Are you running nightly
maintenance? What is the table type?
-Original Message-
From: Jude Insley
To: [EMAIL PROTECTED]
Sent: 5/21/04 6:00 AM
Subject: Index cardinality lost
We have a set of tables which are losing the cardinality on
We have a set of tables which are losing the cardinality on the first part
of the primary key. A simple CHECK TABLE or ANALYZE table restores the
cardinality. We are running MySQL 4.0.18 on Solaris 8.
*** 1. row ***
Table: UserSessions
Non
