[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
ch 17, 2006 2:37 PM
To: mysql@lists.mysql.com
Subject: Some queries use 100% CPU after restore
Importance: High
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.
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 the
CPU. I've dropped unne
