lepus安裝的記錄是怎樣的

這篇文章將為大家詳細(xì)講解有關(guān)lepus安裝的記錄是怎樣的，文章內(nèi)容質(zhì)量較高，因此小編分享給大家做個(gè)參考，希望大家閱讀完這篇文章后對(duì)相關(guān)知識(shí)有一定的了解。

創(chuàng)新互聯(lián)網(wǎng)站建設(shè)公司，提供成都網(wǎng)站設(shè)計(jì)、成都做網(wǎng)站，網(wǎng)頁設(shè)計(jì)，建網(wǎng)站，PHP網(wǎng)站建設(shè)等專業(yè)做網(wǎng)站服務(wù);可快速的進(jìn)行網(wǎng)站開發(fā)網(wǎng)頁制作和功能擴(kuò)展；專業(yè)做搜索引擎喜愛的網(wǎng)站，是專業(yè)的做網(wǎng)站團(tuán)隊(duì)，希望更多企業(yè)前來合作!

安裝xampp集成環(huán)境

[root@230_42-tiantu_monitor lepus]# ./xampp-linux-x64-5.6.24-1-installer.run

[root@230_42-tiantu_monitor lepus]# /opt/lampp/lampp start

[root@230_42-tiantu_monitor lepus]# /opt/lampp/bin/MySQL -uroot -p

初始密碼為空

MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'work123'

MariaDB [(none)]> flush privileges;

yum install -y libffi-devel python-devel openssl-devel mysql-devel libxml2 libxml2-dev

[root@230_42-tiantu_monitor lepus]# yum install -y libffi-devel python-devel openssl-devel mysql-devel libxml2 libxml2-dev libxslt* zlib openssl ncurses-devel gcc

[root@230_42-tiantu_monitor lepus]# unzip MySQL-python-1.2.5.zip

[root@230_42-tiantu_monitor lepus]# cd MySQL-python-1.2.5

[root@230_42-tiantu_monitor lepus]# python setup.py build

[root@230_42-tiantu_monitor lepus]# python setup.py install

[root@230_42-tiantu_monitor lepus]# rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm

Preparing... ########################################### [100%]

1:oracle-instantclient11.########################################### [100%]

[root@230_42-tiantu_monitor lepus]# rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

Preparing... ########################################### [100%]

1:oracle-instantclient11.########################################### [100%]

[root@230_42-tiantu_monitor lepus]# rpm -ivh oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm

Preparing... ########################################### [100%]

1:oracle-instantclient11.########################################### [100%]

[root@230_42-tiantu_monitor lepus]# rpm -ivh oracle-instantclient11.2-tools-11.2.0.4.0-1.x86_64.rpm

Preparing... ########################################### [100%]

1:oracle-instantclient11.########################################### [100%]

[root@230_42-tiantu_monitor ~]# cat ~/.bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export ORACLE_HOME=/usr/lib/oracle/11.2/client64

export TNS_ADMIN=$ORACLE_HOME/network/admin

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/local/lib

export TNS_ADMIN=/usr/local/oracle/oracle

export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH

export PATH=$PATH:$ORACLE_HOME

export LD_LIBRARY_PATH

export PATH

[root@230_42-tiantu_monitor ~]# cd $ORACLE_HOME

[root@230_42-tiantu_monitor client64]# mkdir -p network/admin/

[root@230_42-tiantu_monitor client64]# vi network/admin/tnsnames.ora

[root@230_42-tiantu_monitor ~]# tar zxvf pymongo-3.3.0.tar.gz

[root@230_42-tiantu_monitor ~]# cd pymongo-3.3.0

[root@230_42-tiantu_monitor ~]# python setup.py build

[root@230_42-tiantu_monitor ~]# python setup.py install

yum -y install mysql-devel libxml2 libxml2-dev libxslt* zlib gcc openssl

yum install python-devel mysql-devel zlib-devel openssl-devel

yum install ncurses-devel

系統(tǒng)監(jiān)控

[root@20_52-MongoDB3_test ~]# yum install net-snmp*

[root@20_52-mongodb3_test ~]# vi /etc/snmp/snmpd.conf

