MythTV Slow Deletes (Still)
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’!
