in reply to All These Files - Am I Thinking About This Right?
I don't think MySQL is the right kind of database for this. I'd stuff the texts in SOLR or some other fulltext search.
Jenda Enoch was right! Enjoy the last years of Rome.