AI 助理
备案控制台
开发者社区 开发与运维 文章 正文

数据库运维相关脚本(持续交作业)

2022-03-08 149
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： 数据库运维相关脚本(持续交作业)

数据库运维相关脚本

1、采用shell脚本调用SQLPLUS执行SQL语句

#!/bin/bash

TAB=emp

sqlplus -s scott/tiger <<EOF | awk 'NR != 1 && $2 ~ /S.*T/{print $2,$6}'

set head off

set feed off

select * from $TAB;

select * from dept;

exit;

EOF


2、批量禁用/启用触发器

SELECT 'alter trigger ' || TRIGGER_NAME || ' enable;' FROM USER_TRIGGERS;

SELECT 'alter trigger ' || TRIGGER_NAME || ' disable;' FROM USER_TRIGGERS;


3、查询索引占碎片比例

selectname,del_lf_rows,lf_rows,

round(del_lf_rows/decode(lf_rows,0,1,lf_rows)*100,0)||'%' frag_pct

from index_stats

where round(del_lf_rows/decode(lf_rows,0,1,lf_rows)*100,0)>30


4、根据 sid 查 spid 或根据 spid 查 sid

selects.sid,s.serial#,s.LOGON_TIME,s.machine,p.spid,p.terminal

from v$session s,v$process p

where  s.paddr=p.addr and s.sid=SS or p.spid=BB

根据 sid 查sql 语句

selectusername,sql_text,machine,osuser from v$session a,v$sqltext_with_newlinesb  

where DECODE(a.sql_hash_value, 0, prev_hash_value, sql_hash_value)=b.hash_value

and a.sid=&sid order by piece


5、查询会话和进程消耗的平均内存大小

selectround(sum(pga_used_mem)/1024/1024,0) total_used_M,

round(sum(pga_used_mem)/count(1)/1024/1024,0) avg_used_M,

round(sum(pga_alloc_mem)/1024/1024,0) total_alloc_M,

round(sum(pga_alloc_mem)/count(1)/1024/1024,0) avg_alloc_M

from v$process


6、高CPU占用查询


select*from (select CPU_TIME/1000000,username,PARSING_USER_ID,sql_id,ELAPSED_TIME/1000000,sql_text    

from v$sql,dba_users

where user_id=PARSING_USER_ID

order by CPU_TIME/1000000 desc)where rownum <=3


7、一个巡检脚本

