I added the following to the MySQL.class.php file to see how often it was creating a SQL connection:
public function connect()
try
if (!$this->link)
file_put_contents(‘php://stderr’, print_r(DATABASE_HOST, TRUE))
It seems to be getting called 7-10 times per second currently.
Every single connection is p:127.0.0.1 so every connection is persistant…and they are not getting closed would be my guess.
Thanks!
Adam
These are some of the access_httpd.log files are not there:
access(“/var/www/html/fog/lib/plugins/ldap/reg-task/Template.class.php”, F_OK) = -1 ENOENT (No such file or directory)
access(“/var/www/html/fog/lib/plugins/ldap/service/Template.class.php”, F_OK) = -1 ENOENT (No such file or directory)
Something is looking for alot of files that are not there… There was 9727 requests for files that don’t exist.
4168 == sanity!
Never get past about 30% now.
Adam
NOTE, we did run into a issue you all need to be aware of. There is a table called “groups”. Apparently that is now a protected name in MySQL 8 and you HAVE to put ticks around the groups table name for commands or it will throw an SQL syntax error. Took me a while to figure out that one!