Edgewall Software
Modify

Opened 11 years ago

Last modified 11 years ago

#824 new enhancement

[PATCH] Improve Bitten database model

Reported by: Alexandru Chirila <chirila.s.alexandru@…> Owned by:
Priority: major Milestone:
Component: Infrastructure Version: dev
Keywords: Cc: tony@…
Operating System:

Description

We have been experiencing problems with the current database model, specifically a very large bitten_report_item table (15 gigabytes). As a result: slow backup, slow queries on Build Status page, slower inserts etc...

A possible improvement to this is to split the table into smaller ones. The patch shards the table on the name field, which can only have these possible values:

('status', 'name', 'fixture', 'file', 'duration', 'type', 
 'description', 'lines', 'line_hits', 'percentage', 
 'category', 'msg', 'line', 'tag', 'traceback', 'stdout')

Attachments (1)

bitten_report_item_split.patch (23.0 KB) - added by Alexandru Chirila <chirila.s.alexandru@…> 11 years ago.
Patch that splits the bitten_report_item table.

Download all attachments as: .zip

Change History (3)

Changed 11 years ago by Alexandru Chirila <chirila.s.alexandru@…>

Patch that splits the bitten_report_item table.

comment:1 Changed 11 years ago by Alexandru Chirila <chirila.s.alexandru@…>

Please note that the patch also updates the required tests, and also bumps the schema_version to 13 and provides a method to upgrade to the new version, by using trac-admin upgrade.

Tests are all passing.

comment:2 Changed 11 years ago by Tony Meyer <tony@…>

  • Cc tony@… added

Add Comment

Modify Ticket

Change Properties
Set your email in Preferences
Action
as new The ticket will remain with no owner.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.