yw_shan-优快云博客

原创自动更新表统计信息

#author wy_shanimport os,sysimport subprocessimport reimport timeimport threadingimport argparseimport testlogif sys.version.startswith('2.7'): import Queueelse: import queueclass updateStatis(object): def __init__(self,host,user,pwd

2021-04-12 12:46:22 255 2

原创统计未同步表的数量及主键名称等

#author yw_shanimport osimport subprocessimport reimport timeimport sysclass pull_data(object): def get_rds_conn(self): with open('conf/rds.conf','r') as f: rds_list=f.readlines() return rds_list def get_conn_

2021-04-12 11:55:19 147

原创运行shell脚本报syntax error near unexpected token `$‘{\r‘‘错误

以前是正常的脚本，重新从windows拷贝到linux后，运行shell脚本报错之后发现是脚本里每一行最后多了^M，删除掉执行%s/\r//g删除^M再执行脚本正常

2021-04-06 10:19:13 172

原创查找每个uid最晚(大)的enddate时间

查找每个uid最晚(大)的enddate时间SELECT max(to_number(to_char(enddate,'yyyymmddhh24miss'))),uid from TRAFODION.D.STATE where SID ='100' AND uid IN('xxx','yyy','zzz') GROUP BY uid;

2021-03-11 23:49:18 258

原创查看索引（trafodion）

查看索引（trafodion）SELECTa.schema_name,a.object_name AS table_name,c.object_name AS index_name,REPLACE(d.column_name,'@','') column_name,d.column_numberFROM"_MD_".objects a, _MD_".indexes b,"_MD_".objects c,"_MD_".columns dWHERE a.object_uid=b.bas

2021-03-11 23:42:47 207

原创用sed实现列顺序的批量移动互换修改

ls命令显示如下：如果要想修改文件名称后缀，可以用下面命令批量修改ls |grep -v ‘.conf’|sed -r ‘s/^(.*).(end$)/mv \1.\2 \1.exp /’

2021-03-11 23:32:22 669

原创抓取慢sql

filename : slowq.pyfunction : collect slowly sql greate than 5 minuteusage method: python slowSql.pyauthor : liushan

2021-03-11 22:52:28 172

原创 trafodion一次sql语句优化

EXPLAIN OPTIONS ‘f’select count(*)from YF.VIEW_TEST t,YF.VIEWS nwhere productid = ‘50’and t.end_date BETWEEN ‘2020-12-01’ AND ‘2020-12-31 23:59:59’and t.USERID = n.USERIDand n.provinceid=‘38’语句分析结果，上面都是两张视图查询结果，分别由不同的两张表构成，总共4张表，大表有1亿+数据，小表也有几百万的数..

2020-12-24 17:50:26 297 3

原创 python通过pdbc.trafodion连接Trafodion

1 、安装连接驱动python3 -m pip install PyTrafodion-0.0.5.tar.gz2、连接

2020-12-21 16:18:49 267

原创 shell编写带选择菜单监控小工具

shell编写带选择菜单监控小工具1) 第一层目录sh login_host.shfunction host_menu(){ list=`cat <<FOE=========================================== 1. login yjj01 2. login yjj02 3. login yjj03 4. login yjj04 5. login yjj05 6. login yjj06 7. login

2020-12-21 16:01:20 164

yw_shan的博客