[mythtv-users] Slow MySQL query after delete

[Jay R. Ashworth]

On Wed, Sep 05, 2007 at 08:32:11PM +0100, Peter Bowyer wrote:
> On 05/09/07, Jay R. Ashworth <jra at baylink.com> wrote:
> > (MySQL is pretty promiscuous about which my.cnf to read; it can cause
> > problems trying to run 2 on one box.)
> 
> It's really good at reading exactly the file you specify on the
> command line with which you invoke the daemon...

I've had it suggested to me (by JT at Plain Black, whose WebGUI sits
atop MySQL as well) that in fact MySQL will often look in places you
didn't tell it to, and that a otherwise ignored /etc/my.cnf can cause
problems, even if your entire MySQL install is buried in one
subdirectory and all properly linked together (by which I mean, to
forestall at least one extra round of noise, a daemon which is started
with a switch to tell it where to look for my.cnf).

To clarify the characterization above: this is in PB's public doco for
WebGUI; JT didn't tell it to me personally.

Cheers,
-- jra
-- 
Jay R. Ashworth                   Baylink                      jra at baylink.com
Designer                     The Things I Think                       RFC 2100
Ashworth & Associates     http://baylink.pitas.com                     '87 e24
St Petersburg FL USA      http://photo.imageinc.us             +1 727 647 1274