I'm using SQLyog and attempting to add an index to a table that consists of over 250,000,000 rows.
When I run this code:
ALTER TABLE Verizon ADD INDEX ( geo_coords_0 );
It runs for a little bit, but then I get this error:
Error Code: 1878
Temporary file write failure
(205999 ms taken)
Not sure how to proceed. Perhaps there's a timeout setting that I need to adjust? What do you think?