Re: Mass Import Innodb
They are less than 1 MB. The Avg_row_length for this table is 13759. Nevertheless the total size of the table is 150GB.
To ensure that this problem is not caused by the JOIN I did the following query:
SELECT `id_document`,`name`
FROM `oldDB`.`documentlist`
WHERE `id_document` in (15371963,14864105,13406499,13230248,16477007,10207882,14408890,.......);
Inside the in (...) I added 1000 records, which is the same number of rows that are requested after the join. It takes 40 secs to be completed, even though the id_document is a primary key for that table! As you see the requested IDs vary significantly and as a result they are stored on different parts of the HD. Still the HD usage is very very low!
It must be some kind of config that limits MySQL. Any insights?
Subject
Views
Written By
Posted
3493
January 29, 2012 07:10AM
1056
January 30, 2012 09:07AM
1051
January 30, 2012 10:24AM
1014
January 31, 2012 07:06AM
971
January 31, 2012 02:51AM
907
January 31, 2012 03:21AM
1034
January 31, 2012 10:20AM
1262
January 31, 2012 10:44AM
969
February 01, 2012 02:22AM
Re: Mass Import Innodb
1059
February 01, 2012 04:33AM
1004
February 06, 2012 05:59AM
1145
February 07, 2012 10:38AM
1007
February 07, 2012 11:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.