Hello, I am using load data infile to load 11million records. It has been running for 3 days now and still running. I am wondering if it is doing anything at all. Could I query table without risking the current load data activitiy? How would I get insight as to how the load is progressing?
Is the load data committing on every record or does it wait until 11 millions has been loaded before it does a commit. Is there a way to control how many records (like every 100 records it does a commit) it should commit on? Thanks. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "mysql" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/mysql -~----------~----~----~----~------~----~------~--~---
