CMU is doing a bunch of research on exactly what you mentioned. [1] is a general SQL database that aims to operate "autonomously" by predicting workloads (altho

CMU is doing a bunch of research on exactly what you mentioned. [1] is a general SQL database that aims to operate "autonomously" by predicting workloads (although AFAIK its current capabilities are mostly limited to adaptively moving records between row-oriented and column-oriented storage). I think [2] is based on the same research, but is a more concrete tool for tuning MySQL and Postgres configuration. I think ultimately, it's a much less tractable problem than anyone expected. [1] http://pelotondb.io/ http://pelotondb.io/ [2] https://github.com/cmu-db/ottertune https://github.com/cmu-db/ottertune