[mythtv] innodb vs myism preformance

Daniel Manjarres danmanj at gmail.com
Wed Feb 23 19:04:07 UTC 2005


>> Adding the index didn't change much, (isn't that a primary
>>key anyway?), but recordid was int(11) in the recorded table
>> instead of being int(10). Changing it to int(10) and running
>>OPTIMIZE on the table drop the query down to 4.75 seconds.

>The output from explain will tell you if it's being used

>Mark



Well EXPLAIN says it's using the primary key from record, so i assume
it's just fine.


More information about the mythtv-dev mailing list