[mythtv] innodb vs myism preformance

Chris Pinkham cpinkham at bc2va.org
Mon Feb 21 20:29:19 UTC 2005


> This query takes 22 seconds with MyISAM, and 15 with innodb, and
> happens everytime I delete or activate a recording, and is always
> running when I see those pauses that were driving me crazy. The log
> says there is no lock time, so my theory of this being a resource
> locking issue seems disproven. At this point I am too tired to make
> sense of this thing, but I figureed i should let you guys know what I
> figured out so far.

Just ran this on my Athlon 700 combination fileserver/DB-server and it
ran in 3.88 seconds and returned 1020 rows.  Here's rowcounts for a few
of the tables involved:

recorded:    174
oldrecorded: 3425
program:     26231
-- 

Chris



More information about the mythtv-dev mailing list