Perfomatic:Schema Notes: Difference between revisions
Jump to navigation
Jump to search
(New page: = Schema Notes = * Notes to discuss in our meeting about the schema) |
(→TODO) |
||
| (10 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
= Schema Notes = | = 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? | |||
* [http://graphite.wikidot.com/ 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 | |||
Latest revision as of 21:43, 17 July 2008
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