wjplj-CSDN博客

查看创建表SQL语句：SELECT DBMS_METADATA.GET_DDL('TABLE','DEPT','SCOTT') FROM DUAL;SELECT DBMS_METADATA.GET_DDL('TABLE',U.TABLE_NAME) FROM USER_TABLES U;查看创建索引的SQL语句：SELECT DBMS_METADATA.GET_DDL('INDEX','PK_DEPT','SCOTT') FROM DUAL;SELECT DBMS_METADATA.GE

2022-01-09 18:22:02 791

原创 Centos设置历史命令增加时间用户 IP地址

#### vim /etc/profileUSER_IP=`who -u am i | awk '{print $NF}'|sed -e 's/[()]//g'`if [ -z "$USER_IP" ]then USER_IP="NO_client_IP"fiexport HISTTIMEFORMAT="[%Y.%m.%d %H:%M:%S-$USER_IP-$USER]"export HISTSIZE=3000 source /etc/profile

2022-01-09 18:15:08 1363

原创 Centos设置JAVA环境变量

## vim /etc/profileAVA_HOME=/usr/local/service/javaJRE_HOME=$AVA_HOME/jreCLASSPATH=.:$AVA_HOME/lib/dt.jar:$AVA_HOME/lib/tools.jarPATH=$AVA_HOME/bin:$AVA_HOME/jre/bin:$PATHexport JAVA_HOME JRE_HOME CLASSPATH PATHsource /etc/profile

2022-01-09 18:12:55 1774

原创 Centos设置无密钥登录

# 执行命令：ssh-keygen -t rsa -C "knowology.cn" 一路回车即可[root@localhost ~]# ssh-keygen -t rsa -C "knowology.cn"Generating public/private rsa key pair.Enter file in which to save the key (/root/.ssh/id_rsa):Enter passphrase (empty for no passphrase):Ent...

2022-01-09 18:11:02 550

原创 Centos分段压缩/解压大文件

1、tar -zcf - Anaconda-1.8.0.sh | split -d -b 100m - Anaconda.tar.gz. tar 分卷压缩: tar zcf - test.log | split -d -b 10m - logs.tar.gz.2、解压: cat logs.tar.gz.* | tar zx

2022-01-09 18:08:05 2782

原创 Centos7挂载ISO镜像

创建挂载路径mkdir -p /media/CentOS7挂载ISO文件到新建路径下mount -t iso9660 -o loop CentOS-7.7-x86_64-DVD-1908.iso /media/CentOS7/root/CentOS-7.7-x86_64-DVD-1908.iso /media/CentOS7 iso9660 defaults,ro,loop 0 0备份原repo文件cd /etc/yum.repo.dmkdir bakmv ./* bakm

2022-01-09 18:06:31 6327

原创批量导入MySQL数据库表

#!/bin/bashTABLE=(sqllog.sqlbackup_tables.shqueryelement.sqlscenariosrules.sql.................................)# 循环导入数据for t in ${TABLE[@]}; do /usr/local/mysql/mysql-service/bin/mysql -h 192.168.1.2 -P 3306 --default-auth=mysql_native_pas.

2022-01-09 18:04:19 786

原创 Redis单机版部署脚本（一键部署）

#!/bin/bashinstall_dir=/usr/localtmp_dir=/tmpversion="redis-5.0.9"pkg_type=".tar.gz"cd $tmp_dir/if [ -f $version$pkg_type ];then if [ $? -eq 0 ];then tar xf $version$pkg_type if [ $? -eq 0 ];then cd $tmp_dir/$version...

2022-01-09 17:55:34 638

原创 vscode 搭建 golang 开发环境

使用软件 - go1.14.3.windows-amd64.msi `https:``//golang.org/dl/`- vscode `https:``//code.visualstudio.com/`- git https://gitforwindows.org/ go1.14.3 安装后已经自动配置相关环境变量在cmd中用命令 go env 查看go环境变量vscode添加go插件这时就可以写一个 Hello World ，然后运行hello.go.

2022-01-09 17:52:33 87

原创 MySQL 自动登录并执行语句

# 自动登录MySQL#!/bin/bashexport MYSQL_PWD='password123456'mysql -u root# 执行MySQL命令#!/bin/bashexport MYSQL_PWD='password123456'mysql -u root -e "select * from mysql(数据库.表名)"

2022-01-06 15:49:37 1835

原创获取 Nginx 访问量

# 获取nginx访问量并生成 html文件访问#!/bin/bashdatetime=`date +%Y%m%d`DT=`date +%Y-%m-%d`NGINX_PATH=/app/nginxLOGS=$NGINX_PATH/logs/access.log-$datetimeHTMLFILE=/app/nginx/script/req.htmluv=`awk '{print $1}' $LOGS | sort | uniq -c | wc -l`pv=`awk '{print .

2022-01-06 15:47:09 1337

原创 Redis 清理指定数据脚本

#!/bin/bashrdir=/app/redisip=192.168.10.10key_name="waitingNumber"cd $rdir/bindb=0if [ -n "$1" ]; then db=$1fi# 如果有密码需加上 -a password# ./redis-cli -h $ip -p 6379 -a 1234567./redis-cli -h $ip -p 6379 <<ENDselect ${db}del keys ${.

2022-01-06 15:44:57 635

原创 Centos基础组件巡检脚本

#!/bin/bashcpu_load(){ load=(`cat /proc/loadavg | awk '{print $1,$2,$3}'`) echo "CPU Load: $load%"}mem_vag(){ vag=$(awk '/MemTotal/{total=$2}/MemFree/{free=$2}END{print (total-free)/total*100}' /proc/meminfo) echo "mem vag: $vag%"}mem_uf(){ .

2022-01-06 15:34:52 359

原创 MySQL 双主热备部署

创建部署路径并授权mkdir /appchown secure.secure -R /app1、vim /etc/my.cnf[client]port = 3306socket = /data/mysql_data/mysql.sock[mysql]prompt="\u@amfe-srv-1 \R:\m:\s [\d]> "no-auto-rehashdefault-character-set=utf8mb4[mysqld]user = ...

2022-01-06 15:32:20 151

原创 MySQL-8 部署

一、创建用户groupadd mysqluseradd -r -g mysql -s /sbin/nologin mysql二、配置文件vim /etc/my.cnf[mysql]port = 3306socket = /app/mysql/data/mysql.sock[mysqld]port = 3306mysqlx_port = 33060mysqlx_socket = /app/mysql/data/mysqlx.sockbasedir = /app/m..

2022-01-06 15:24:12 730

python时间计算，用于监控

空空如也