Opened 6 years ago

Closed 5 years ago

Last modified 5 years ago

#11282 closed Patch - Bug Fix (fixed)

Marking episode first/last performance improvement when no programid is available

Reported by: mv02@… Owned by: dekarl
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)

0018-add-index-to-improve-mythfilldatabase-performance.patch (1.4 KB) - added by dekarl 5 years ago.
0016-add-index-to-improve-mythfilldatabase-performance.patch (3.4 KB) - added by dekarl 5 years ago.
revised patch

Download all attachments as: .zip

Change History (8)

comment:1 Changed 6 years ago by dekarl

Owner: changed from stuartm to dekarl
Status: newassigned

Changed 5 years ago by dekarl

comment:2 Changed 5 years ago by m.a.zulliger@…

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!

comment:3 Changed 5 years ago by stuartm

Milestone: unknown0.27
Priority: minormajor
Type: Patch - FeaturePatch - Bug Fix

comment:4 Changed 5 years ago by dekarl

Milestone: 0.270.27.1

Changed 5 years ago by dekarl

revised patch

comment:5 Changed 5 years ago by Karl Dietz <dekarl@…>

Resolution: fixed
Status: assignedclosed

In 8acb5adf90cbe41c3de1c3084752aa70fbf52308/mythtv:

add index to improve mythfilldatabase performance

fix index documentation of related index while here

slipping it in before the beta is cut as per discussion at
http://irc.mythtv.org/ircLog/channel/4/2013-08-15:19:25

Fixes #11282

comment:6 Changed 5 years ago by Stuart Auchterlonie

Milestone: 0.27.10.27
Note: See TracTickets for help on using tickets.