greenplum 状态检查/监控脚本

最新推荐文章于 2024-05-29 18:12:16 发布
最新推荐文章于 2024-05-29 18:12:16 发布
阅读量873 收藏
点赞数 1
分类专栏： Greenplum 数据库日常运维
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ws972361669/article/details/90667553
版权

写了一个日常对 greenplum 数据库进行检查，记录数据库当前的整体情况，需自己修改数据库信息与邮件发送配置才可正常使用。

 

#!/bin/bash

source ~/.bash_profile

source /usr/local/greenplum-cc-web/gpcc_path.sh

source /usr/local/greenplum-db/greenplum_path.sh

export database_name=

export database_port=

export local_dest=/home/gpadmin/csh

cd $local_dest

export mailfrom=

export maillist=

export mailsmtp=

export mailxu=

export mailxp=

export num=`psql -d "$database_name" -p "$database_port" -c "copy (select count(*) from pg_stat_activity where current_query <> '<IDLE>' and usename='bi_develop') to stdout"`

if [ "$num" -gt 8 ]

then

exit

fi

echo "<HTML>" > $local_dest/daily_check.html

echo "<style type='text/css'> body {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} p {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} table,tr,td {font:10pt Arial,Helvetica,sans-serif; color:Black; background:#FAF0E6; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px;} th {font:bold 10pt Arial,Helvetica,sans-serif; color:#336699; background:#C2C2C2; padding:0px 0px 0px 0px;} h1 {font:16pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; border-bottom:1px solid #cccc99; margin-top:0pt; margin-bottom:0pt; padding:0px 0px 0px 0px;} h2 {font:bold 10pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; margin-top:4pt; margin-bottom:0pt;} a {font:9pt Arial,Helvetica,sans-serif; color:#663300; background:#ffffff; margin-top:0pt; margin-bottom:0pt; vertical-align:top;}</style>" >> $local_dest/daily_check.html

echo "<BODY>" >> $local_dest/daily_check.html

#当前集群的磁盘使用情况

echo " Data Disk Usage " >> $local_dest/daily_check.html

psql -d $database_name -p $database_port -c "copy (select distinct hostname from gp_segment_configuration order by 1) to stdout" > $local_dest/host_info.txt

gpssh -f $local_dest/host_info.txt df -h | grep /data | grep -v 192 > $local_dest/disk_info.txt

echo "<table width=90% border=1 align=center>" >> $local_dest/daily_check.html

echo "<tr>" >> $local_dest/daily_check.html

echo "<th>host_name</th>" >> $local_dest/daily_check.html

echo "<th>disk_name</th>" >> $local_dest/daily_check.html

echo "<th>total_size</th>" >> $local_dest/daily_check.html

echo "<th>used_size</th>" >> $local_dest/daily_check.html

echo "<th>free_size</th>" >> $local_dest/daily_check.html

echo "<th>usage</th>" >> $local_dest/daily_check.html

echo "<th>mount_dir</th>" >> $local_dest/daily_check.html

echo "</tr>" >> $local_dest/daily_check.html

while read diskinfo

do

host_name=`echo "$diskinfo" | sed 's/\[//g' | sed 's/\]//g' | awk {'print $1'}`

disk_name=`echo "$diskinfo" | sed 's/\[//g' | sed 's/\]//g' | awk {'print $2'}`

total_size=`echo "$diskinfo" | sed 's/\[//g' | sed 's/\]//g' | awk {'print $3'}`

used_size=`echo "$diskinfo" | sed 's/\[//g' | sed 's/\]//g' | awk {'print $4'}`

free_size=`echo "$diskinfo" | sed 's/\[//g' | sed 's/\]//g' | awk {'print $5'}`

usage=`echo "$diskinfo" | sed 's/\[//g' | sed 's/\]//g' | awk {'print $6'}`

mount_dir=`echo "$diskinfo" | sed 's/\[//g' | sed 's/\]//g' | awk {'print $7'}`

echo "<tr>" >> $local_dest/daily_check.html

echo "<td>$host_name</td>" >> $local_dest/daily_check.html

echo "<td>$disk_name</td>" >> $local_dest/daily_check.html

