[mythtv-firehose] mythtv branch master updated by dekarl. v0.28-pre-2917-gde66bcd

Git Repo Owner noreply at mythtv.org
Fri May 29 19:19:38 UTC 2015


The branch, master has been updated on the
mythtv repository by gitolite user dekarl.
       via  de66bcd62dcf39d7ee685fe44edafde7072bb606 (commit)
      from  7e24b320792964704ea56c440c7bb24252ec4030 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit de66bcd62dcf39d7ee685fe44edafde7072bb606
Author:    Karl Dietz <dekarl at mythtv.org> at Fri, 29 May 2015 21:04:54 +0200
Committer: Karl Dietz <dekarl at mythtv.org> at Fri, 29 May 2015 21:14:45 +0200
URL:       http://code.mythtv.org/cgit/mythtv/commit/?id=de66bcd62dcf39d7ee685fe44edafde7072bb606

add defragmentation of the recordedseek table to maintenance
This fixed very slow (more then 10 seconds) waiting times on start of
recording playback caused by very slow loading of the seek table from
the database.

See http://www.psce.com/blog/2012/07/09/data-fragmentation-problem-in-mysql-myisam/
for an elaborate explanation of the problem.

Also sort program and filemarkup while here. (the second and third
biggest tables on my backend)

Refs #12451



-----------------------------------------------------------------------

Summary of changes:
 mythtv/contrib/maintenance/optimize_mythdb.pl |   13 +++++++++++++
 1 files changed, 13 insertions(+), 0 deletions(-)

-- 



More information about the mythtv-firehose mailing list