Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm trying to import a fairly large file (5Gb, ~130M records) into a MyISAM table (mysql 5.1.61). It's been running for more than 5 hours now with no errors displayed, and I can see "LOAD DATA INFILE ..." in the process list.

However, when I run SHOW TABLE STATUS, "Data_length" for the table being updated is still 0. I wonder if that's normal - if not, I should probably abort the import to see what's wrong.

"Update_time" displayed by SHOW TABLE STATUS is up-to-date and changes quickly.

Is it normal for "Data_length" to remain zero while mysqlimport is successfully running?

share|improve this question

closed as off topic by Khaled, rnxrx, mdpc, Scott Pack, Iain Oct 14 '12 at 14:09

Questions on Server Fault are expected to relate to professional server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

add comment

1 Answer

up vote 1 down vote accepted

I think that the data_length field is computed after the mysqlimport is finished.

Chek the size of the data file .MYD under /mysql/install/path/databasename/table.MYD and see if it is growing.

share|improve this answer
    
Thanks, the file seems to be growing. –  Yuriy May 30 '12 at 16:09
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.