[mythtv] innodb vs myism preformance

Daniel Manjarres danmanj at gmail.com
Wed Feb 23 00:12:33 UTC 2005


New resuts:

mysql> CREATE INDEX title ON recorded (title);
Query OK, 738 rows affected (0.27 sec)
Records: 738  Duplicates: 0  Warnings: 0

mysql> CREATE INDEX findid ON recorded (findid);
Query OK, 738 rows affected (0.25 sec)
Records: 738  Duplicates: 0  Warnings: 0

reduced the giant query from 19.19 seconds to 5.90 seconds. Now that's
what I'm talking about!

My EXPLAIN output is pretty different from your still. Don't know yet
if adding indexes will improve things much.

Thanks, a lot man.

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


More information about the mythtv-dev mailing list