#!/bin/bashmkdir-p /home/oracle/script 
read -p"Enter Instance Name: " Name
logfile=/home/oracle/script/db_log.log
echo" ###### 2.1 Section #######" > $logfileexportORACLE_SID=$Name$ORACLE_HOME/bin/sqlplus -S / as sysdba >>$logfile <<END
set heading off
set feedback off;
set pagesize 0;
set linesize 120;
set trimout on;
set trimspool on;
set verify off;
select 'database_name: '||value from v\$parameter where name='db_name';
select 'instance_name: '||value from gv\$parameter where name='instance_name';
select 'RDBMS Relase: '||version  from product_component_version where product like 'Oracle Database%';
select 'All Datafiles Total Size: '||round(sum(total_size)/1024/1024/1024,2)||'GB' from (
select sum(bytes) total_size from dba_data_files
union all
select sum(bytes) total_size from dba_temp_files
);
select  'SGA_MAX_SIZE: '||value from v\$parameter where name='sga_max_size';
select 'SGA_TARGET: '||value from v\$parameter where name='sga_target';
select 'BLOCK_SIZE: '||value from v\$parameter where name='db_block_size';
select 'TABLESPACE TOTAL: '||count(*) from dba_tablespaces;
select 'DataFiles: '||count(*) from dba_data_files;
select 'Controlfiles: '||count(*) from v\$controlfile;
select 'Every RedoLog Size: '||bytes/1024/1024||'MB' from v\$log where rownum=1;
select 'Every RedoLog Group has Members: '||members from v\$log where rownum=1;
select 'Archive Mode: '||log_mode from v\$database;
select 'Max Process(History): '||max_utilization from v\$resource_limit where resource_name='processes';
exit;
END
echo"######## 5 Section ########" >>$logfile#echo -n "Enter All HostNames In RAC: "#read HostNamegridpath=`ps -ef|grep crsd.bin|grep -v grep|awk '{print $8}'`for i in`${gridpath%/*}/olsnodes`doecho$i >>$logfilessh$i df -h >>$logfileecho"" >>$logfileecho$i >>$logfilessh$icat /etc/sysctl.conf|grep -v ^#|grep -v grep|sort|uniq>>$logfileecho$i >>$logfileecho"HugePage Set " >>$logfilessh$igrep-i hugepage /proc/meminfo >>$logfileecho"#### 3.1 ######" >>$logfileecho$i >>$logfileecho"Local Disk Size" >>$logfilessh$i df -h|sed '1d'|awk 'sub("G","",$2){total+=$2}END{print total"G"}' >>$logfileecho$i >>$logfileecho"Network Card " >>$logfilessh$i ethtool eth0|grep Speed >>$logfileecho$i >>$logfileecho"Phyical Memory Total" >>$logfilessh$igrep MemTotal /proc/meminfo >>$logfileecho"" >>$logfileecho" Physical CPUS" >>$logfilessh$icat /proc/cpuinfo |grep "physical id"|uniq|wc -l >>$logfileecho"#### 3.1 over #####" >>$logfileecho$i >>$logfileecho"Vmstat stat " >>$logfilessh$i vmstat 210 >>$logfileecho"" >>$logfileecho$i >>$logfileecho"ifconfig stat" >>$logfilessh$i /sbin/ifconfig >>$logfiledoneecho"" >>$logfileecho"######### 6.2 Section #########" >>$logfileecho"Oracle user vairal" >>$logfilecat /home/oracle/.bash_profile >>$logfileecho"" >>$logfileecho"######### 6.3 Section #########" >>$logfileecho"Oracle Patch " >>$logfile$ORACLE_HOME/OPatch/opatch lspatches >>$logfileecho"######### 6.4 Section #########" >>$logfileecho${gridpath%/*} >>$logfilecd${gridpath%/*} >>$logfileecho"olsnodes stats" >>$logfile./olsnodes >>$logfileecho"ocrcheck stats" >>$logfile./ocrcheck >>$logfileecho"ocrconfig -showbackup stats" >>$logfile./ocrconfig -showbackup >>$logfileecho"crsctl check crs stats" >>$logfile./crsctl check crs >>$logfileecho"crsctl stat res -t " >>$logfile./crsctl stat res -t >>$logfileecho"crsctl stat res -t -init ">>$logfile./crsctl stat res -t-init >>$logfileecho"crsctl query css votedisk " >>$logfile./crsctl query css votedisk >>$logfileecho"oifcfg getif ">>$logfile./oifcfg getif >>$logfileecho"######## 6.7 Section ###########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 120set pagesize 0col parameter for a40
col value for a10
prompt "Oracle install Options"select * from v\$option;
exit;
EOF
echo"######### 6.8 Section #########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 200set pagesize 0col name for a40
col value for a80
select inst_id,name,value from gv\$parameter where isdefault='FALSE';
prompt "######## 6.9 Section #######"select value$ from props\$ where name='NLS_CHARACTERSET';
exit;
EOF
echo"######### 6.13 Section ########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 120col name for a60
select name,status from v\$controlfile;
exit;
EOF
echo"########## 6.14 Section ########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 120select group#,thread#,sequence#,bytes/1024/1024,members,archived,status from v\$log;prompt "####### 6.15 #### redo switch frequency"set linesize 200col Day for a5
col H00 FOR '999'COL H01 FOR '999'COL H02 FOR '999'col H03 FOR '999'COL H04 FOR '999'COL H05 FOR '999'col H06 FOR '999'COL H07 FOR '999'COL H08 FOR '999'COL H09 FOR '999'COL H10 FOR '999'col H11 FOR '999'COL H12 FOR '999'COL H13 FOR '999'col H14 FOR '999'COL H15 FOR '999'COL H16 FOR '999'COL H17 FOR '999'COL H18 FOR '999'col H19 FOR '999'COL H20 FOR '999'COL H21 FOR '999'col H22 FOR '999'COL H23 FOR '999'SELECT SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'),1,5) Day,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'00',1,0)) H00,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'01',1,0)) H01, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'02',1,0)) H02,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'03',1,0)) H03,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'04',1,0)) H04,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'05',1,0)) H05,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'06',1,0)) H06,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'07',1,0)) H07,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'08',1,0)) H08,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'09',1,0)) H09,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'10',1,0)) H10,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'11',1,0)) H11, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'12',1,0)) H12,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'13',1,0)) H13, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'14',1,0)) H14,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'15',1,0)) H15, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'16',1,0)) H16, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'17',1,0)) H17, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'18',1,0)) H18, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'19',1,0)) H19, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'20',1,0)) H20, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'21',1,0)) H21,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'22',1,0)) H22 , 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'23',1,0)) H23, 
      COUNT(*) TOTAL 
