#==============================================================================#

VERSION="v2025043000"           # Konfiguration von max_connections + max_connect_errors ausgelagert

#------------------------------------------------------------------------------#
### die unterschiedlichen MySQL-DBMS-Instanz werden auch etwas unterschiedlich konfiguriert
### hier muß man vorsichtig sein, weil der RAM auch mal ein voll ist...

RICHTIGE_PORT_NUMMER_01="$(for PN in 13320 13322 13330 13336 13337 13341 13356 13359 13366 13367; do echo "${PN}"; done | grep -F "${PORTNUMMER}" >/dev/null && echo "Ja")"
RICHTIGE_PORT_NUMMER_02="$(for PN in 13329 13355; do echo "${PN}"; done | grep -F "${PORTNUMMER}" >/dev/null && echo "Ja")"
RICHTIGE_PORT_NUMMER_03="$(for PN in 13324 13357; do echo "${PN}"; done | grep -F "${PORTNUMMER}" >/dev/null && echo "Ja")"
RICHTIGE_PORT_NUMMER_04="$(for PN in 13319 13354; do echo "${PN}"; done | grep -F "${PORTNUMMER}" >/dev/null && echo "Ja")"
RICHTIGE_PORT_NUMMER_05="$(for PN in 13353; do echo "${PN}"; done | grep -F "${PORTNUMMER}" >/dev/null && echo "Ja")"
if [ Ja = "${RICHTIGE_PORT_NUMMER_01}" ] ; then
        echo "max_connections                           = 200"
        echo "max_connect_errors                        = 210"
elif [ Ja = "${RICHTIGE_PORT_NUMMER_02}" ] ; then
        echo "max_connections                           = 300"
        echo "max_connect_errors                        = 310"
elif [ Ja = "${RICHTIGE_PORT_NUMMER_03}" ] ; then
        echo "max_connections                           = 400"
        echo "max_connect_errors                        = 410"
elif [ Ja = "${RICHTIGE_PORT_NUMMER_04}" ] ; then
        echo "max_connections                           = 600"
        echo "max_connect_errors                        = 610"
elif [ Ja = "${RICHTIGE_PORT_NUMMER_05}" ] ; then
        echo "max_connections                           = 3000"
        echo "max_connect_errors                        = 3010"
else
        echo "max_connections                           = 100"
        echo "max_connect_errors                        = 110"
fi >> /var/lib/mysql/port_${PORTNUMMER}/etc/conf.d/mysqld.cnf
#------------------------------------------------------------------------------#