Home > MythTV > MythTV Slow Deletes (Still)

MythTV Slow Deletes (Still)

November 10th, 2008 Leave a comment Go to comments

Having spent bloody ages explaining, and then doing, the defragmentation of a Linux hard drive partition, I’m still experiencing very slow delete times from my MythTV media centre.

To make matters worse, I now get a time out on a lot of different interactions with the box, for example when I escape out of watching a tv programme. The screen will go black and the two minutes later I see a popup telling me the connection to the master backend has ‘gone away’.

I have now done an optimzation on the database through several methods and it does not appear to make life any better. It does appear to make a difference for a while but it soon returns to normal behaviour. Admittedly though I was planning on doing an ‘OPTIMIZE TABLE’ for every table in the database and so far I have only done it on the ‘program’ table.

One tool I did use was ‘myisamcheck –analyze –check-only-changed –quick –sort-index *.MYI’ in /var/lib/mysql/mythconverg

That seemed to spend sometime checking several tables, including ‘program’.

M planning on running a full optimize when I get the chance, but I’m also wondering what else could be going on which would cause this problem. Might need to consult ‘top’!

Categories: MythTV Tags: ,
  1. No comments yet.
  1. No trackbacks yet.