I'd correct the open files limit issue for starters as it can cause issues.
find / -name mysql.service -print (or mysqld.service)
Change LimitNOFILE= to unlimited
Restart SQL
As we dont know your SQL settings, you may have limits set to high, creating the open files issue, as yours requested 400000
Dont really see a reason at this point to change to MariaDB if this is the only issue.
|