I'm using MySQLyog as an interface. I need to add an index to a table that's very large. I understand that in order to do this, the system is making a temporary copy of the table and that' s going to take some time given the amount of data that I've got. But regardless of how much time it takes, I'm confident this is a good and necessary step.
So, I run this command: "ALTER TABLE myable ADD INDEX ( posted_day );"
...and I get this error: "Error Code : 1878 Temporary file write failure. (524429 ms taken)"
I'm thinking this is because of the 250,000,000 rows I've got in the table.
How can I change my connection times so it doesn't timeout?
Screenshot of the interface is attached.