[mythtv-users] Slow Database

[Jason McKnight]

try to SSH to your backend.

If it takes a long time for the backed to respond and log you in the 
problem is DNS. Quite a few of my linux boxen have a long delay on just 
about any network operation if they can't perform a reverse lookup of 
the IP address. You can alleviate this by running DNS locally or by 
creating entries in /etc/hosts (on the backend) for each machine on the 
network.

MySQL can suffer from delays if the server is memory limited. I doubt 
this is the case since the MythTV db should be fairly small compared to 
most databases.

Adam Skinner wrote:

>Hi all ,
>
>I have a pretty well working myth setup, apart from the slowness of 
>'browse mode' in live it.
>
>It takes so so so long to bring up the next channels current program
>making the feature useless.
>
>I know this is a problem with my dedicated backend as it affects all
>of my various frontends. Im thinking It may be a mysql  database
>problem as mythweb is also very slow and performing searches by
>keyword is also very tedious. I have a hardware encoder and all cpu
>spare as I dont run commerical detection or transcoding. My system is
>super fast , but was hoping for it not to be unuseable.
>
>Anyone with any advice , or similar problems please comment.
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>  
>