echo "<td>$total_size</td>" >> $local_dest/daily_check.html

echo "<td>$used_size</td>" >> $local_dest/daily_check.html

echo "<td>$free_size</td>" >> $local_dest/daily_check.html

echo "<td>$usage</td>" >> $local_dest/daily_check.html

echo "<td>$mount_dir</td>" >> $local_dest/daily_check.html

echo "</tr>" >> $local_dest/daily_check.html

done < $local_dest/disk_info.txt

echo "</table>" >> $local_dest/daily_check.html

echo "</br>" >> $local_dest/daily_check.html

echo " Data Disk Free " >> $local_dest/daily_check.html

psql -T 'width=90% border=1 align=center' -H -d $database_name -p $database_port -c "SELECT gp_disk_free.dfsegment AS segment_id,

gp_disk_free.dfhostname AS hostname,

gp_disk_free.dfdevice AS diskname,

round(gp_disk_free.dfspace ::numeric * 1.0 / 1024 ::numeric / 1024

::numeric,

2) AS free_gb,

round(gp_disk_free.dfspace ::numeric * 1.0 / 1024 ::numeric / 1024

::numeric / 1024 ::numeric,

2) AS free_tb

FROM ONLY gp_toolkit.gp_disk_free

ORDER BY gp_disk_free.dfsegment" | sed '$d' | sed '$d' >> $local_dest/daily_check.html

echo "</br>" >> $local_dest/daily_check.html

#查看各个数据库的大小

echo " Database Size List " >> $local_dest/daily_check.html

psql -T 'width=90% border=1 align=center' -H -d $database_name -p $database_port -c "select datname,round(pg_database_size(datname)*1.0/1024/1024/1024,2) size_gb from pg_database order by 2 desc" | sed '$d' | sed '$d' >> $local_dest/daily_check.html

echo "</br>" >> $local_dest/daily_check.html

#查看各个节点的启动时间

echo " Instance Runtime Information " >> $local_dest/daily_check.html

psql -t -d $database_name -p $database_port -c "select hostname,port from gp_segment_configuration where role = 'p' order by 1" |sed 's/[[:space:]]//g'|awk -F '|' {'print $1","$2'}|sed '$d' > $local_dest/segment_info.txt

echo "<table width=90% border=1 align=center>" >> $local_dest/daily_check.html

echo "<tr valign=top>" >> $local_dest/daily_check.html

echo "<th>host_name</th>" >> $local_dest/daily_check.html

echo "<th>start_time</th>" >> $local_dest/daily_check.html

echo "<th>run_time</th>" >> $local_dest/daily_check.html

echo "</tr>" >> $local_dest/daily_check.html

while read param

do

export seg_host=`echo "$param"|awk -F ',' {'print $1'}`

export seg_port=`echo "$param"|awk -F ',' {'print $2'}`

PGOPTIONS="-c gp_session_role=utility" psql -t -h "$seg_host" -p "$seg_port" -d $database_name -c "select '$seg_host' hostname,pg_postmaster_start_time(),now()-pg_postmaster_start_time() run_time" | sed '$d' > $local_dest/seg_info.txt

while read seg

do

host_name=`echo "$seg" | awk -F '|' {'print $1'}`

start_time=`echo "$seg" | awk -F '|' {'print $2'}`

run_time=`echo "$seg" | awk -F '|' {'print $3'}`

echo "<tr>" >> $local_dest/daily_check.html

echo "<td>$host_name</td>" >> $local_dest/daily_check.html

echo "<td>$start_time</td>" >> $local_dest/daily_check.html

echo "<td>$run_time</td>" >> $local_dest/daily_check.html

echo "</tr>" >> $local_dest/daily_check.html

done < $local_dest/seg_info.txt

done < $local_dest/segment_info.txt

echo "</table>" >> $local_dest/daily_check.html

echo "</br>" >> $local_dest/daily_check.html

#当前集群instance状态

echo " Instance Status Information " >> $local_dest/daily_check.html

psql -d $database_name -p $database_port -T 'width=90% border=1 align=center' -H -c "select content,role,preferred_role,mode,status,hostname from gp_segment_configuration order by 1,2" | sed '$d' | sed '$d' >> $local_dest/daily_check.html

