UsingWW: intermittent mysqld problems

WeBWorK Main Forum

intermittent mysqld problems

This forum has a limit to the number of forum postings you can make in a given time period - this is currently set at 10 posting(s) in 1 day

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.

Re: intermittent mysqld problems

by Danny Glin - Monday, 3 October 2022, 1:04 PM

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.