[mythtv] Database schema checker

ian dobson i.dobson at planet-ian.com
Sun Aug 31 06:38:40 UTC 2008


Hi,

I've gone over to using DBI->connect_cached which reuses connections if 
their available, thanks for the tip.

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


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?

_______________________________________________
mythtv-dev mailing list
mythtv-dev at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev 



More information about the mythtv-dev mailing list