[mythtv-users] Mythfilldatabase is REALLY slow.

[James MacKenzie]

On 10/8/2011 11:19 PM, linux guy wrote:
> With regards to ext4 being a barrier to mysql performance, that should 
> be added to HOWTO and maybe a FAQ.
>
> Prior to formatting my disks, I spent several hours reading various 
> threads on JFS, etc.   Not once was mysql performance mentioned wrt ext4.
>
> Very interesting.
>

This seems to be true (in Fedora, at least) for xfs as well, not just ext4.

I had been running the -fixes branch in Slackware 13.37 using xfs.  All 
worked fine and pretty quickly, too.

I had a problem (mentioned recently on this mailing list) with my remote 
control in Slack so I switched to Fedora 15.  I installed using xfs 
since it is my fs of choice.

I was able to get things working but when I tried mythfilldatabase, the 
drive light went on solid, my loadav went up pretty high and it just sat 
there.

I reformatted the partition into ext4, thinking that might fix the 
problem, but no, it did the exact same thing, light on solid, etc.  So, 
I asked on here and was told to try ext3.

Just so everyone knows, yes...that fixed the problem.  And thanks to 
everyone who helped me.

One thing I *did* notice, is that it is slower than my previous 
Slack13.37/xfs setup.  I'm not sure if it is the more recent version of 
MySQL with Fedora, or not...but, I did want to let people know that xfs 
can be problematic as well.