[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