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

[Thomas Börkel]

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

Regards,
Thomas