Alan, > Now I'd love to know why I can't upgrade :)
You can upgrade to version 4.0.17 ;) It seems you hit the bug that was introduced in 4.0.16, and fixed in 4.0.17. Look at this: http://www.mysql.com/doc/en/News-4.0.17.html "Fixed optimizer bug, introduced in 4.0.16, when REF access plan was preferred to more efficient RANGE on another column. " Best regards, Mikhail. ----- Original Message ----- From: "Alan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 04, 2004 8:37 PM Subject: Re: index change moving files to other computer? > On Wed, Feb 04, 2004 at 07:21:30PM +0000, [EMAIL PROTECTED] wrote: > > The older system is choosing to use a different index. I would suggest > > Any idea why it would choose this? Shouldn't mysql keep using the same > indexes? > > > running an analyze on your new tables and see if you can get the newer > > system to use the same Postsindex8 index. > > I ran myisamchk -a on this, which according to the documentation is the same. > No changes. I did downgrade to 4.0.14 however and happy happy day it's > back up to the speed that I was used to! > > Now I'd love to know why I can't upgrade :) > > Sorry for being such a lamer n00b, but it's not my DB and mysql has > always "just worked" for me (though I don't use many 600k row tables :) > > Alan > > -- > Alan <[EMAIL PROTECTED]> - http://arcterex.net > -------------------------------------------------------------------- > "There are only 3 real sports: bull-fighting, car racing and mountain > climbing. All the others are mere games." -- Hemingway > > -- > 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]
