[mythtv-users] Slow MySQL query after delete

David Brodbeck gull at gull.us
Wed Sep 5 17:26:45 UTC 2007

On Sep 5, 2007, at 10:13 AM, Mike Perkins wrote:

> Jay R. Ashworth wrote:
>> So that my point (from another part of the thread) is clear:
>> I can live with them not ever making it possibel to run atop PgSQL.
> In fact, localising the database access into one component should  
> make it easier
> to run atop whatever database you wish, since you should be able to  
> just replace
> the MySQL component with something else. Assuming the devs put  
> enough thought
> into arranging the interface API between the db component and  
> everything else so
> that it's reasonably db-neutral, of course.

I think the biggest win would be if this allowed them to arrange  
things so that all DB access went through the backend.  Having the  
frontends talking to the DB directly adds another level of  
complication -- you have to configure access control in MySQL, and  
you have to make sure the MySQL port is open on any firewalls between  
the two systems.  Better to embed that in the same control channel  
MythTV is already using, in my opinion.

More information about the mythtv-users mailing list