Perfomatic:Schema Notes

From MozillaWiki
Jump to: navigation, search

Schema Notes

  • Need someone who uses the graph server every day -- need use-cases (vlad or stuart)
    • Need to know how it's used, what are the common user goals
    • Need to identify any front-end requirements that would affect the back-end schema
  • Questions for people who made the schema in the first place
  • Archiving policy?
    • How much access do we need to old data
    • How fast does the database grow?
  • Sharding
    • Do we need a row per result?
    • Partitions?
    • Chunk results into 10,000 seconds? Why have a row per result set?
    • Use simples files for a certain subset of tests -- why use mysql at all?
  • Graphite? - do we want to use this?

TODO

  • morgamic
    • email bz, dbaron
    • review alice's patch for rewrites
    • unblock people on hg access
  • laura
    • check in jacob's patch
    • needs to review lorchard's
  • ryan
    • get patch up on graph-stage
    • figure out how to get data set
  • alice
    • talos patches
    • IT bugs for updating graph stage
  • les
    • check in patch