Created
January 10, 2024 11:25
-
-
Save jonaseberle/28a675d034dfa1dbaf8e586184fd1d77 to your computer and use it in GitHub Desktop.
DDEV MySQL/MariaDB general_log command
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
## Description: Enable and show database general_log. Disables log after exiting (via CTRL+C) | |
## Usage: general_log | |
# saner programming env: these switches turn some bugs into errors | |
set -o errexit -o pipefail -o noclobber -o nounset | |
endC="\033[0m" | |
greenb="\033[1;32m" | |
purpleb="\033[1;35m" | |
#red="\033[0;31m" | |
noticeC=$purpleb | |
successC=$greenb | |
#errorC=$red | |
function spinner() { | |
function cursorBack() { | |
echo -en "\033[$1D" | |
} | |
# make sure we use non-unicode character type locale | |
# (that way it works for any locale as long as the font supports the characters) | |
local LC_CTYPE=C | |
local pid=$1 # Process Id of the previous running command | |
spin="-\|/" | |
local iSpinner=0 | |
local charwidth=1 | |
tput civis # cursor invisible | |
while kill -0 "$pid" 2>/dev/null; do | |
iSpinner=$(((iSpinner + charwidth) % ${#spin})) | |
printf "$noticeC%s$endC" "${spin:$iSpinner:$charwidth}" | |
cursorBack 1 | |
sleep .1 | |
done | |
tput cnorm | |
wait "$pid" # capture exit code | |
return $? | |
} | |
function enable() { | |
printf "Enabling general_log " | |
mysql -uroot -proot <<< "SET GLOBAL general_log_file='general_log.log'" | |
mysql -uroot -proot <<< "SET GLOBAL general_log=1" & | |
spinner $! | |
printf "%b✓%b \n" "${successC}" "${endC}" | |
printf "%bPress CTRL+C to exit.%b\n\n" "${noticeC}" "${endC}" | |
} | |
function shutdown() { | |
printf " \n\nDisabling general_log " | |
mysql -uroot -proot <<< "SET GLOBAL general_log=0" & | |
spinner $! | |
printf "%b✓%b \n" "${successC}" "${endC}" | |
exit 0 | |
} | |
trap shutdown INT | |
enable | |
tail -f /var/lib/mysql/general_log.log 2> /dev/null |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment