Modify ↓

Ticket #1113 (closed enhancement: fixed)

Opened 11 years ago

Last modified 10 years ago

DBStats MySQL Indexes

Reported by: https://www.google.com/accounts/o8/id?id=AItOawmPND9hLM-9OK1G8nL1xVVEEDXIbudo2IE Owned by: laszlo
Priority: minor Milestone: Bcfg2 1.3.0 Release
Component: bcfg2-client Version: 1.0
Keywords: Cc:

Description

Had an awful time with MySQL performance with DBStats, turns out a couple indexes make it much more usable. Would suggest including these with the code to create the table.

create index idx_report_reason_version on reports_reason (version(100)); create index idx_report_reason_current_diff on reports_reason (current_diff(10000));

Attachments

Change History

comment:1 Changed 10 years ago by laszlo

  • Owner changed from desai to laszlo
  • Status changed from new to assigned

This may no longer be an issue with 1.3 as the schema has this table was heavily modified and split up.

comment:2 Changed 10 years ago by solj

  • Status changed from assigned to closed
  • Resolution set to fixed

1.3.0 has been released. Please reopen if this is still an issue.

WARNING! You need to establish a session before you can create or edit tickets. Otherwise the ticket will get treated as spam.

View ↑

Add a comment

Modify Ticket

Change Properties
<Author field>
Action
as closed
The resolution will be deleted. Next status will be 'reopened'
Author


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

Attachments ↑
 
Note: See TracTickets for help on using tickets.