[mythtv-firehose] mythtv branch fixes/0.27 updated by dekarl. v0.27.4-69-gb7afc9b

Git Repo Owner noreply at mythtv.org
Sun May 31 05:43:52 UTC 2015


The branch, fixes/0.27 has been updated on the
mythtv repository by gitolite user dekarl.
       via  b7afc9b8e7d25e643e60daa07d7b8fae94d99a7f (commit)
      from  aad534969568920e61cd78c397b93a9d3f2c377a (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 b7afc9b8e7d25e643e60daa07d7b8fae94d99a7f
Author:    Karl Dietz <dekarl at mythtv.org> at Fri, 29 May 2015 21:04:54 +0200
Committer: Karl Dietz <dekarl at mythtv.org> at Sun, 31 May 2015 07:43:13 +0200
URL:       http://code.mythtv.org/cgit/mythtv/commit/?id=b7afc9b8e7d25e643e60daa07d7b8fae94d99a7f

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

(cherry picked from commit de66bcd62dcf39d7ee685fe44edafde7072bb606)



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

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