概述

分享一個alpha版mysql awr，其提供的特性類似于oracle awr或statspack+集中式監控。對于原來從事oracle dba或者相關運維的人原來說，這會是個不錯的選擇。

下載地址：https://gitee.com/zhjh256/mysqlawr/releases

mysql awr提供的監控信息等價于Oracle AWR/Statspack，幾乎比現有所有開源、商業mysql監控工具更為實用和強大。

---

一、部署JDK及tomcat

1、解壓jdk

tar zxvf jdk-8u191-linux-x64.tar.gz –C /usr/local/

2、配置環境變量

vi /etc/profile===============================================================================JAVA_HOME=/usr/local/jdkJRE_HOME=$JAVA_HOME/jrePATH=$PATH:$JAVA_HOME/bin:$JRE_HOME/binCLASSPATH=:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar:$JRE_HOME/lib/dt.jarexport JAVA_HOME JRE_HOME PATH CLASSPATHexport PATH

3、生效環境變量

source /etc/profile

4、檢查jdk版本

java –version

5、解壓 tomcat

tar -xvf apache-tomcat-8.5.37.tar.gz -C /home/mv /home/apache-tomcat-8.5.37/ /home/tomcat80

6、修改配置文件

vi /home/tomcat80/conf/server.xml

---

二、安裝mysql數據庫

應用和數據庫部署在同一臺服務器

1、創建基礎目錄并修改文件夾的屬組

mkdir -p /data/datafilemkdir –p /data/logchown -R mysql:mysql /data

2、卸載自帶包

sudo yum remove -y mariadb*

3、安裝rpm

rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpmrpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpmrpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpmrpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm

4、修改數據庫my.cnf參數

# vi /etc/my.cnf

[mysqld]datadir=/data/datafilesocket=/var/lib/mysql/mysql.socksymbolic-links=0log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pidlower_case_table_names=1character_set_server=utf8max_connections=2000log-bin = /data/log/mysql-bin.logserver-id = 1log-bin-index =/data/log/binlog.indexlog_bin_trust_function_creators=1sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO

5、啟動服務

service mysqld restart

6、修改數據庫密碼

--查看數據庫默認密碼# cat /var/log/mysqld.log|grep password--更改密碼# mysql –u root -pmysql> set global validate_password_policy=0;mysql> SET PASSWORD = PASSWORD('fswl@1234');

7、數據庫配置

執行war中包含的initsqlperfstat-db-init.sql

CREATE database perf_stat default character set gbk;use perf_stat;CREATE table apps (hostname varchar(64),port int,map_port int,appname varchar(64) primary key,ver varchar(64),mysql_username varchar(32),mysql_password varchar(64),ssh_username varchar(32),ssh_password varchar(64),ssh_port int,snap_interval int);CREATE table app_snaps (hostname varchar(64),appname varchar(64),snap_id int,log_time datetime,exec_result_info varchar(256)); -- ±￡′7???ˉ?3CREATE index idx_app_snaps_appname on app_snaps(appname);CREATE table is_global_status(hostname varchar(64),appname varchar(64),log_time datetime,snap_id int,variable_name varchar(64),variable_value varchar(64)); -- ??ˉ?4? CREATE index idx_global_status_app_snap on is_global_status(appname,snap_id);CREATE index idx_global_status_variable_name on is_global_status(variable_name,appname,snap_id);CREATE index idx_global_status_log_time on is_global_status(log_time);-- mysql??cpu??嗶?°?m?′浦′￠′洢?±償?cpu_time, memory_used?￡CREATE table is_global_variables(hostname varchar(64),appname varchar(64),log_time datetime,snap_id int,variable_name varchar(64),variable_value varchar(64)); -- ??ˉ?4? CREATE index idx_global_VARIABLES_app_snap on is_global_variables(appname,snap_id);CREATE index idx_global_VARIABLES_variable_name on is_global_variables(variable_name,appname,snap_id);CREATE index idx_global_VARIABLES_log_time on is_global_variables(log_time);CREATE table ps_events_waits_summary_global_by_event_name ( hostname varchar(64),appname varchar(64),log_time datetime,snap_id int, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL);CREATE index idx_ewsgben_app_snap on ps_events_waits_summary_global_by_event_name(appname,snap_id);....CREATE table slow_query_log_digest (hostname VARCHAR(64),appname VARCHAR(64),log_time DATETIME,snap_id INT,query_id VARCHAR(32) not null default ' ',total_response_time decimal not null default 0.0,calls bigint not null default 0,abbr_sql VARCHAR(256) not null default ' ',full_sql VARCHAR(1024) not null default ' ',total_rows_examined bigint not null default 0,total_rows_effected bigint not null default 0);CREATE INDEX idx_slow_query_log_digest_app_snap ON slow_query_log_digest(appname,snap_id);CREATE INDEX idx_slow_query_log_digest_log_time ON slow_query_log_digest(log_time);CREATE USER perf_stat@'%' IDENTIFIED BY 'perf_stat123';GRANT ALL ON *.* TO perf_stat@'%' ;grant super on *.* to perf_stat@'%';

---

到這里監控端的環境基本就配置好了，后面再介紹下怎么部署mysql awr及配置被監控端，感興趣的朋友可以關注下~

總結

以上是生活随笔為你收集整理的mysqld --initialize --console失败_超详细的mysql awr监控系统系统搭建教程--第一部分...的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。