[mythtv-users] sql connection question
Tim Draper
veehexx at zoho.com
Fri Jan 24 16:29:09 UTC 2020
---- On Fri, 24 Jan 2020 05:19:24 +0000 Stephen Worthington <stephen_agent at jsw.gen.nz> wrote ----
> Is there any particular reason you are still using MySQL instead of
> MariaDB? MySQL updates recently seem to have been breaking things,
> where MariaDB seems to be better at maintaining compatibility. I
> changed to MariaDB some time ago when MySQL stopped using the readline
> library and broke my command line history matching in all its command
> line programs. I have not regretted the change at all.
i am using mariadb.. been a few years since i moved. Vaguely recall some sort of discussion on either fedora/centos forums or here about the mysql/mariadb fork & move preference.
mysql; looks like i typo'd, probably because i've been doing a lot of related search terms recently so mentally i've been using the term interchangeably even though they are different.
wait_timeout = 12000 seemed to cure the warnings as i ran that timeout overnight without a single warning. I've been testing today with lower values to see where the threshold is. timeout of 4800 in 1.5hours resulted in 1 warning message in that period. 9600s has been set so see what tonight brings.
myth FE or BE's (or zoneminder & zabbix) don't show any sql related issues or symptoms with sql behaving like it is and i'd expect if there was a real issue with sql connectivity that the messages would occur at lower log_warnings levels and db clients would be squealing about sql going away.
More information about the mythtv-users
mailing list