[EMAIL PROTECTED] wrote:
I'm moving a database to a new server. I'm using MySQL v5.0.16
on 'Windows. I used the MySQL Administrator to backup on the old
system and restore on the new one. Everything is fine _except_ on the
new server, some queries take 2-3 minutes with MySQL using 100% of t
> Have you tried Repair table or if InnoDB
> ALTER TABLE ENGINE=InnoDB;
>
> Sometimes I've noticed after a restore or after adding lots of rows
> performance is slow. REPAIR or the ALTER TABLE fixes it.
I'll try that. Thanks.
What's curious is that I've got one backup I can restore and have fi
Have you tried Repair table or if InnoDB
ALTER TABLE ENGINE=InnoDB;
Sometimes I've noticed after a restore or after adding lots of rows
performance is slow. REPAIR or the ALTER TABLE fixes it.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, March 17,
