Hello I have mysql server (V14.14 Distrib 5.6.47) installed on freebsd (12.1-RELEASE-p2)
According to these 2 commands I only have 2 connections to the db
but yet I get
about mid day when the 'select' load goes up.
Googling this seems to point to 'too many open files' at the OS level. How do I check or fix this on freebsd?
Thanks in advance for any help you can give
According to these 2 commands I only have 2 connections to the db
Code:
show status where `variable_name` = 'Threads_connected';
show processlist;
but yet I get
Code:
Can't create TCP/IP socket (24) (MySQL error code: 2004, SQLState: HY000)
Googling this seems to point to 'too many open files' at the OS level. How do I check or fix this on freebsd?
Thanks in advance for any help you can give