server下载 wget https://cdn.zabbix.com/zabbix/sources/stable/5.0/zabbix-5.0.12.tar.gztar -zxvf zabbix-5.0.12.tar.gzcd zabbix-5.0.12./configure --enable-agentmkdir src/modules/zabbix_module_streecd src/modules/zabbix_module_streewget https://raw.githubusercontent.com/monitoringartist/zabbix-server-stress-test/master/src/modules/zabbix_module_stress/zabbix_module_stress.cwget https://raw.githubusercontent.com/monitoringartist/zabbix-server-stress-test/master/src/modules/zabbix_module_stress/Makefilemakegcc -fPIC -shared -o zabbix_module_stress.so zabbix_module_stress.c -I../../../include[root@sdw4 zabbix_module_stree]# lsMakefile zabbix_module_stress.c zabbix_module_stress.so
[root@sdw4 zabbix_module_stree]# sudo cp zabbix_module_stress.so /etc/zabbix/modules/[root@sdw4 zabbix_module_stree]# ls /etc/zabbix/modules/zabbix_module_stress.so

vim /etc/opt/rh/rh-nginx116/nginx/nginx.confnginx client_max_body_size默认只有1MB，修改为如下大小 client_max_body_size 50m; 
php参数修改报错 413 Request Entity Too Largevim /etc/opt/rh/rh-php72/php.iniupload_max_filesize = 50M

vim /etc/zabbix/zabbix_agentd.confLoadModulePath=/etc/zabbix/modulesLoadModule=zabbix_module_stress.so

[root@sdw3 data]# ls /data/zabbix1/modules zabbix_agentd.conf zabbix_agentd.d zabbix_agentd.log zabbix_agentd.pid[root@sdw3 data]# cat /data/zabbix1/zabbix_agentd.conf PidFile=/data/zabbix1/zabbix_agentd.pidLogFile=/data/zabbix1/zabbix_agentd.logLogFileSize=0Server=192.168.100.14ListenPort=10051ServerActive=192.168.100.14Hostname=sdw3_10051Include=/data/zabbix1/zabbix_agentd.d/*.conf

[root@sdw3 data]# cat moreagent.sh #!/bin/bash# 批量拉起200个agent并启动for i in {1..200}do  echo $i port=$[ 10050+${i} ] echo $port mkdir /data/zabbix${i} -p cp -r /data/zabbix1/* /data/zabbix${i}/ #rm -rf /data/zabbix${i}/*.log #rm -rf /data/zabbix${i}/*.pid sed -i 's/10051/'${port}'/g' zabbix${i}/zabbix_agentd.conf  sed -i 's/zabbix1/'zabbix${i}'/g' zabbix${i}/zabbix_agentd.conf chown zabbix.zabbix -R /data/zabbix${i}/ zabbix_agentd -c /data/zabbix${i}/zabbix_agentd.conf done

[shidb@sdw4 ~]$ sudo cat /etc/zabbix/zabbix_server.conf |grep -v '^#'|grep -v "^$"ListenPort=10051SourceIP=192.168.100.14LogFile=/var/log/zabbix/zabbix_server.logLogFileSize=0DebugLevel=3PidFile=/var/run/zabbix/zabbix_server.pidSocketDir=/var/run/zabbixDBHost=sdw7DBName=zabbixDBUser=zabbixDBPassword=123456DBPort=5432StartPollers=50StartPollersUnreachable=10StartTrappers=500StartPingers=10StartDiscoverers=50StartAlerters=30VMwareCacheSize=1024MSNMPTrapperFile=/var/log/snmptrap/snmptrap.logMaxHousekeeperDelete=100CacheSize=2048MStartDBSyncers=10HistoryCacheSize=1024MHistoryIndexCacheSize=400MTrendCacheSize=1024MValueCacheSize=2048MTimeout=30TrapperTimeout=300UnreachablePeriod=45UnavailableDelay=60UnreachableDelay=15AlertScriptsPath=/usr/lib/zabbix/alertscriptsExternalScripts=/usr/lib/zabbix/externalscriptsFpingLocation=/usr/sbin/fpingLogSlowQueries=10000StartProxyPollers=100ProxyConfigFrequency=3600StartLLDProcessors=10

gpconfig -c log_min_duration_statement -v 2000 -m 2000gpconfig -c log_statement -v ddl -m ddlgpconfig -c shared_buffers -v 2GB -m 2GBgpconfig -c enable_nestloop -v on -m ongpconfig -c log_duration -v off -m offgpconfig -c shared_buffers -v 2G -m 2Ggpstop -M fast -ar

2021-06-18 10:48:20.644735 CST,"zabbix","zabbix",p33198,th-1770440576,"192.168.100.14","20100",2021-06-18 10:48:19 CST,0,con95580,cmd5529,seg-1,,,,sx1,"ERROR","XX000","DELETE uses system-defined column ""sessions.ctid"" without the necessary companion column ""sessions.gp_segment_id"" (cdbmutate.c:326)",,"To uniquely identify a row within a distributed table, use the ""gp_segment_id"" column together with the ""ctid"" column.",,,,"delete from sessions where lastaccess<1592448499 and ctid = any(array(select ctid from sessions where lastaccess<1592448499 limit 100))",0,,"cdbmutate.c",326,"Stack trace:1 0xd3ada3 postgres errstart (elog.c:498)2 0xe036d9 postgres cdbmutate_warn_ctid_without_segid (cdbmutate.c:323)3 0xa3fe2b postgres make_one_rel (allpaths.c:376)4 0xa75e5c postgres query_planner (planmain.c:306)5 0xa7cb3c postgres <symbol not found> (planner.c:2493)6 0xa7f68f postgres subquery_planner (planner.c:1286)7 0xa80959 postgres standard_planner (planner.c:524)8 0xa8159d postgres planner (planner.c:317)9 0xb80edc postgres <symbol not found> (postgres.c:1013)10 0xb83680 postgres PostgresMain (postgres.c:5273)11 0x6c6e5b postgres <symbol not found> (postmaster.c:4620)12 0xade2bf postgres PostmasterMain (postmaster.c:1594)13 0x6cc949 postgres main (discriminator 17)14 0x7f2e93185555 libc.so.6 __libc_start_main + 0xf515 0x6d846f postgres <symbol not found> + 0x6d846f

select distinct d.triggerid_down,d.triggerid_up from trigger_depends d,triggers t,hosts h,items i,functions f where t.triggerid=d.triggerid_down and t.flags<>2 and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=d.triggerid_down and h.status in (0,1);
190375:20210604:171847.981 slow query: 25.379318 sec, "update ids set nextid=nextid+1 where table_name='hosts' and field_name='hostid'"
190780:20210604:172526.128 slow query: 117.019717 sec, "update ids set nextid=nextid+2 where table_name='applications' and field_name='applicationid'"

[mxadmin@sdw7 log]$ gpconfig -c max_connections -v 2000 -m 1000[mxadmin@sdw7 log]$ gpconfig -s max_connectionsValues on all segments are consistentGUC : max_connectionsMaster value: 1000Segment value: 2000