@lists.mysql.com
Subject: query on a very big table
Hi all,
we are trying to run the following query on a table that contains over 600
million rows:
'ALTER TABLE `typed_strengths` CHANGE `entity1_id` `entity1_id` int(10)
UNSIGNED DEFAULT NULL FIRST'
The query takes ages to run (has been running f
Christos Andronis wrote:
Hi all,
we are trying to run the following query on a table that contains over 600 million rows:
'ALTER TABLE `typed_strengths` CHANGE `entity1_id` `entity1_id` int(10)
UNSIGNED DEFAULT NULL FIRST'
The query takes ages to run (has been running for over 10 hours now).
Hello
CA> The query takes ages to run (has been running for over 10 hours
CA> now). Is this normal?
I think, your indexes are too complicated. MySQL have to rebuild it
usually after ALTER TABLE.
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ http://ryxi.com/
h
Not knowing what the ALTER TABLE is changing, I can't really say. Could
you send the table structure (as it was before the ALTER TABLE)?
Remember that MySQL is actually changing the data for every row, and
potentially rebuilding indexes as well, so it has a lot of work to do
from that single st
Hi all,
we are trying to run the following query on a table that contains over 600
million rows:
'ALTER TABLE `typed_strengths` CHANGE `entity1_id` `entity1_id` int(10)
UNSIGNED DEFAULT NULL FIRST'
The query takes ages to run (has been running for over 10 hours now). Is this
normal?
As a sid
