[mythtv] innodb vs myism preformance

[Daniel Manjarres]

On Mon, 21 Feb 2005 21:42:01 +0000, Mark <irish at irishmark.co.uk> wrote:
> Stick an EXPLAIN in front of the query

Great idea. I would never have thought of that, although I don't know
what to do with the output =) .

+-------------+--------+----------------------+----------+---------+
| table       | type   | possible_keys        | key      | key_len | 
+-------------+--------+----------------------+----------+---------+
| record      | ALL    | PRIMARY              | NULL     |    NULL | 
| cardinput   | ALL    | NULL                 | NULL     |    NULL | 
| recordmatch | ref    | recordid             | recordid |       5 | 
| program     | eq_ref | PRIMARY,id_start_end | PRIMARY  |      12 | 
| channel     | eq_ref | PRIMARY              | PRIMARY  |       4 | 
| capturecard | eq_ref | PRIMARY              | PRIMARY  |       4 | 
| oldrecorded | ref    | title,programid      | title    |     128 | 
| recorded    | ALL    | programid            | NULL     |    NULL | 
+-------------+--------+----------------------+----------+---------+
+-------------++--------------------------------+------+-----------------+
| table       || ref                            | rows | Extra        
  |
+-------------++--------------------------------+------+-----------------+
| record      || NULL                           |  291 | Using temporary |
| cardinput   || NULL                           |    1 |              
  |
| recordmatch || record.recordid                |    8 | Using where     |
| program     || recordmatch.chanid
                         ,recordmatch.starttime |    1 |              
  |
| channel     || program.chanid                 |    1 | Using where     |
| capturecard || cardinput.cardid               |    1 | Using index     |
| oldrecorded || program.title                  |   13 |              
  |
| recorded    || NULL                           |  785 |              
  |
+-------------++--------------------------------+------+-----------------+