echo "</br>" >> $local_dest/daily_check.html

#当前数据库版本信息

echo $database_name" Version Information " >> $local_dest/daily_check.html

psql -d $database_name -p $database_port -T 'width=90% border=1 align=center' -H -c "select version()" | sed '$d' | sed '$d'>> $local_dest/daily_check.html

echo "</br>" >> $local_dest/daily_check.html

#数据库表膨胀情况

echo $database_name" Table Needed Vacuum " >> $local_dest/daily_check.html

psql -d $database_name -p $database_port -T 'width=90% border=1 align=center' -H -c "select * from gp_toolkit.gp_bloat_diag order by bdirelpages desc" | sed '$d'| sed '$d' >> $local_dest/daily_check.html

echo "</br>" >> $local_dest/daily_check.html

#数据量月增长情况

psql -d $database_name -p $database_port -c "create table csh_datasize (ctime timestamp,datname varchar(30),datasize numeric(10,2)) distributed randomly"

psql -d $database_name -p $database_port -c " copy (select now(),datname,round(pg_database_size(datname)*1.0/1024/1024/1024,2) size_gb from pg_database order by 3 desc) to stdout" > $local_dest/datasize.txt

psql -d $database_name -p $database_port -c "copy public.csh_datasize from '$local_dest/datasize.txt'"

#数据库数量

export db_num=`psql -d "$database_name" -p "$database_port" -c "copy (select count(*) from pg_database) to stdout"`

echo $database_name" Last Half Year Data Growth Every Month " >> $local_dest/daily_check.html

psql -d $database_name -p $database_port -T 'width=90% border=1 align=center' -H -c "SELECT to_char(size.ctime, 'YYYY-MM' ::text) AS month,

datname,sum(size.day_ext) AS mon_ext_gb

FROM (SELECT csh_datasize.ctime,

datname,

csh_datasize.datasize -

(lag(csh_datasize.datasize, 1, 0) OVER(partition by datname ORDER BY csh_datasize.ctime)) AS day_ext

FROM csh_datasize) size

GROUP BY to_char(size.ctime, 'YYYY-MM' ::text), datname

ORDER BY to_char(size.ctime, 'YYYY-MM' ::text),datname DESC limit 6*$db_num " | sed '$d'|sed '$d' >> $local_dest/daily_check.html

echo "</br>" >> $local_dest/daily_check.html

#数据量日增长情况

echo $database_name" Last Week Data Growth Every Day " >> $local_dest/daily_check.html

psql -d $database_name -p $database_port -T 'width=90% border=1 align=center' -H -c "SELECT to_date(csh_datasize.ctime,'yyyy-mm-dd') day_time,

csh_datasize.datasize -

(lag(csh_datasize.datasize,1,0) OVER(ORDER BY csh_datasize.ctime)) AS day_ext_gb

FROM csh_datasize where datname = '$database_name'

ORDER BY csh_datasize.ctime DESC limit 7*$db_num " | sed '$d' | sed '$d' >> $local_dest/daily_check.html

echo "</br>" >> $local_dest/daily_check.html

#表数据增长量

echo $database_name" Table Data Growth " >> $local_dest/daily_check.html

psql -d $database_name -p $database_port -c "create table public.csh_table_size (ctime timestamp,taboid oid,tabsize bigint,tabidx_size numeric,schemaname name,tablename name) distributed randomly "

psql -d $database_name -p $database_port -c " copy (SELECT now(),sotaid.sotaidoid, sotaid.sotaidtablesize, sotaid.sotaididxsize, fn.fnnspname AS sotaidschemaname, fn.fnrelname AS sotaidtablename FROM ( SELECT now(),sotd.sotdoid AS sotaidoid, sotd.sotdsize + sotd.sotdtoastsize + sotd.sotdadditionalsize AS sotaidtablesize, CASE WHEN soati.soatisize IS NULL THEN 0::numeric ELSE soati.soatisize END AS sotaididxsize FROM gp_toolkit.gp_size_of_table_disk sotd LEFT JOIN gp_toolkit.gp_size_of_all_table_indexes soati ON sotd.sotdoid = soati.soatioid) sotaid JOIN gp_toolkit.__gp_fullname fn ON sotaid.sotaidoid = fn.fnoid) to stdout" > $local_dest/tablesize.txt

