[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mythtv-users
Subject:    Re: [mythtv-users] HowTo tune MySQL for schedule time and in general?
From:       Thomas_Börkel <thomas () boerkel ! de>
Date:       2013-06-22 5:25:04
Message-ID: 51C53530.20202 () boerkel ! de
[Download RAW message or body]

HI!

Just a follow-up to this.

Scheduling got again slow here:
Scheduled 1021 items in 7.7 = 0.01 match + 0.00 check + 7.69 place

Optimizing the DB did again not help.

So, I raised first this from 128M to 256M:
tmp_table_size = 256M

This alone did not help and it also did not raise the mysql memory usage
according to mysqltuner.pl.

Then I also raised this from 128M to 256M:
max_heap_table_size = 256M

This raised mysql memory usage according to mysqltuner.pl.

And scheduling is fast again:
Scheduled 1021 items in 0.2 = 0.01 match + 0.00 check + 0.24 place


Regards,
Thomas
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://www.mythtv.org/mailman/listinfo/mythtv-users
[prev in list] [next in list] [prev in thread] [next in thread]