FROM v\$log_history  a
  where first_time>=to_char(sysdate-11)
GROUP BY SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'),1,5) 
ORDER BY SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'),1,5) DESC;
exit;
EOF
echo"########### 6.16 Section #########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 120col name for a40
col value for a40
show parameter db_recovery;
select inst_id,name,value from gv\$parameter where name like '%archive%' order by 1;
exit;
EOF
echo"########### 6.17 Section ###########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 150col tablespace_name for a20
col file_name for a60
set pagesize 0select tablespace_name,file_name,bytes/1024/1024,status,autoextensible from dba_data_files;
exit;
EOF
echo"########## 6.18 Section ############" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 200col tablespace_name for a20
set pagesize 0select tablespace_name,block_size,initial_extent,next_extent,status,contents,force_logging,extent_management,allocation_type,SEGMENT_SPACE_MANAGEMENT,BIGFILE,COMPRESS_FOR from dba_tablespaces;
prompt "####### tablespace_used % #######"SELECT total.tablespace_name,
      Round(total.MB, 2)          AS Total_MB,
      Round(total.MB - free.MB, 2) AS Used_MB,
      Round(( 1- free.MB / total.MB ) * 100, 2)
      || '%'                      AS Used_Pct
FROM  (SELECT tablespace_name,
              Sum(bytes) / 1024 / 1024 AS MB
        FROM  dba_free_space
        GROUP  BY tablespace_name) free,
      (SELECT tablespace_name,
              Sum(bytes) / 1024 / 1024 AS MB
        FROM  dba_data_files
        GROUP  BY tablespace_name) total
WHERE  free.tablespace_name = total.tablespace_name;
prompt "######6.19 Temporary Tablespace Usage % ######"SET PAGESIZE 60SET LINESIZE 100col tablespace_name for a20 
SELECT 
  A.tablespace_name tablespace, 
  D.mb_total,
  SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used,
  D.mb_total - SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_free
FROM 
  v\$sort_segment A,
(
SELECT 
  B.name, 
  C.block_size, 
  SUM (C.bytes) / 1024 / 1024 mb_total
FROM 
  v\$tablespace B, 
  v\$tempfile C
WHERE 
  B.ts#= C.ts#GROUP BY 
  B.name, 
  C.block_size
) D
WHERE 
  A.tablespace_name = D.name
GROUP by 
  A.tablespace_name, 
  D.mb_total
/
prompt "######### 6.20 Section ###########"col segment_name for a30
set linesize 100set pagesize 0set heading on
select status,sum(bytes)/1024/1024 from dba_undo_extents group by status;
exit;
EOF
echo"######### 7 Section #############" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileprompt "Use default password "col username for a20
set linesize 100select username from dba_users_with_defpwd where username in ('SYS','SYSTEM');
prompt "granted sysdba role "select username,sysdba from v\$pwfile_users;
PROMPT "GRANTED DBA ROLE "col grantee for a20
col granted_role for a20
select grantee,granted_role from dba_role_privs where granted_role='DBA';
prompt "password management "set linesize 200col profile for a20
col RESOURCE_NAME for a30
col limit for a15
select profile,resource_name,limit from dba_profiles where resource_name='PASSWORD_VERIFY_FUNCTION';
exit;
EOF
echo"######### 9.6 Section #############" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 200set pagesize 0col resource_name for a30
col INITIAL_ALLOCATION for a20
col LIMIT_VALUE for a20
select * from v\$resource_limit;
exit;
EOF
echo"######## 10.1 Section ############" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfilecol segment_name for a30
set linesize 150col owner for a20
set pagesize 0select owner,segment_name,sum(bytes)/1024 from dba_segments 
where (segment_name like '%TMP%'  or segment_name like '%HIS%'  or segment_name like '%BAK%'  or segment_name like '%TEST%'  or segment_name like '%201%'  or segment_name like 'BIN%')
  and owner not in ('SYS','SYSTEM','SYSMAN','APEX_030200','MGMT_VIEW','DBSNMP')
  and segment_type like 'TABLE%'group by owner,segment_name;
prompt "######## 10.2 ###### Redundant index"column redundant_index format a45
column sufficient_index format a45
select
  o1.name||'.'||n1.name  redundant_index,
  o2.name||'.'||n2.name  sufficient_index
