title: will mysql compress text field reduce disk space on current database?
body: <p>I have a rather large mysql database table where one field is longtext, I wish to use compress on this field, would this result in diskspace reduction? or is the storage space already allocated and it won't result in any space reduction.  the storage engine is innodb.</p>