Modify
Warning Please read the Ticket HowTo before creating or commenting on a ticket. Failure to do so may cause your ticket to be rejected or result in a slower response.

Opened 17 months ago

Closed 8 months ago

Last modified 8 months 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 9 months ago.
0016-add-index-to-improve-mythfilldatabase-performance.patch (3.4 KB) - added by dekarl 8 months ago.
revised patch

Download all attachments as: .zip

Change History (8)

comment:1 Changed 16 months ago by dekarl

  • Owner changed from stuartm to dekarl
  • Status changed from new to assigned

Changed 9 months ago by dekarl

comment:2 Changed 9 months 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 9 months ago by stuartm

  • Milestone changed from unknown to 0.27
  • Priority changed from minor to major
  • Type changed from Patch - Feature to Patch - Bug Fix

comment:4 Changed 9 months ago by dekarl

  • Milestone changed from 0.27 to 0.27.1

Changed 8 months ago by dekarl

revised patch

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

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

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 8 months ago by stuarta

  • Milestone changed from 0.27.1 to 0.27

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'new'.
Author


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

 
Note: See TracTickets for help on using tickets.