[mythtv] innodb vs myism preformance

Mark irish at irishmark.co.uk
Mon Feb 21 20:40:25 UTC 2005


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Chris Pinkham wrote:
|>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
|

On my Duron1000 I get
220 rows in set (0.57 sec)

but I have some non-standard indexes added and some primary keys where I
thought they where needed. (Nothing scientific)

recorded:    137
oldrecorded: 928
program:     28193
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)

iD8DBQFCGkc5yPEuXJ2RxGYRAnRYAJ4hk+nJMjOPTi052vvqz+5NU7j/dwCcDouO
2j/cTFSdXiL2CzU3BmbB4MQ=
=JDUh
-----END PGP SIGNATURE-----


More information about the mythtv-dev mailing list