openldap超过最大并发

2021-12-01

Linux OpenLAP 修改max open files  阅读全文...

阿里云oss云存储ossutil工具

2021-11-23

ossfs挂载当磁盘rsync时候非常卡,替换ossutil工具  阅读全文...

alter index rebuild online

2021-11-06

rebuild index online不阻塞DML操作,这是相对于rebuild index来说的,加上了online,只是在rebuild的期间不阻塞DML,但是在开始和结束阶段还是可能阻塞其他进程的DML的,系统负载飙升,甚至宕机。10G rebuild index online 会锁表  阅读全文...

oracle ALTER INDEX RENAME TO

2021-11-06

ALTER INDEX [schema.]index RENAME TO ;   阅读全文...

zabbix5.4 nginx监测模板

2021-11-03

通过zabbix提供的Nginx by Zabbix agent可以轻松监测nginx进程和一些参数。  阅读全文...

oracle出现错误提示:ORA-28000: the account is locked。

2021-11-01

出现错误提示:ORA-28000: the account is locked。  阅读全文...

#!/bin/bash – no such file or directory

2021-10-31

1、head -1 yourscript | od -c
0000000 # ! / b i n / b a s h \r \n  阅读全文...

mysql从ibd文件恢复数据

2021-10-30

数据库冷备份无法启动,但是有无数个idb表文件  阅读全文...

fuser查询文件被哪个进程占用

2021-10-29

1、linux umount分区时候:
umount: /data4: target is busy.
(In some cases useful info about processes that use
the device is found by lsof(8) or fuser(1))  阅读全文...

zabbix MEMORY.UTIL.MAX

2021-10-28

MEMORY.UTIL.MAX 90% 修改为95%  阅读全文...

mysq grant process

2021-10-28

process权限是一个全局权限,不可以指定在某一个库上
grant process on *.* to test;
flush privileges;  阅读全文...

zabbix 每页显示行数

2021-10-27

http://localhost/hosts.php每页显示50行,如果想修改为100行。  阅读全文...

redis批量删除 del key

2021-10-20

export REDISCLI_AUTH=pass123
export IP=172.16.1.2
/usr/local/bin/redis-cli -c -h ${IP} -p 6379 –scan –pattern “pre*” | xargs /usr/local/bin/redis-cli -c -h ${IP} -p 6379 del  阅读全文...

presto for hadoop

2021-10-19

Presto是Facebook开发的数据查询引擎,可对250PB以上的数据进行快速地交互式分析。  阅读全文...

beeline指定队列和参数

2021-10-14

beeline指定队列和参数
beeline -u ‘jdbc:hive2://host:port?mapreduce.job.queuename=queue;spark.executor.instances=5;spark.executor.cores=1;spark.executor.memory=4G’ -n username;  阅读全文...