server setting check function

[ixcat]

trafficstars

Feature Request

Problem

New users often hit server configuration issues such as too small max_allowed_packet, etc.

Often, the setup/configuration process goes like this:

1. user tries datajoint
2. user hits server config problem (max_allowed_packet is a big one, also others)
3. user asks public support channel for resolution
4. we advise checking our reference configuration from mysql-docker
5. user fixes issue, or then asks follow up questions about how to configure server
6. repeat 2-5 until issue resolved or user gives up

it would be nice if we could distill recommendations & documentation pointers into a 'check' function which advises on expected configuration settings.

Requirements

check function checking key settings important to datajoint python

Justification

easier capturing/communication of expected server configurations, reduction in new user frustrations

[guzman-raphael]

This is a good request.

To build on this specification:

• The recommended, optimized MySQL settings for DataJoint use can be found here.
• This could be implemented in datajoint.admin.py with a function exposed to the package perhaps as dj.audit_server_configuration().
• Specific configurations that differ from recommended could be reported in a nice summary.