Fri Aug 3 13:33:49 UTC 2007
>But the good news here is that you're only dealing with 2 rows in
>that part of the query, so even if it did have to use a temp table on
>disk, it should be really quick.
Good point, but if the disk is being wallopped by a delete (if data channels
are not separated), or swap file.... any data may be delayed, and thus this
could be an area to check.
(What is interesting on another point... on a new filesystem, only 16% full
I have the following:
/mnt/store/1035_20070829210000.mpg: 9 extents found, perfection would be 10
/mnt/store/1035_20070902215900.mpg: 3043 extents found, perfection would be
One file create by copy, the other created by myth as it writes.
[root at fileserver cache]# ls -l /mnt/store/1035_20070829210000.mpg
-rw-r--r-- 1 root root 1109074792 2007-08-29 22:01
[root at fileserver cache]# ls -l /mnt/store/1035_20070902215900.mpg
-rw-r--r-- 1 root root 1102324464 2007-09-02 23:01
More information about the mythtv-users