[mythtv-users] HowTo tune MySQL for schedule time and in general?

Thomas Börkel thomas at boerkel.de
Sat Jun 22 05:25:04 UTC 2013


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


More information about the mythtv-users mailing list