Roughly how long should an "ALTER TABLE" take on an 1.3GB INNODB table?
- by justkevin
I'm trying to optimize a table that hasn't been optimized in a long time. It has around 2.5 million rows with 1.3 GB of data and a 152 MB index. I started optimizing it about 15 minutes ago and I have no idea how long it will take.
The server is reasonably robust (quad xeon with 4GB ram) and has a 500MB innodb buffer pool size.
Should I expect this to take minutes, hours or days?