I have a 5GB InnoDB table in MySQL. I updated several rows where a column had massive amounts of data to be blank, hoping to make the table smaller and perform quicker.
I then discovered that InnoDB doesn't reduce disk space when you remove data from it.
However, there is less data to search through now, so I'd like to assume it will still perform better, especially when performing a
I tried to do some benchmark tests, but very unfortunately did not take accurate before measurements.
Will my InnoDB table perform faster now that I've removed data from the table, or does it still have to search through the same amount of disk and there will be no difference.