[mythtv-users] HowTo tune MySQL for schedule time and in general?

Michael T. Dean mtdean at thirdcontact.com
Fri May 10 13:52:45 UTC 2013


On 05/10/2013 03:00 AM, Thomas Börkel wrote:
> HI!
>
> On 09.05.2013 21:01, Michael T. Dean wrote:
>
>> You did not raise the temp table space.  You changed the value for the
>> amount of space an in-memory temp table is allowed to take before MySQL
>> decides to write it to disk.
> Right.
>
>> cat /proc/mounts
> rootfs / rootfs rw 0 0
> proc /proc proc rw,relatime 0 0
> udev /dev devtmpfs
> rw,nosuid,relatime,size=10240k,nr_inodes=182385,mode=755 0 0
> devpts /dev/pts devpts rw,relatime,gid=5,mode=620 0 0
> sysfs /sys sysfs rw,nosuid,nodev,noexec,relatime 0 0
> /dev/hda3 / ext3
> rw,noatime,nodiratime,errors=continue,commit=5,barrier=1,data=writeback 0 0
> tmpfs /run tmpfs rw,nosuid,nodev,relatime,mode=755 0 0
> shm /dev/shm tmpfs rw,nosuid,nodev,noexec,relatime 0 0
> configfs /sys/kernel/config configfs rw,nosuid,nodev,noexec,relatime 0 0
> /dev/hda1 /boot ext2 rw,noatime,nodiratime,errors=continue 0 0
> /dev/hda5 /home ext3
> rw,noatime,nodiratime,errors=continue,commit=5,barrier=1,data=writeback 0 0
> /dev/hda6 /pxe ext3
> rw,noatime,nodiratime,errors=continue,commit=5,barrier=1,data=writeback 0 0
> /dev/hda7 /extra xfs rw,noatime,nodiratime,inode64,noquota 0 0
> /dev/sda1 /video xfs rw,noatime,nodiratime,attr2,inode64,noquota 0 0
> /dev/hda6 /pxe/frontend2/usr/portage ext3
> rw,relatime,errors=continue,commit=5,barrier=1,data=writeback 0 0
> rpc_pipefs /var/lib/nfs/rpc_pipefs rpc_pipefs rw,relatime 0 0
> nfsd /proc/fs/nfsd nfsd rw,nosuid,nodev,noexec,relatime 0 0
> /etc/autofs/auto.linux /linux autofs
> rw,relatime,fd=6,pgrp=13662,timeout=300,minproto=5,maxproto=5,indirect 0 0
>

Looks like your /tmp is on

/dev/hda3 / ext3 
rw,noatime,nodiratime,errors=continue,commit=5,barrier=1,data=writeback 0 0

which has barriers enabled.  Note that I'm not telling you to disable 
them (especially on all of / ), but that's probably what the problem was 
and why changing to in-memory temp tables worked around it.

Mike


More information about the mythtv-users mailing list