I finally figured out that we had been running large databases without indexes working at all. It turns out that if I use mysqldump to dump out a database, then drop/create the database and build from the dump, none of the indexes work. Things slow to a crawl. I found inadvertantly that by issuing any "alter table" query to a table, the indexes start working again.
Is there any reason for this?
Thanks,
Toby
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]