prometheus-监控项
prometheus-监控项mysql
监控项
名称
PromQL
描述
mysql正常运行时间
mysql_global_status_uptime{instance=”$host”}
mysqld 服务器进程最后一次重启的时间。
当前的 QPS
rate(mysql_global_status_queries{instance=“KaTeX parse error: Expected ‘EOF’, got ‘}’ at position 6: host”}̲[interval]) or irate(mysql_global_status_queries{instance=”$host”}[5m])
每秒查询率
InnoDB 缓冲池大小
mysql_global_variables_innodb_buffer_pool_size{instance=”$host”}
InnoDB 维护了一个缓冲池，用于在内存当中进行数据缓存与索引。
当前连接数
max(max_over_time(mysql_global_status_threads_connected{in ...
使用elastalert2对elk中的日志进行监控及报警
使用elastalert2对elk中的日志进行监控及报警环境说明
软件
版本
elasticsearch
8.5
python
3.6.8
elastalert2
2.9.0
软件部署
es安装安装文档
elastalert2安装官网地址安装操作记录123456789101112# 配置虚拟环境mkdir -p /data cd /data/git clone https://github.com/jertel/elastalert2.gitcd elastalert2python3 -m venv elastalert2source elastalert2/bin/active# 安装pip install elastalert2pip install "setuptools>=11.3"python setup.py install
config.yaml 配置123cd examplescp config.yaml.example config.yamlvim config.yaml
12345678910111213# 最简配 ...
lda学习demo-getmodel.py
lda学习demo-getmodel.py12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455import pandas as pdimport osimport jiebafrom gensim import corporafrom gensim import modelsimport refrom gensim.models.ldamodel import LdaModelprint(1)#导入数据qa=pd.read_excel('data/qa.xlsx',names=['qa'], sheet_name="qa" ,header=None,usecols=[0])#导入词典#jieba.del_word("实名认证")#print(jieba.lcut("实名认证，我是好人"))keyWords=pd.read_excel(&#x ...
lda学习demo-testModel.py
lda学习demo-testModel.py123456789101112131415161718192021222324252627282930313233343536373839404142434445464748from gensim.models.ldamodel import LdaModelfrom gensim import corporaimport fileinputimport reimport jieba#加载模型modelPath="model_lda1/model_lda1"model=LdaModel.load(modelPath)#加载需要预测的文本fileName="data/test.txt"a=""for line in fileinput.input(fileName,openhook=fileinput.hook_encoded('utf-8', '')): a=a+linedef stopwordsPattern(): stopwor ...
minio笔记3-使用prometheus监控minio
minio笔记3-使用prometheus监控minio
提前下载mc客户端文档地址
获取token
123456789101112mc alias set logbak ${url} ${user} ${pass} #logbak是自定义的别名mc admin prometheus generate logbak # 为logbak存储生成一个token结果：scrape_configs:- job_name: minio-job bearer_token: eyJhbGciOiJIUzUxMiIsInR5cCI6IkpXVCJ9.eyJleHAiOjQ4MjMyMjcyMjYsImlzcyI6InByb21ldGhldXMiLCJzdWIiOiJsb2diYWsifQ.2ph5f8GenNRH8vV-5A337ySndFaoMWxHRwlUG7581Q0P9wVoUeKDb0Rp8LxUOOHHL6naqnB5KmP1TiR77saaSw metrics_path: /minio/v2/metrics/cluster ...