[mythtv-users] Slow MySQL query after delete
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