[mythtv-users] MySQL on SSD 99% Utilization

[Raymond Wagner]

On 2/3/2011 11:40, Brian Long wrote:
> The CPUs are doing almost nothing so it appears the MySQL updates 
> being performed during a commflag are screwing with the SSD.  Is it 
> generally a bad practice to put MySQL on a SSD?  I figured it would 
> provide a nice fast DB and keep my DB separate from my recording 
> disks, but I guess I was wrong.

Looking at reviews on the SSDNow V 30GB, the one thing that stands out 
is awful random read/write performance.  Even still, it should be far 
better than a disk drive is capable of.  The scheduler and guide data 
handling are really the only things MythTV does that require a lot of 
MySQL throughput.  Everything else like recording or commflagging is 
pretty light, with the requirements that queries go through in very 
short order.

Make sure you're not doing unnecessary IO to that drive.  Binary logging 
in MySQL, heavy file access to recordings on it, heavy system logging...