Interesting Statistics

  • AOL CTO: "We need a solution with no central point of failure to handle couple of million updates/hr on top of MySQL."
  • In the CryptDB SOSP 2011 paper, they analyzed a trace of queries hitting sql.mit.edu for ten days. I've reproduced their figure 7 here:

     DatabasesTablesColumns
    Complete schema8,548177,1541,244,216
    Used in queries1,19318,162128,840

    These numbers might be useful in estimating the number of tables in a RAMCloud cluster.