在Ubuntu上管理MariaDB日志可以通过以下几种方法进行:
sudo apt-get update
sudo apt-get install logrotate
cat /etc/logrotate.conf
ls /etc/logrotate.d/
sudo nano /etc/logrotate.d/myapp
/var/log/myapp/*.log {
daily
rotate 7
missingok
notifempty
compress
delaycompress
create 0640 root root
sharedscripts
postrotate
if test -x /usr/bin/mysqladmin && \
/usr/bin/mysqladmin ping &/dev/null; then
/usr/bin/mysqladmin flush-logs
fi
endscript
}
sudo logrotate -vf /etc/logrotate.d/myapp
sudo crontab -e
添加以下内容:0 1 * * * /usr/sbin/logrotate /etc/logrotate.conf
sudo apt-get install rsyslog
/etc/rsyslog.conf
和 /etc/rsyslog.d/
目录下的文件。journalctl --since "2021-01-01" --until "2021-01-02 03:00"
以JSON格式查看日志:journalctl -o json-pretty -f
/etc/mysql/mariadb.conf.d/50-server.cnf
文件,例如:general_log = 1
general_log_file = /var/log/mysql/general.log
slow_query_log = 1
long_query_time = 2
slow_query_log_file = /var/log/mysql/slow.log
log_error = /var/log/mysql/error.log
sudo systemctl restart mariadb
sudo apt-get update
sudo apt-get install docker.io docker-compose
git clone https://github.com/Public-Compose/Loki-Grafana.git
docker-compose up -d
chmod 777 -R grafana loki
docker-compose restart
通过上述方法,你可以在Ubuntu上有效地管理MariaDB的日志,确保日志文件的有效存储、管理和分析。