Perfomatic:Rearchitecture: Difference between revisions

Line 2: Line 2:
* [[Media:Graph_server_new_db_schema.jpg | New DB schema]]
* [[Media:Graph_server_new_db_schema.jpg | New DB schema]]
** InnoDB
** InnoDB
* Add triggers to recalculate averages
* Add triggers to recalculate averages - [https://bugzilla.mozilla.org/show_bug.cgi?id=456530 bug 456530]
* Add stored procedure to remove old data
* Add stored procedure to remove old data - [https://bugzilla.mozilla.org/show_bug.cgi?id=456532 bug 456532]
* Add memcached or sqlite for frequently accessed data
* Add memcached or sqlite for frequently accessed data
* Send less data for continuous graphs
** Depends on how slow the new db is
* Send less data for continuous graphs - [https://bugzilla.mozilla.org/show_bug.cgi?id=456534 bug 456534]


=== Frontend ===
=== Frontend ===
975

edits