MySQL Bugs: #73276: Reduce string storage

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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.