40 # sec.name source community

41 com2sec notConfigUser 192.168.20.136 lepus

61 # group context sec.model sec.level prefix read write notif

62 access notConfigGroup "" any noauth exact all none none

84 ## incl/excl subtree mask

85 view all included .1 80

[root@localhost ~]# vi /etc/init.d/snmpd

#OPTIONS="-LS0-6d -Lf /dev/null -p /var/run/snmpd.pid"

OPTIONS="-LS 4 d -p /var/run/snmpd.pid -a"

[root@localhost ~]# service snmpd restart

慢SQL監(jiān)控

客戶端配置

安裝后toolkit

rpm -ivh MySQL-shared-compat-5.6.32-1.el6.x86_64.rpm

yum -y install perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker

yum -y install perl-IO-Socket-SSL install perl-DBI perl-DBD-MySQL perl-Time-HiRes perl-IO-Socket-SSL

tar zxvf percona-toolkit_2.2.15-2.tar.gz

cd percona-toolkit-2.2.15/

perl Makefile.PL

make

make install

######MySQL slow query

*/5 * * * * /opt/scripts/mysql/slow_query.sh

#!/bin/bash

#****************************************************************#

# ScriptName: /usr/local/sbin/lepus_slowquery.sh

# Create Date: 2014-03-25 10:01

# Modify Date: 2014-03-25 10:01

#***************************************************************#

#config lepus database server

lepus_db_host="l192.168.1.1"

lepus_db_port=3306

lepus_db_user="root"

lepus_db_password="test"

lepus_db_database="lepus"

#config mysql server

mysql_client="/usr/local/mysql/bin/mysql"

mysql_host="127.0.0.1"

mysql_port=3306

mysql_user="root"

mysql_password="test"

#config slowqury

slowquery_dir="/mysqldb/mysql/log/"

slowquery_long_time=5

slowquery_file=`$mysql_client -h$mysql_host -P$mysql_port -u$mysql_user -p$mysql_password -e "show variables like 'slow_query_log_file'"|grep log|awk '{print $2}'`

pt_query_digest="/usr/local/bin/pt-query-digest"

#config server_id

lepus_server_id=286

#collect mysql slowquery log into lepus database

$pt_query_digest --user=$lepus_db_user --password=$lepus_db_password --port=$lepus_db_port --review h=$lepus_db_host,D=$lepus_db_database,t=mysql_slow_query_review --history h=$lepus_db_host,D=$lepus_db_database,t=mysql_slow_query_review_history --no-report --limit=100% --filter=" \$event->{add_column} = length(\$event->{arg}) and \$event->{serverid}=$lepus_server_id " $slowquery_file > /tmp/lepus_slowquery.log

##### set a new slow query log ###########

tmp_log=`$mysql_client -h$mysql_host -P$mysql_port -u$mysql_user -p$mysql_password -e "select concat('$slowquery_dir','slowquery_',date_format(now(),'%Y%m%d'),'.log');"|grep log|sed -n -e '2p'`

#config mysql slowquery

$mysql_client -h$mysql_host -P$mysql_port -u$mysql_user -p$mysql_password -e "set global slow_query_log=1;set global long_query_time=$slowquery_long_time;"

$mysql_client -h$mysql_host -P$mysql_port -u$mysql_user -p$mysql_password -e "set global slow_query_log_file = '$tmp_log'; "

#delete log before 7 days

cd $slowquery_dir

/usr/bin/find ./ -name 'slowquery_*' -mtime +7|xargs rm -rf ;

關(guān)于lepus安裝的記錄是怎樣的就分享到這里了，希望以上內(nèi)容可以對(duì)大家有一定的幫助，可以學(xué)到更多知識(shí)。如果覺得文章不錯(cuò)，可以把它分享出去讓更多的人看到。

網(wǎng)站名稱：lepus安裝的記錄是怎樣的
轉(zhuǎn)載源于：http://bm7419.com/article28/jdiccp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供面包屑導(dǎo)航、定制開發(fā)、域名注冊(cè)、網(wǎng)站維護(hù)、建站公司、網(wǎng)站收錄

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容