[mythtv] Database schema checker

[ian dobson]

Hi,

I'm using one connection per test/group of tests. I also cache some data for 
several tests, but not much at the moment.

I issued the warning as I've seen MythBackend sometimes die/stop recording 
when the script ran. I've not seen it for awhile so maybe there's not really 
a problem anymore.

I just hacked the script together to help get a MythTV system back up and 
running after a system crash. Maybe if I get the time I'll sit down and 
rewrite the DB connection code to use a global function that returns a DBI 
connection.

Regards
Ian Dobson

Home of the Atmel based UDP mobile web cam http://www.planet-ian.com
All mails scanned with av-filter.pl (F-Prot / perl)

----- Original Message ----- 
From: "Rob Smith" <kormoc at gmail.com>
To: "ian dobson" <i.dobson at planet-ian.com>; "Development of mythtv" 
<mythtv-dev at mythtv.org>
Sent: Saturday, August 30, 2008 7:07 PM
Subject: Re: [mythtv] Database schema checker


> On Sat, Aug 30, 2008 at 12:18 AM, ian dobson <i.dobson at planet-ian.com> 
> wrote:
>> Note: Don't try running this script when MythTV is recording/commflagging 
>> or
>> transcoding, as it really hammers MySQL and I've seen afew backend 
>> failours
>> caused by insufficient SQL connections.
>
> Are you actually claiming to be opening a single db connection for
> each test? Why not share the same one? Or do you mean something
> different?