[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