Is there anything else running on the machine that might have used up a bunch of memory or CPU (check in your Task Manager - see how much free memory you have). Queries will run much faster if the data is cached in memory. If some other process has requested and received most of the memory in your machine, then all the data has to be read from disk.
What type of tables? Have you recently added a bunch of data to your tables? Have you tried analyzing them to get the statistics etc back in line with reality? What about a reboot? Win2k is not a great platform for MySQL - I believe it runs under Cygwin, which adds overhead. David. ----- Original Message ----- From: "Brian Power" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 01, 2004 8:22 AM Subject: 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]
