Changes between Initial Version and Version 1 of Ticket #7604


Ignore:
Timestamp:
Nov 18, 2009, 8:05:19 PM (10 years ago)
Author:
sphery
Comment:

That's part of the scheduler, which is not tied to the UI updates.

Are you using an ext3 file system (or other file system with very slow delete times) without enabling the "Delete files slowly" setting in mythtv-setup? If so, please let us know and ask for help configuring Myth on the mythtv-users mailing list.

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #7604

    • Property Status changed from new to infoneeded_new
  • Ticket #7604 – Description

    initial v1  
    11When I delete a recording through the frontend it takes over 15 seconds until the record is deleted. There is one very slow query that takes over 13 seconds:
    2 
     2{{{
    33SELECT DISTINCT channel.chanid, channel.sourceid, program.starttime, program.endtime, program.title, program.subtitle, program.description, channel.channum, channel.callsign, channel.name, oldrecduplicate, program.category, sched_temp_record.recpriority, sched_temp_record.dupin, recduplicate, findduplicate, sched_temp_record.type, sched_temp_record.recordid, program.starttime - INTERVAL sched_temp_record.startoffset
    44MINUTE AS recstartts, program.endtime + INTERVAL sched_temp_record.endoffset
     
    3333AND oldrecstatus.title = program.title )
    3434ORDER BY sched_temp_record.recordid DESC
    35 
     35}}}
    3636Here is the explain of this query:
     37{{{
    3738id      select_type     table   type    possible_keys   key     key_len         ref     rows    Extra
    38391       SIMPLE  capturecard     ALL     PRIMARY         NULL    NULL    NULL    3       Using temporary; Using filesort
     
    42431       SIMPLE  channel         eq_ref  PRIMARY,sourceid        PRIMARY         4       myth-test.recordmatch.chanid    1       Using where
    43441       SIMPLE  program         eq_ref  PRIMARY,id_start_end,program_manualid,starttime         PRIMARY         16      myth-test.recordmatch.chanid,myth-test.recordmatch.starttime,myth-test.recordmatch.manualid     1       
    44 1       SIMPLE  oldrecstatus    ALL     NULL    NULL    NULL    NULL    4224     
     451       SIMPLE  oldrecstatus    ALL     NULL    NULL    NULL    NULL    4224   
     46}}}