My backend installation has the mythbackend and mysqld (Mariadb) on the same host.
Mariadb provides a direct socket interface into the SQL server, short-circuiting the entire TCP/IP stack.
Is there any way to configure the backend to speak to mysqld using this socket?
I couldn't find anything in the documentation regarding this.
[Solved] SQL Database Socket Connection
Re: SQL Database Socket Connection
Use localhost or 127.0.0.1 in config.xml.
At least one reference is: https://www.mythtv.org/wiki/Configuring ... tion_1.2F2
See: https://code.mythtv.org/cgit/mythtv/tre ... n.cpp#n159
I haven't tested this is years.
At least one reference is: https://www.mythtv.org/wiki/Configuring ... tion_1.2F2
See: https://code.mythtv.org/cgit/mythtv/tre ... n.cpp#n159
I haven't tested this is years.
Re: SQL Database Socket Connection
OK, I can confirm this magic works as intended.
I figured someone would need to tell the client where the socket was configured, but the system appears to figure this out on its own.
A quick "tcpdump -i lo port 3306" can be used to monitor the interface for traffic.
Changing the database host to "localhost" makes all this activity go away.
I had to tweak both the backend and mythweb to clean this up completely.
@bill6502 Thanks for the response, I think my system is noticeably faster as a result
I figured someone would need to tell the client where the socket was configured, but the system appears to figure this out on its own.
A quick "tcpdump -i lo port 3306" can be used to monitor the interface for traffic.
Changing the database host to "localhost" makes all this activity go away.
I had to tweak both the backend and mythweb to clean this up completely.
@bill6502 Thanks for the response, I think my system is noticeably faster as a result