Bug #73276 Reduce string storage
Submitted: 11 Jul 2014 13:14
Reporter: Victor Porton Email Updates:
Status: Open Impact on me:
Category:MySQL Server: Storage Engines Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[11 Jul 2014 13:14] Victor Porton
For either VARCHAR or *TEXT (or both) columns, there should be added the mode when duplicate strings are stored only once.

In other words, we need to store just ID of a string in a separate storage pool.

The best way to do this is certainly to make a separate table with IDs and strings. But sometimes creating a new table is a hassle. For example our site has hundreds of tables and creating a new table is undesirable.

Please do it, because it is a hack not to create many additional tables.

How to repeat:
It is a feature suggestion.