#psql -d $database_name -p $database_port -c "delete from public.csh_table_size where ctime <= current_date - interval'30 day'"

psql -d $database_name -p $database_port -c "copy public.csh_table_size from '$local_dest/tablesize.txt'"

psql -d $database_name -p $database_port -T 'width=90% border=1 align=center' -H -c "select a.ctime time,a.schemaname schemaname,a.tablename tablename,abs(a.tabsize-b.tabsize)/1024/1024 table_size_dif_mb,abs(a.tabidx_size-b.tabidx_size) indx_size_def from (select * from public.csh_table_size where (select to_date(ctime,'yyyy-mm-dd') from public.csh_table_size)=current_date) a,(select * from public.csh_table_size where (select to_date(ctime,'yyyy-mm-dd') from public.csh_table_size)=current_date - interval'1 day') b where a.taboid=b.taboid order by table_size_dif_mb desc limit 100 " | sed '$d'| sed '$d' >> $local_dest/daily_check.html

echo "</br>" >> $local_dest/daily_check.html

#当前数据库大于50GB的表

echo $database_name" Big Table(Size More Than 50G) " >> $local_dest/daily_check.html

psql -d $database_name -p $database_port -T 'width=90% border=1 align=center' -H -c "Select a.schema_name, a.table_name, a.tablesize_GB, a.indexsize_GB

from (select tabs.nspname as schema_name,

COALESCE(parts.tablename, tabs.relname) AS table_name,

ROUND(SUM(sotaidtablesize) / 1024 / 1024 / 1024, 3) AS tablesize_GB,

ROUND(SUM(sotaididxsize) / 1024 / 1024 / 1024, 3) AS indexsize_GB

FROM gp_toolkit.gp_size_of_table_and_indexes_disk sotd,

(select c.oid, c.relname, n.nspname

from pg_class c, pg_namespace n

where n.oid = c.relnamespace) tabs

LEFT JOIN pg_partitions parts

ON tabs.nspname = parts.schemaname

AND tabs.relname = parts.partitiontablename

where sotd.sotaidoid = tabs.oid

GROUP BY tabs.nspname, COALESCE(parts.tablename, tabs.relname)) a

where a.tablesize_GB >= 50

ORDER by 3 desc" | sed '$d' >> $local_dest/daily_check.html

echo "</br>" >> $local_dest/daily_check.html

#大表数据倾斜情况

echo $database_name" Date Skew Of Big Table " >> $local_dest/daily_check.html

psql -d $database_name -p $database_port -t -c "Select a.schema_name || '.' || a.table_name

from (select tabs.nspname as schema_name,

COALESCE(parts.tablename, tabs.relname) AS table_name,

ROUND(SUM(sotaidtablesize) / 1024 / 1024 / 1024, 3) AS tablesize_GB,

ROUND(SUM(sotaididxsize) / 1024 / 1024 / 1024, 3) AS indexsize_GB

FROM gp_toolkit.gp_size_of_table_and_indexes_disk sotd,

(select c.oid, c.relname, n.nspname

from pg_class c, pg_namespace n

where n.oid = c.relnamespace) tabs

LEFT JOIN pg_partitions parts

ON tabs.nspname = parts.schemaname

AND tabs.relname = parts.partitiontablename

where sotd.sotaidoid = tabs.oid

GROUP BY tabs.nspname, COALESCE(parts.tablename, tabs.relname)) a

where a.tablesize_GB >= 100

ORDER by a.tablesize_GB desc" |sed 's/[[:space:]]//g'|sed '$d' > $local_dest/big_table.txt

while read name

do

echo "$name" >> $local_dest/daily_check.html

psql -d $database_name -p $database_port -T 'width=90% border=1 align=center' -H -c "select gp_segment_id,

count(*),

abs(count(*) - avg(count(*))

over(order by gp_segment_id rows between unbounded

preceding and unbounded following)) / count(*) skew

from $name

group by gp_segment_id

order by 1" | sed '$d' | sed '$d' >> $local_dest/daily_check.html

echo "</br>" >> $local_dest/daily_check.html

