[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