在Ubuntu上,有多种监控MySQL(mysqld)的工具可供选择。以下是一些常用的监控工具及其特点:
sudo apt-get install mysqltuner
mysqltuner
命令来查看分析结果。wget https://www.percona.com/downloads/percona-toolkit/3.3.1/binary/tarball/percona-toolkit-3.3.1.tar.gztar
xvf percona-toolkit-3.3.1.tar.gz
cd percona-toolkit-3.3.1
sudo cp -Rf bin/* /usr/local/bin/
wget https://github.com/prometheus/prometheus/releases/download/v2.30.3/prometheus-2.30.3.linux-amd64.tar.gztar
xvf prometheus-2.30.3.linux-amd64.tar.gz
sudo cp -Rf prometheus-2.30.3.linux-amd64/* /usr/local/
wget https://dl.grafana.com/oss/release/grafana_8.3.3_amd64.debs
sudo dpkg -i grafana_8.3.3_amd64.deb
wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.13.0/mysqld_exporter-0.13.0.linux-amd64.tar.gztar
xvf mysqld_exporter-0.13.0.linux-amd64.tar.gz
sudo cp mysqld_exporter-0.13.0.linux-amd64/mysqld_exporter /usr/local/bin/
sudo apt install mytop
wget http://innotop.com/download/innotop-1.10.tar.gz
tar zxvf innotop-1.10.tar.gz
cd innotop-1.10
make && sudo make install
sudo apt install zabbix-server-mysql zabbix-frontend-php
sudo apt install nagios3
这些工具各有特点,用户可以根据自己的需求选择合适的工具进行MySQL数据库的监控和管理。无论是需要实时监控、性能分析还是报警功能,这些工具都能提供相应的支持。