done < $local_dest/big_table.txt

echo "</br>" >> $local_dest/daily_check.html

#晚间跑数负载情况

echo " System Load(Avg Ten Minutes) " >> $local_dest/daily_check.html

psql -d gpperfmon -T 'width=90% border=1 align=center' -H -c "select t.date||' '||t.hour||':'||t.minute||':00' time,t.cpu_user,t.cpu_sys,t.mem_used,t.iops,t.disk_r_mb,t.disk_w_mb

from (select current_date as  date,

to_char(ctime,'hh24') as hour,

substr(to_char(ctime,'mi'),1,1)||'0' as minute,

round(avg(cpu_user) ::numeric, 2) cpu_user,

round(avg(cpu_sys) ::numeric, 2) cpu_sys,

round(avg(mem_actual_used) / 1024 / 1024 / 1024 ::numeric, 2) mem_used,

round(avg(disk_ro_rate) ::numeric, 2) iops,

round(avg(disk_rb_rate) / 1024 / 1024 ::numeric, 2) disk_r_mb,

round(avg(disk_wb_rate) / 1024 / 1024 ::numeric, 2) disk_w_mb

from system_history

where ctime >= current_date

and ctime <= current_timestamp

and hostname <> 'mdw'

and hostname <> 'smdw'

group by current_date,

to_char(ctime,'hh24'),

substr(to_char(ctime,'mi'),1,1)||'0') t

order by 1 " | sed '$d' | sed '$d' >> $local_dest/daily_check.html

echo "</br>" >> $local_dest/daily_check.html

#与前一天负载对比

echo " System Load Different With Yesterday" >> $local_dest/daily_check.html

psql -d gpperfmon -T 'width=90% border=1 align=center' -H -c "select a.time,

abs(a.cpu_user - b.cpu_user) cpu_user_dif,

abs(a.cpu_sys - b.cpu_sys) cpu_sys_dif,

abs(a.mem_used - b.mem_used) mem_used_dif,

abs(a.iops - b.iops) iops_dif,

abs(a.disk_r_mb - b.disk_r_mb) disk_r_mb_dif,

abs(a.disk_w_mb - b.disk_w_mb) disk_w_mb_dif

from (select t.date || ' ' || t.hour || ':' || t.minute || ':00' time,

t.cpu_user,

t.cpu_sys,

t.mem_used,

t.iops,

t.disk_r_mb,

t.disk_w_mb

from (select current_date as date,

to_char(ctime, 'hh24') as hour,

substr(to_char(ctime, 'mi'), 1, 1) || '0' as minute,

round(avg(cpu_user) ::numeric, 2) cpu_user,

round(avg(cpu_sys) ::numeric, 2) cpu_sys,

round(avg(mem_actual_used) / 1024 / 1024 / 1024

::numeric,

2) mem_used,

round(avg(disk_ro_rate) ::numeric, 2) iops,

round(avg(disk_rb_rate) / 1024 / 1024 ::numeric, 2) disk_r_mb,

round(avg(disk_wb_rate) / 1024 / 1024 ::numeric, 2) disk_w_mb

from system_history

where ctime >= current_date

and ctime <= current_timestamp

and hostname <> 'mdw'

and hostname <> 'smdw'

group by current_date,

to_char(ctime, 'hh24'),

substr(to_char(ctime, 'mi'), 1, 1) || '0') t) a,

(select t.date || ' ' || t.hour || ':' || t.minute || ':00' time,

t.cpu_user,

t.cpu_sys,

t.mem_used,

t.iops,

t.disk_r_mb,

t.disk_w_mb

from (select current_date as date,

to_char(ctime, 'hh24') as hour,

substr(to_char(ctime, 'mi'), 1, 1) || '0' as minute,

round(avg(cpu_user) ::numeric, 2) cpu_user,

round(avg(cpu_sys) ::numeric, 2) cpu_sys,

round(avg(mem_actual_used) / 1024 / 1024 / 1024

::numeric,

2) mem_used,

round(avg(disk_ro_rate) ::numeric, 2) iops,

round(avg(disk_rb_rate) / 1024 / 1024 ::numeric, 2) disk_r_mb,

round(avg(disk_wb_rate) / 1024 / 1024 ::numeric, 2) disk_w_mb

from system_history

where ctime >= current_date - interval

'1 day'

and ctime <= current_timestamp - interval

'1 day'

and hostname <> 'mdw'

and hostname <> 'smdw'

group by current_date,

to_char(ctime, 'hh24'),

substr(to_char(ctime, 'mi'), 1, 1) || '0') t) b

