I am making cache table for website. It will have no problem with indexes (one unique index, simple quires), but it will have a lot of utf text. It will be 10-15gb (2 mln rows). Caching will help a lot for saving cpu usage, without cache every page has many complex queries.
Is it ok two have such a big table? It will be queried only with "SELECT text WHERE id = $id" several times a second.