sql - What is the most "space effective" way to store text in MySQL? -

sql - What is the most "space effective" way to store text in MySQL? -

i have +10 1000000 articles(200 1000 words) in innodb table. utilize type of query when i'm working article field:

select article,title,other_fields table id=123;

what "space effective" way store text in mysql?

now table size say 100gb, objective create little possible without causing much performance tradeoff.

myisam more space friendly innodb, can start one.

mysql sql optimization