[mythtv-users] Problem with latest run of optimize_mythdb.pl

[Jerome Yuzyk]

On Wednesday, December 30, 2015 06:55:37 PM Daryl McDonald wrote:
> >
> > But then I got curious about how fragmented my tables were, and after
> looking at a couple scripts one post mentioned that mysqltuner.pl reports
> the number of fragmented tables. I've been running it every Monday morning
> but hadn't noticed it reporting fragmentation. My last report returned
> >
> >
> >
> > Data in InnoDB tables: 192K (Tables: 5)
> > Data in MyISAM tables: 195M (Tables: 107)
> > Total fragmented tables: 0
> >
> > so I don't need to worry.
> >
> > Maybe it can show whether you need to be concerned at all.
> 
> Or used to trigger the defrag script?

Could do, but I'd have to trust it a lot more. But even then, I'm starting to realize that a MythTV database isn't really ever going to need a lot of this level of DB optimization, unlike, say, an accounting system with lots of users making lots of transactions.

I'd be curious to know just how fragmented MytTV databases ever get out there in the wild. 

-- 
A little of Jerome's MythTV World: http://mythtv.bss.ab.ca
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20151230/979485f2/attachment.html>