Opened 11 years ago
Closed 11 years ago
Last modified 11 years ago
#11282 closed Patch - Bug Fix (fixed)
Marking episode first/last performance improvement when no programid is available
Reported by: | Owned by: | Karl Egly | |
---|---|---|---|
Priority: | major | Milestone: | 0.27 |
Component: | MythTV - Mythfilldatabase | Version: | 0.26-fixes |
Severity: | low | Keywords: | mythfilldatabase performance database schema |
Cc: | Ticket locked: | no |
Description
The patch introduced in Ticket #10482 greatly improves performance for program entries which have a programid. However on my system with lots of entries without a programid (~73000, provider epgdata for Germany) episode marking now takes around 20 minutes. During this time, MySQL is consuming one CPU core completely, but not doing much I/O.
Adding an additional INDEX for columns starttime, title and subtitle improved the performance dramatically, now episode marking is done in about 10 seconds.
Attachments (2)
Change History (8)
comment:1 Changed 11 years ago by
Owner: | changed from stuartm to Karl Egly |
---|---|
Status: | new → assigned |
Changed 11 years ago by
Attachment: | 0018-add-index-to-improve-mythfilldatabase-performance.patch added |
---|
comment:2 Changed 11 years ago by
comment:3 Changed 11 years ago by
Milestone: | unknown → 0.27 |
---|---|
Priority: | minor → major |
Type: | Patch - Feature → Patch - Bug Fix |
comment:4 Changed 11 years ago by
Milestone: | 0.27 → 0.27.1 |
---|
Changed 11 years ago by
Attachment: | 0016-add-index-to-improve-mythfilldatabase-performance.patch added |
---|
revised patch
comment:5 Changed 11 years ago by
Resolution: | → fixed |
---|---|
Status: | assigned → closed |
comment:6 Changed 11 years ago by
Milestone: | 0.27.1 → 0.27 |
---|
Note: See
TracTickets for help on using
tickets.
I confirm that the patch improves the performance drastically (from ~20min to 15s in my case) after adapting it to mythtv-0.26.0+fixes.20130721.99eb39a. Thank you!