where a.time = b.time

order by 1" | sed '$d' | sed '$d' >> $local_dest/daily_check.html

echo "</BODY>" >> $local_dest/daily_check.html

echo "</HTML>" >> $local_dest/daily_check.html

#发送邮件

./sendEmail.pl -f ${mailfrom} -t ${maillist} -u "gp58 $database_name daily check report" -s ${mailsmtp} -xu ${mailxu} -xp ${mailxp} -a daily_check.html -o message-file=$local_dest/daily_check.html

shenghe_chen
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
greenplum 运维监控参数配置
kevin
07-05 1112
一 . 状态监控 1.1gpstate 命令 参数 作用 gpstate -b => 显示简要状态 gpstate -c => 显示主镜像映射 gpstart -d => 指定数据目录（默认值：$MASTER_DATA_DIRECTORY） gpstate -e => 显示具有镜像状态问题的片段 gpstate -f => 显示备用主机详细信息 gpstate -i => 显示GRIPLUM数据库版本 gpstate -m => 显示镜像实例同.
Greenplum数据库巡检报告1
08-04
2.1 查看集群当前系统时间6 2.2 查看操作系统版本7 2.3 查看内核版本7 2.4 查看内存的详细信息7 2.4.1 查看内存的使用情况7 2.4.2
Greenplum数据库巡检报告
知识的力量
04-21 2406
更多的文章请关注作者微信公众号或访问作者github: https://github.com/xfg0218/greenplum--summarize 作者公众号 目录 目录 2 1 巡检说明 6 2 查看集群硬件相关信息 6 2.1 查看集群当前系统时间 6 2.2 查看操作系统版本 7 2.3 查看内核版本 7 2.4 查看内存的详细信息 7 2.4.1查看内...
反转！Greenplum 还在，快去 Fork 源码
最新发布
少安事务所
05-29 702
需要注意的是，Greenplum 是一个分析数据仓库，而不是一个事务关系数据库。虽然 Greenplum 确实有事务的概念，这对于提取、转换和加载 (ETL) 作业很有用，但你不应将其用于事务目的，如机票预订系统、空中交通管制等。值得一提的是， GPDB 目前是遵从 Apache-2.0 开源协议，这是一个非常宽松的开源许可，允许用户自由地使用、修改、复制和分发软件，包括商业用途，当然也可能会闭源。关于大家（包括某些国产数据库厂商）担心的源代码问题，GPDB源码并未被移除，只是归档，并更改了仓库名。
greenplum常用脚本
shenghe_chen
05-29 1174
1、创建资源队列 create resource queue name with (memory_limit='2000MB',active_statements=10); 每条sql的最大可使用内存为：memory_limit/active_statement;如果设置了max_cost，那么可使用的最大内存为：memory_limit*(query_cost/max_cost); quer...
greenplum - 简单常用查看gp状态命令
chuckchen1222的博客
06-22 8122
启动/关闭 gpstart gpstop -M fast gpstop -m gpstop --host sdw1 # 只关一个节点 查看状态 gpstate -b # brief status gpstate -c # show primary to mirror mappings gpstate -e # show segments with mirror status issues gpstate -f # show standby master details gpstate -i # .
greenplum监控台greenplum-cc-web 3.3.0 for linux
10-22
- 定期检查监控数据，及时调整系统配置，避免资源浪费。 - 针对性能瓶颈进行SQL优化，提高查询效率。 - 设置合理的报警策略，防止小问题演变为大故障。 - 定期备份监控数据，以便于分析历史问题和追踪性能变化。...
Greenplum清除mirror
12-03
在执行任何操作前，确保Greenplum集群处于健康状态，可以通过`gpstate -s`命令查看。输出中应显示"Mirror status = Synchronized"，表明所有镜像与主段同步。 2. **关闭集群**： 使用`gpstop -M fast -a`命令安全...
greenplum安装配置手册
05-22
Greenplum提供了丰富的监控工具，如`gpperfmon`，用于实时查看系统状态和查询性能。结合监控数据，可以对硬件资源、查询执行计划等进行调优，提升整体性能。 十、故障排查与维护 了解常见问题及解决办法，如磁盘...
greenplum-db-6.13.0-rhel7-x86_64.zip
12-12
- **监控与维护**：定期检查系统状态，使用`gprecoverseg`等工具进行故障恢复。 4. **学习资源** - 官方文档：Greenplum提供了详细的官方文档，包括安装、配置、使用等多个方面。 - 社区支持：在Stack Overflow...
SQL Server 维护脚本分享（13）数据库内部日常巡检
05-15 1741
--当前正在执行的语句 select session_id,transaction_id,wait_type,last_wait_type,wait_resource,start_time,status,command ,estimated_completion_time,cpu_time,logical_reads,text,open_transaction_count,open_results...
Postgresql巡检脚本
魂醉的一亩二分地
04-28 2291
#!/bin/bash # 程序名称：pg_healthcheck.sh ; 版本: 1.3 # 功能：PostgreSQL　数据库健康检查脚本; # 使用: ./pg_healthcheck.sh, 执行成功后生成报告文件 pg_healthcheck.report ，同时注意以下： # 1 此程序目前版本仅能在数据库主机上执行; # 2 此程序需要数据库超级权限; # 3 此程序需要使用数...
Mysql可视化巡检脚本
陈泽钦的博客
06-06 709
MYSQL可视化巡检脚本，交付客户再也不担心了.....
Postgresql可视化巡检脚本
Boychen
05-10 585
Postgresql巡检脚本巡检效果巡检命令巡检脚本 日常工作中，我们常常需要给客户做数据库进行巡检，并提交相关巡检报告。本脚本支持自动化巡检并导出相关报告。 脚本由纯 SQL 语言开发完成，只要有 Postgresql 客户端工具以及相关巡检用户就可以完成数据库的巡检。 巡检效果 巡检命令 psql -U postgres -h 192.168.56.111 -p 54324 -d postgres -W -H -f db_hc_postgresql_v2.0.0_12.5_by_czq.s
postgresql 数据库巡检
qq_33445829的博客
09-01 1979
pg数据库巡检 postgresql数据库巡检脚本
Greenplum 资源状态查看记录
m0_38105675的博客
11-17 2281
作为BI工程师，对SQL的熟练掌握必不可少，greenplum作为MPP数据库，当然需要深入了解一些重要的开发技巧。 日常SQL开发规范要求： 1.代码行清晰、整齐、层次分明、结构性强，易于阅读； 2.代码中应具备必要的注释以增强代码的可读性和可维护性； 3.代码应充分考虑执行效率，保证代码的高效性； Greenplum数据字典使用,有个重要的schema,分别是：pg_catalog,pg...
GreenPlum 数据库启动关闭及数据库状态检查
weixin_34413065的博客
07-04 2576
本篇文章主要记录GreenPlum数据库的启动、关闭及状态查询。GreenPlum数据库提供gpstart和gpstop脚本来启动和关闭数据库，可以通过—help参数来查看这些脚本的帮助信息。 view source 01 [gpadmin@mdw master]$ gpstart --help 02 COMMAN...
Greenplum或DeepGreen中检查资源队列状态
DataFlow范式
06-18 3523
查看分配到资源队列的 ROLE 要查看ROLE与资源队列之间的关联关系，使用系统日志表pg_roles和gp_toolkit.gp_resqueue_status来获得： SELECT rolname, rsqname FROM pg_roles, gp_toolkit.gp_resqueue_status WHERE pg_roles.rolresqueue=gp_toolkit.gp_r
/usr/local/greenplum-db/./lib/libz.so.1: no version information available
06-07
ldd /usr/local/greenplum-db/./lib/libz.so.1 ``` 3. 如果应用程序链接的zlib库版本与系统中安装的版本不同，您可以尝试将应用程序链接到系统中的zlib库。您可以使用以下命令将应用程序链接到系统中的zlib库： ``...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值