OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: index change moving files to other computer?

From: Alan (alanufies.org)
Date: Wed Feb 04 2004 - 13:37:51 CST

On Wed, Feb 04, 2004 at 07:21:30PM +0000, vpendletonhoovers.com 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 <alanufies.org> - 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