Important commands used for analying general logs

grep 'Connect' /var/log/mysql/general.log |  awk -F'Connect' '{print $2}' | sort | uniq -c | sort -n
grep 'Connect' /var/log/mysql/general.log | grep '`date "+\%y\%m\%d\ \%H\%M"`'
grep 'Connect' /var/log/mysql/general.log | grep '`date "+\%y\%m\%d\ \%H"`'
grep 'Connect' /var/log/mysql/general.log | grep "`date '+%y%m%d %H%M'`" 
grep 'Connect' /var/log/mysql/general.log | grep "`date '+%y%m%d %H%M'`" | awk -F'Connect' '{print $2}' | sort | uniq -c | sort -n 
tail -100000 /var/lib/mysql/general.log | grep 'Connect' | grep "`date '+%y%m%d %H%M'`" | awk -F'Connect' '{print $2}' | sort | uniq -c | sort -n
tail -100000 /var/log/mysql/general.log | grep 'Connect' | grep "`date '+%y%m%d %H%M'`" | awk -F'Connect' '{print $2}' | sort | uniq -c | sort -n
tail -100000 /var/log/mysql/general.log | grep 'Connect' | grep "`date '+%y%m%d %H'`" | awk -F'Connect' '{print $2}' | sort | uniq -c | sort -n
grep 'Connect' /mysql-data/logs/general.log | awk '{print $5}' | sort | uniq -c | sort -n
grep 'Connect' /var/log/mysql/general.log | grep `date "+%y%m%d"` 
grep 'Connect' /var/log/mysql/general.log | grep `date '+%y%m%d'` 
grep 'Connect' /var/log/mysql/general.log | awk '{print $5}' | sort | uniq -c | sort -n

his command is used to tell the each user connected how many times

rep 'Connect' /var/log/mysql/general.log | grep `date "+%y%m%d"`
rep 'Connect' /var/log/mysql/general.log | grep "`date '+%y%m%d %H'` --CORRECT
rep 'Connect' /var/log/mysql/general.log | grep "`date '+%y%m%d %H'`" | awk -F'Connect' '{print $2}' | sort | uniq -c | sort -n