I have tables that are over 7 million records and I originally had the
same issue, however if you will create indexes in those tables, on the
columns that you will be using for your queries this will GREATLY speed up
your queries.
I am sure that there is a more concise way to state how you should
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