from
  sys.icol\$  ic1,
  sys.icol\$  ic2,
  sys.ind\$  i1,
  sys.obj\$  n1,
  sys.obj\$  n2,
  sys.user\$  o1,
  sys.user\$  o2
where
  ic1.pos# = 1 and  ic2.bo# = ic1.bo# and  ic2.obj# != ic1.obj# and  ic2.pos# = 1 and  ic2.intcol# = ic1.intcol# and  i1.obj# = ic1.obj# and  bitand(i1.property, 1) =0 and
  ( select
      max(pos#) * (max(pos#) + 1) / 2    from
      sys.icol\$
    where
      obj# = ic1.obj#  ) =  ( select
      sum(xc1.pos#)    from
      sys.icol\$ xc1,
      sys.icol\$ xc2
    where
      xc1.obj# = ic1.obj# and      xc2.obj# = ic2.obj# and      xc1.pos# = xc2.pos# and      xc1.intcol# = xc2.intcol#  ) and
  n1.obj# = ic1.obj# and  n2.obj# = ic2.obj# and  o1.user# = n1.owner# and  o2.user# = n2.owner#  and o1.name not in ('SYS','SYSTEM','APEX_030200','SYSMAN','MDSYS','ORDDATA','XDB')
/
PROMPT "####### 10.3 ####### Invalid object "col object_name for a30
set linesize 120col owner for a15
col object_type for a30
set pagesize 0select owner,object_name ,object_type from dba_objects where status='INVALID';
prompt "######### 10.4 ########UNUSABLE INDEX"select owner,index_name from dba_indexes where status='UNUSABLE';
prompt "######### 10.5 ###########Order by sql "set pagesize 0select sql_id from v\$sqlarea where sql_text like '%order by %';
prompt "######### 10.6 ###########No bound variables are used for SQL"set numw 20select FORCE_MATCHING_SIGNATURE, count(1)
  from v\$sql
where FORCE_MATCHING_SIGNATURE > 0  and FORCE_MATCHING_SIGNATURE != EXACT_MATCHING_SIGNATURE
group by FORCE_MATCHING_SIGNATURE
having count(1) > 100order by 2;
prompt "####### 10.7 ####### In SYSTEM/SYSAUX tablespace "col segment_name for a30
set linesize 200col owner for a20
select owner,segment_name,segment_type,tablespace_name from dba_segments
where tablespace_name in ('SYSTEM','SYSAUX')
and owner not in ('SYS','SYSTEM','OUTLN','APEX_030200','SYSMAN','MDSYS','OLAPSYS','ORDDATA','ORDSYS','EXFSYS','XDB','CTXSYS','EXFSYS','WMSYS','DBSNMP');
prompt "######## 10.7 #####Table Fragment"col table_name for a30
select table_name,round(BLOCKS*8192/1024/1024,2) total_size_MB,
round(num_rows*AVG_ROW_LEN/1024/1024,2) used_size_MB,
round(((BLOCKS*8192/1024/1024)-(num_rows*AVG_ROW_LEN/1024/1024)),2)  wasted_size_MB,
round(round(((BLOCKS*8192/1024/1024)-(num_rows*AVG_ROW_LEN/1024/1024)),2)/
round(BLOCKS*8192/1024/1024,2),2)*100||'%' wasted_percent
from dba_tables where owner not in ('SYS','SYSTEM','OUTLN')
and round(BLOCKS*8192/1024/1024,2) <>0
and round(((BLOCKS*8192/1024/1024)-(num_rows*AVG_ROW_LEN/1024/1024)),2)>100
order by 2;
PROMPT "##### 10.9 ###### TABLESPACE FRAGMENT "set linesize 150        column tablespace_name format a20 heading 'Tablespace'    column sumb format 999,999,999
    column extents format 9999    column bytes format 999,999,999,999
    column largest format 999,999,999,999
    column Tot_Size format 999,999 Heading 'Total| Size(Mb)'    column Tot_Free format 999,999,999 heading 'Total Free(MB)'    column Pct_Free format 999.99 heading '% Free'    column Chunks_Free format 9999 heading 'No Of Ext.'    column Max_Free format 999,999,999 heading 'Max Free(Kb)'setecho off
    PROMPT  FREE SPACE AVAILABLE IN TABLESPACES
    select a.tablespace_name,sum(a.tots/1048576) Tot_Size,
    sum(a.sumb/1048576) Tot_Free,
    sum(a.sumb)*100/sum(a.tots) Pct_Free,
    sum(a.largest/1024) Max_Free,sum(a.chunks) Chunks_Free
    from
    (
    select tablespace_name,0 tots,sum(bytes) sumb,
    max(bytes) largest,count(*) chunks
    from dba_free_space a
    group by tablespace_name
    union
    select tablespace_name,sum(bytes) tots,0,0,0 from
      dba_data_files
    group by tablespace_name) a
    group by a.tablespace_name
order by pct_free;
prompt "######### 10.10 parallel object #######"set pagesize 0col owner for a15
col index_name for a30
col table_name for a30
prompt "parallel tables"select owner,table_name,degree  from dba_indexes where ltrim(degree)>'1' order by 1;
prompt "parallel index"select owner,index_name,degree from dba_indexes where ltrim(degree)>'1' order by 1;
exit;
EOF
文章标签：
Perl
Shell
SQL
索引
运维
数据库
关键词：
运维数据库
数据库运维
运维脚本
数据库脚本
运维作业
1285620146464872
目录
相关文章
Echo_Wish
|
25天前
|
机器学习/深度学习 存储 运维
深度学习在数据库运维中的作用与实现
深度学习在数据库运维中的作用与实现
Echo_Wish
72 14
技能实验室
|
2月前
|
关系型数据库 MySQL 数据库连接
python脚本：连接数据库，检查直播流是否可用
【10月更文挑战第13天】本脚本使用 `mysql-connector-python` 连接MySQL数据库，检查 `live_streams` 表中每个直播流URL的可用性。通过 `requests` 库发送HTTP请求，输出每个URL的检查结果。需安装 `mysql-connector-python` 和 `requests` 库，并配置数据库连接参数。
技能实验室
141 68
TDengine
|
22天前
|
SQL 存储 运维
从建模到运维：联犀如何完美融入时序数据库 TDengine 实现物联网数据流畅管理
本篇文章是“2024，我想和 TDengine 谈谈”征文活动的三等奖作品。文章从一个具体的业务场景出发，分析了企业在面对海量时序数据时的挑战，并提出了利用 TDengine 高效处理和存储数据的方法，帮助企业解决在数据采集、存储、分析等方面的痛点。通过这篇文章，作者不仅展示了自己对数据处理技术的理解，还进一步阐释了时序数据库在行业中的潜力与应用价值，为读者提供了很多实际的操作思路和技术选型的参考。
TDengine
37 1
TDengine
|
22天前
|
运维 监控 Cloud Native
云原生之运维监控实践：使用 taosKeeper 与 TDinsight 实现对 时序数据库TDengine 服务的监测告警
在数字化转型的过程中，监控与告警功能的优化对保障系统的稳定运行至关重要。本篇文章是“2024，我想和 TDengine 谈谈”征文活动的三等奖作品之一，详细介绍了如何利用 TDengine、taosKeeper 和 TDinsight 实现对 TDengine 服务的状态监控与告警功能。作者通过容器化安装 TDengine 和 Grafana，演示了如何配置 Grafana 数据源、导入 TDinsight 仪表板、以及如何设置告警规则和通知策略。欢迎大家阅读。
TDengine
51 0
游客qf4jmczx4xu2y
|
1月前
|
运维 Kubernetes Devops
自动化运维：从脚本到工具的演进之旅
在数字化浪潮中，自动化运维成为提升效率、保障系统稳定的关键。本文将探索自动化运维的发展脉络，从基础的Shell脚本编写到复杂的自动化工具应用，揭示这一技术变革如何重塑IT运维领域。我们将通过实际案例，展示自动化运维在简化工作流程、提高响应速度和降低人为错误中的重要作用。无论你是初学者还是资深专家，这篇文章都将为你提供宝贵的洞见和实用的技巧。
游客qf4jmczx4xu2y
56 3
程序员成长之路
|
2月前
|
运维 监控 关系型数据库
数据库管理中的自动化运维：挑战与解决方案
数据库管理中的自动化运维：挑战与解决方案
程序员成长之路
74 18
肥猪肥猪-17824
|
2月前
|
运维 Devops
自动化运维：从脚本到DevOps的进化之旅
在数字化时代，自动化运维不仅是提高生产效率的关键，更是企业竞争力的象征。本文将带领读者穿越自动化运维的发展历程，从最初的脚本编写到现代DevOps文化的形成，揭示这一演变如何重塑IT行业的工作模式。通过具体案例，我们将展示自动化工具和实践如何简化复杂任务，优化流程，并促进团队协作。你将发现，自动化运维不仅关乎技术的进步，更体现了人、流程和技术三者之间协同增效的深层逻辑。
肥猪肥猪-17824
54 4
我不是游客20240119
|
2月前
|
机器学习/深度学习 人工智能 运维
自动化运维之路：从脚本到工具的演进
在IT运维领域，效率和准确性是衡量工作成效的关键指标。随着技术的发展，自动化运维逐渐成为提升这两个指标的重要手段。本文将带领读者了解自动化运维的演变历程，从最初的简单脚本编写到现今复杂的自动化工具应用，展示如何通过技术提升运维效率。文章不仅介绍理论和实践案例，还提供了代码示例，帮助读者理解自动化运维的实际应用场景。
我不是游客20240119
62 3
请看我回答~
|
2月前
|
运维 监控 网络安全
自动化运维的崛起：如何利用Python脚本简化日常任务
【10月更文挑战第43天】在数字化时代的浪潮中，运维工作已从繁琐的手工操作转变为高效的自动化流程。本文将引导您了解如何运用Python编写脚本，以实现日常运维任务的自动化，从而提升工作效率和准确性。我们将通过一个实际案例，展示如何使用Python来自动部署应用、监控服务器状态并生成报告。文章不仅适合运维新手入门，也能为有经验的运维工程师提供新的视角和灵感。
请看我回答~
139 2
技术混子
|
2月前
|
运维 监控 Python
自动化运维：使用Python脚本简化日常任务
【10月更文挑战第36天】在数字化时代，运维工作的效率和准确性成为企业竞争力的关键。本文将介绍如何通过编写Python脚本来自动化日常的运维任务，不仅提高工作效率，还能降低人为错误的风险。从基础的文件操作到进阶的网络管理，我们将一步步展示Python在自动化运维中的应用，并分享实用的代码示例，帮助读者快速掌握自动化运维的核心技能。
技术混子
129 3

热门文章

最新文章

  • 1
    云资源运维难？阿里云免费工具来帮忙
  • 2
    AI辅助的运维流程自动化：实现智能化管理的新篇章
  • 3
    解锁高效运维新姿势！操作系统智能助手OS Copilot新功能实战测评
  • 4
    阿里云服务器一键安装Docker社区版教程，基于系统运维管理OOS
  • 5
    阿里云容器服务AI助手2.0 - 新一代容器智能运维能力
  • 6
    阿里云系统运维管理OOS一键安装宝塔面板，这个功能太牛了！
  • 7
    为了提升运维工程师及开发者
  • 8
    基于AI的运维资源调度：效率与智能的双重提升
  • 9
    AI赋能运维：实现运维任务的智能化自动分配
  • 10
    操作系统控制台，让运维更简单！
  • 1
    “日志＝数据库”？聊一聊日志背后的抽象
    25
  • 2
    71.7万/秒到1.4万/秒！数据库查询优化实战
    14
  • 3
    Django—同一项目不同app使用不同数据库
    14
  • 4
    使用 JDBC 实现 Java 数据库操作
    32
  • 5
    【潜意识Java】MyBatis中的动态SQL灵活、高效的数据库查询以及深度总结
    47
  • 6
    【深入了解MySQL】优化查询性能与数据库设计的深度总结
    51
  • 7
    Java后端开发-使用springboot进行Mybatis连接数据库步骤
    14
  • 8
    Vue.js应用结合Redis数据库：实践与优化
    31
  • 9
    风险防不胜防？看YashanDB如何守护你的数据库安全（下）
    14
  • 10
    阿里云PolarDB：引领云原生数据库创新发展
    24

    • 相关课程

    更多
  • 企业级运维之云原生与Kubernetes实战课程
  • 面向运维的 python 脚本速成-1024程序员节创造营公益课
  • 淘系技术A类顶会论文-数据库领域-VLDB 2020
  • NoSQL数据库Kudu教程
  • Linux企业运维实战 - 入门及常用命令
  • 玩转云上智能运维

    • 相关电子书

    更多
  • 企业运维之云原生和Kubernetes 实战
  • 可视化架构运维实践
  • 2021云上架构与运维峰会演讲合集

    • 相关实验场景

    更多
  • 使用DAS实现数据库SQL优化
  • 使用操作系统智能助手OS Copilot解锁操作系统运维与编程
  • 自建数据库迁移到云数据库
  • PolarDB for AI：在数据库中通过SQL实现AI能力
  • 云原生HTAP数据库，让你的交易和分析一库搞定
  • 快速体验PolarDB开源数据库
    • 下一篇
    阿里云oss简介和如何对接使用