New answers tagged

3

Just because it is deprecated does not mean it won't work. Just don't explicitly specify length anymore when creating new tables. Let MySQL figure out how the length will be handled. Personally, I never used the length operator in my years as a DBA. Besides, the length operator (11) simply stands for the display on a signed INT. What is the range of a signed ...


-1

Is a commit happening on every transaction? That would slow things down if the SQL file is a bunch of individual statements. You may need to split up the transactions and do a commit every 1000 rows or more. If you do that, you can output a message to monitor progress. The tablespace may be growing in small increments. Do the affected tables have ...


Top 50 recent answers are included