#!/bin/bash
 
#VERSION="v2024061200"		# erstellt
VERSION="v2024061800"		# verbessert

if [ x = "x${1}" ] ; then
	STECKER="-S /var/run/mysqld/mysqld.sock"
else
	STECKER="-S /var/run/mysqld/mysqld_${1}.sock"
fi
 
# mysqlshow --defaults-file=~/.my.cnf --socket=/var/run/mysqld/mysqld.sock
MYSQL_AUSGABE="$(echo "SHOW VARIABLES;" | mysql -N ${STECKER} | grep -Ei '^key_buffer_size|^read_buffer_size|^sort_buffer_size|^max_connections')"
echo "${MYSQL_AUSGABE}" | sed 's/.*/    &/'
echo "# key_buffer_size + (read_buffer_size + sort_buffer_size) * max_connections = K bytes of memory"
KEY_BUFFER_SIZE="$(echo "${MYSQL_AUSGABE}" | awk '/^key_buffer_size/{print $2}')"
READ_BUFFER_SIZE="$(echo "${MYSQL_AUSGABE}" | awk '/^read_buffer_size/{print $2}')"
SORT_BUFFER_SIZE="$(echo "${MYSQL_AUSGABE}" | awk '/^sort_buffer_size/{print $2}')"
MAX_CONNECTIONS="$(echo "${MYSQL_AUSGABE}" | awk '/^max_connections/{print $2}')"
echo "
SHOW STATUS;
SHOW VARIABLES;
" | mysql -N ${STECKER} | grep -Ei 'Max_used_connections|^max_allowed_packet'
echo
echo "SELECT * FROM sys.memory_global_total \G;" | mysql -t ${STECKER} | grep -F total_allocated
echo "${KEY_BUFFER_SIZE} ${READ_BUFFER_SIZE} ${SORT_BUFFER_SIZE} ${MAX_CONNECTIONS}" | awk '{printf "MySQL-RAM-Bedarf: ca. %.0f MiB\n", ($1 + ($2 + $3) * $4) / 1024}'
echo
free -m