Analyze your table. Your cardinality is invalid. >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/1/04, 10:22:36 AM, Brian Power <[EMAIL PROTECTED]> wrote regarding When I woke up this morning...: > Hi all, > I'm a having a stange problem with mysql-nt on win2000. > Querys that last night were taking just 2 seconds are now taking 1m 30secs > +. > I have a table... > Field Type Collation Null Key Default Extra > Privileges Comment > ------- ------------ ----------------- ------ ------ ---------- ------ > ------------------------------- ------- > H_ID int(10) NULL PRI 0 > select,insert,update,references > H_Name varchar(255) latin1_swedish_ci YES MUL (NULL) > select,insert,update,references > SireID int(10) NULL YES MUL (NULL) > select,insert,update,references > GSireID int(10) NULL YES (NULL) > select,insert,update,references > Gender varchar(50) latin1_swedish_ci YES (NULL) > select,insert,update,references > DOB date NULL 0000-00-00 > select,insert,update,references > Table Non_unique Key_name Seq_in_index Column_name Collation > Cardinality Sub_part Packed Null Index_type Comment > ------ ---------- -------- ------------ ----------- --------- > ----------- -------- ------ ------ ---------- ------- > horses 0 PRIMARY 1 H_ID A > 40926 (NULL) (NULL) BTREE > horses 0 h_name 1 H_Name A > (NULL) (NULL) (NULL) YES BTREE > horses 1 SireID 1 SireID A > 2273 (NULL) (NULL) YES BTREE > It has 40,000 recs. > When I run select * from horses, it takes 1m 40secs to get them. > anybody run in to this before? I'm considering reinstalling mysql. any > toughts? > please help > Brian Power > _________________________________________________________________ > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. > http://join.msn.com/?page=features/virus > -- > 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]
