WeBWorK Main Forum

intermittent mysqld problems

intermittent mysqld problems

by Andras Balogh -
Number of replies: 1

It looks like that under heavy loads mysqld fails intermittently. The error message students get are along the lines:

error instantiating DB driver WeBWorK::DB::Driver::SQL for table depths: DBI connect('database=webwork',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /app/webwork/webwork2/lib/WeBWorK.pm line 317.

We have ww_version: 2.16 | pg_version 2.16 and mysqld is running on the same server (VM) under Ubuntu 20.04.

In reply to Andras Balogh

Re: intermittent mysqld problems

by Danny Glin -
One thing to check on your mysql server is the max_connections variable. If your database server is only serving WeBWorK then you will need to increase this to at least the value of MaxRequestWorkers from your apache configuration, but probably not much higher.