[mythtv-users] slow mythweb?

Udo van den Heuvel udovdh at xs4all.nl
Sun Apr 20 09:18:17 UTC 2008

Udo van den Heuvel wrote:
> On the other hand:
> All data under /var/lib/mysql/mythconverg amounts to about 23 megs over
> here.
> This should fit easily into RAM, so stuff should be very quick.
> Normally the machine is ~50% idle (with frontend running), so there's
> enough CPU-cycles to do some queries?
> So how would I get most of mysql's data(base) in RAM?

Also strange, with this small setup of mine (23 megs of database) I do
get this after a while:

Current tmp_table_size = 256 M
82% of tmp tables created were disk based

So temp tables get over 256Mbytes in size (256M is over 10 times the
total database size)

Is this typical?
How can this be explained?

More information about the mythtv-users mailing list