摘要:
1、mysql查看binlog mysql> show binlog events; #只查看第一个binlog文件的内容 mysql> show binlog events ``in 'mysql-bin.000002'``;#查看指定binlog文件的内容 mysql> show binary 阅读全文
摘要:
创建索引,user为索引名称 PUT http://192.168.0.110:9200/user 查询索引基本信息 GET http://192.168.0.110:9200/user 查询所有索引 GET http://192.168.0.110:9200/_cat/indices? 删除索引 阅读全文
摘要:
find . -type f -name *.log -mtime + -exec rm {} \; 阅读全文
摘要:
mysql> select version(); + + | version() | + + | 8.0.22 | + + 1 row in set (0.01 sec) mysql> show variables like '%expire%'; + + + | Variable_name | V 阅读全文
摘要:
检查当前 ~# echo $LANG en_US.UTF-8 安装中文包 yum search Chinese vim /etc/locale.conf LANG=zh_CN.UTF-8 source /etc/locale.conf 阅读全文
摘要:
全量同步报错 {"succeeded":false,"resultMessage":"导入ES 数据:0 条","errorMessage":"topicanalysismsg etl failed! ==>cannot write xcontent for unknown value of typ 阅读全文
摘要:
# 第06章_多表查询 /* SELECT ...,....,.... FROM .... WHERE .... AND / OR / NOT.... ORDER BY .... (ASC/DESC),....,... LIMIT ...,... */ #1. 熟悉常见的几个表 DESC emplo 阅读全文
摘要:
#第05章_排序与分页 #1. 排序 # 如果没有使用排序操作,默认情况下查询返回的数据是按照添加数据的顺序显示的。 SELECT * FROM employees; # 1.1 基本使用 # 使用 ORDER BY 对查询到的数据进行排序操作。 # 升序:ASC (ascend) 默认方式 # 降 阅读全文
摘要:
UserParameter=mongo.service,ps -ef |grep mongo |grep -v grep |wc -l echo "rs.status()" |mongo 127.0.0.1:27017 | grep "_id" |wc -l UserParameter=mongo. 阅读全文
摘要:
28 uname -a 29 cat /etc/redhat-release 30 rpm --import https://www.elrepo.org/RPM-GPG-KEY-elrepo.org 31 rpm -Uvh http://www.elrepo.org/elrepo-release- 阅读全文
摘要:
python -W ignore file.py 阅读全文
摘要:
重装mysql后,安装任何软件都报错 Reading package lists... Done Building dependency tree... Done Reading state information... Done wget is already the newest version 阅读全文
摘要:
查询 去重 SELECT DISTINCT department_id FROM employees; 空值参数运算 如果值为null则使用0替换,任何值与null计算都为null SELECT employee_id,salary "月工资",salary * (1 + IFNULL(commis 阅读全文
摘要:
调整系统参数 vi /etc/sysctl.conf #添加下面配置: vm.max_map_count= 262144 #生效 sysctl -p es配置文件修改 cat jvm.options -Xms16g -Xmx16g 配置证书 cd /usr/share/elasticsearch/b 阅读全文
摘要:
参考文档:https://cloud.tencent.com/developer/article/2015386 $ ps -p 8299 -o etime ELAPSED 04:05:37 etimes 关键字查看经过的时间(以秒为单位) $ ps -p 8299 -o etimes ELAPSE 阅读全文