We have a database that uses a LONGTEXT type for a column that does not need that much space. The maximum row size currently has about 6500 characters and that's with a few million inserts so it's very unlikely we will ever need more space. Is it worthwhile to try to reduce the allocated size of this column? Will we see performance improvements?
We are using MySQL 5.6 with InnoDB.