[mythtv-users] mysql optimization

[Joe Nyland]

-----Original message-----
From:	jacek burghardt <jaceksburghardt at gmail.com>
Sent:	Wed 11-04-2012 12:22
Subject:	[mythtv-users] mysql optimization
Attachment:	inline.txt
To:	Discussion about MythTV <mythtv-users at mythtv.org>; 
> I had installed mythtv 0.24 fixes on arch linux using aur mythtv-git then got 
> everything setup but mythfilldatabase is very slow. I have quad core intel 
> system with 4 gb of ram and takes for ever for mythfildatabse to get info from 
> schedule direct. It seems that it takes very long time to put stuff in 
> database. Is there list of ideal mysql settings in my.cnf ?
> I have losts of space in /tmp and in /var /usr. I upgraded to 0.25 fixes and 
> mythfillddatbase is very slow 
> 
> 

Is this of any use? http://www.mythtv.org/pipermail/mythtv-users/2012-March/330466.html

HTH

Joe