1PostgreSQL,PostgreSQLmonitoringandmonitoringpostgresql.
orgStefanKaltenbrunnerstefan@kaltenbrunner.
cchttp://www.
kaltenbrunner.
cc/blogNagiosconference2008Nuremberg,GermanySeptember2008AboutmyselfStefanKaltenbrunnerSeniorSystemsArchitectatconovacommunicationsMajorcontributortoPostgreSQLprojectInfrastructureandWebteamPatchesandPortabilityAgendaPostgreSQLPostgreSQLInternalsMonitoringPostgreSQLWhat,WhyandHowToolsMonitoringpostgresql.
orgQ&AAgendaPostgreSQLPostgreSQLInternalsMonitoringPostgreSQLWhat,WhyandHowToolsMonitoringpostgresql.
orgQ&APostgreSQLBSDlicencedORDBMSOpensourceProject20yearold,13yearsofOSSFast,reliableandstrongcommunityAdaptedandusedasthebaseforcommercialandproprietarysolutionsPostgreSQL~900.
000linesofcodehundredsofsubprojects~200activedevelopershttp://ohloh.
netprojects/postgres/AgendaPostgreSQLPostgreSQLInternalsMonitoringPostgreSQLWhat,WhyandHowToolsMonitoringpostgresql.
orgQ&AProcessbasedarchitectureOneprocessperconnectionNumberofdedicatedprocessesSharedmemoryOSlevelcachingHighlyportable(Unix,Windows,.
.
.
)PostgreSQLInternalsPIDTTYSTATTIMECOMMAND3321S0:01/usr/local/pgsql/bin/postgres-D/var/data/pg833324Ss0:10\_postgres:writerprocess3325Ds0:06\_postgres:walwriterprocess3326Ss0:02\_postgres:autovacuumlauncherprocess3327Ss0:01\_postgres:statscollectorprocess27998Ds0:14\_postgres:postgrestest[local]SELECT28583Ss0:01\_postgres:postgrestest[local]INSERTPostgreSQLInternalsPIDTTYSTATTIMECOMMAND3321S0:01/usr/local/pgsql/bin/postgres-D/var/data/pg833324Ss0:10\_postgres:writerprocess3325Ds0:06\_postgres:walwriterprocess3326Ss0:02\_postgres:autovacuumlauncherprocess3327Ss0:01\_postgres:statscollectorprocess27998Ds0:14\_postgres:postgrestest[local]SELECT28583Ss0:01\_postgres:postgrestest[local]INSERTPostgreSQLInternalsPIDTTYSTATTIMECOMMAND3321S0:01/usr/local/pgsql/bin/postgres-D/var/data/pg833324Ss0:10\_postgres:writerprocess3325Ds0:06\_postgres:walwriterprocess3326Ss0:02\_postgres:autovacuumlauncherprocess3327Ss0:01\_postgres:statscollectorprocess27998Ds0:14\_postgres:postgrestest[local]SELECT28583Ss0:01\_postgres:postgrestest[local]INSERTPostgreSQLInternalsPIDTTYSTATTIMECOMMAND3321S0:01/usr/local/pgsql/bin/postgres-D/var/data/pg833324Ss0:10\_postgres:writerprocess3325Ds0:06\_postgres:walwriterprocess3326Ss0:02\_postgres:autovacuumlauncherprocess3327Ss0:01\_postgres:statscollectorprocess27998Ds0:14\_postgres:postgrestest[local]SELECT28583Ss0:01\_postgres:postgrestest[local]INSERTPostgreSQLInternalsPIDTTYSTATTIMECOMMAND3321S0:01/usr/local/pgsql/bin/postgres-D/var/data/pg833324Ss0:10\_postgres:writerprocess3325Ds0:06\_postgres:walwriterprocess3326Ss0:02\_postgres:autovacuumlauncherprocess3327Ss0:01\_postgres:statscollectorprocess27998Ds0:14\_postgres:postgrestest[local]SELECT28583Ss0:01\_postgres:postgrestest[local]INSERTPostgreSQLInternalsPIDTTYSTATTIMECOMMAND3321S0:01/usr/local/pgsql/bin/postgres-D/var/data/pg833324Ss0:10\_postgres:writerprocess3325Ds0:06\_postgres:walwriterprocess3326Ss0:02\_postgres:autovacuumlauncherprocess3327Ss0:01\_postgres:statscollectorprocess27998Ds0:14\_postgres:postgrestest[local]SELECT28583Ss0:01\_postgres:postgrestest[local]INSERTPostgreSQLInternalsAgendaPostgreSQLPostgreSQLInternalsMonitoringPostgreSQLWhat,WhyandHowToolsMonitoringpostgresql.
orgQ&AMonitoringPostgreSQLPieceofsoftware–needsCPU,RAMandDiskCurrentstateHistoricstateTrendsApplicationspecificinformationSlowqueriesErrorsInternalstateAgendaPostgreSQLPostgreSQLInternalsMonitoringPostgreSQLWhat,WhyandHowToolsMonitoringpostgresql.
orgQ&APostgreSQLMonitoringDirectandindirectIO,CPUandMemoryusageMaintenancetasksBackgroundactivityAverageandworstcaselatencyApplicationspecificusesPostgreSQLMonitoringLocksActiveQueriesQueryDistributionCacheefficiencyDiskUsageAgendaPostgreSQLPostgreSQLInternalsMonitoringPostgreSQLWhat,WhyandHowToolsMonitoringpostgresql.
orgQ&AMonitoringPostgreSQLStatisticscollectorSystemcatalogsLogfiles(role,databaseandsession)DtraceOperatingSystemtoolsMonitoringPostgreSQLcheck_postgres.
plpgFouineMuninpgsnmpdcat/grep/awkandsedTools-check_postgres.
plSwissarmyknifeofstatusmonitoringTablesizes,Transactionstatus,replication,maintainanceoperations,locks,numberofconnectionsandqueryruntimeMRTGmodeMusthaveforanynagiosbasedPostgreSQLmonitoringTools-check_postgres.
plmastermind@mastermind:~$check_postgres.
pl-w"10MB"-dbtest--actiondatabase_sizePOSTGRES_DATABASE_SIZEWARNING:DB"test"test:43719908(42MB)postgres:4324580(4223kB)template0:4243460(4144kB)template1:4243460(4144kB)|time=0.
04test=43719908postgres=4324580template0=4243460template1=4243460mastermind@mastermind:~$check_postgres.
pl-w"16"-dbtest--actionwal_filesPOSTGRES_WAL_FILESOK:8|time=0.
04mastermind@mastermind:~$check_postgres.
pl-w"1minute"-dbtest--actionquery_runtime--queryname"pg_class"POSTGRES_QUERY_RUNTIMEOK:DB"test"queryruntime:0.
00089seconds|time=0.
04qtime=0.
00089mastermind@mastermind:~$check_postgres.
pl-w"1minute"-dbtest--actiontxn_timePOSTGRES_TXN_TIMEWARNING:longesttxn:528s|time=0.
04maxtime:528Tools-pgFouinePHPbasedlogfileanalyzerCreatesnicelyformatedreportsreplay/benchmarkintegrationRequiresqueryloggingTools-pgFouineTools-pgFouineTools-MuninSimplemonitoringsolutionPluginbasedwithagentonthehostPostgresqlpluginsavailableNagiosintegrationforalertingTools-MuninTools-pgsnmpdSNMPbasedmonitoringRFC1697(RDBMS-MIB)NoPostgreSQLspecificMIByetMostlyusefulinSNMPonlyenvironmentsAgendaPostgreSQLPostgreSQLInternalsMonitoringPostgreSQLWhat,WhyandHowToolsMonitoringpostgresql.
orgQ&AMonitoringpostgresql.
org~50monitoredhosts(abouthalffullycommunitymanaged)340monitoredservicesFreeBSD,Debian,Ubuntu,Slackware,CentOS,RedhatEnterpriseLinuxandVMwareAustria,Canada,France,Israel,Panama,Sweden,USAMonitoringpostgresql.
orgNagiosbasedSmokepinglatencytrackingMuningraphingTracConfigurationchangemanagementInternalticketingDocsCoordinationthroughIMandMailinglistsMonitoringpostgresql.
orgFreeBSDjails2-8jails/hostNagios+NRPEMunin/SmokepingCustomchecksProjectspecificthingsHardwarechecksSecurityrelatedchecksMonitoringpostgresql.
orgThankyou!
Questions
优林怎么样?优林好不好?优林 是一家国人VPS主机商,成立于2016年,主营国内外服务器产品。云服务器基于hyper-v和kvm虚拟架构,国内速度还不错。今天优林给我们带来促销的是国内东北地区哈尔滨云服务器!全部是独享带宽!首月5折 续费5折续费!地区CPU内存硬盘带宽价格购买哈尔滨电信2核2G50G1M53元直达链接哈尔滨电信4核4G50G1M83元直达链接哈尔滨电信8核8G50G1M131元直...
弘速云是创建于2021年的品牌,运营该品牌的公司HOSU LIMITED(中文名称弘速科技有限公司)公司成立于2021年国内公司注册于2019年。HOSU LIMITED主要从事出售香港VPS、美国VPS、香港独立服务器、香港站群服务器等,目前在售VPS线路有CN2+BGP、CN2 GIA,该公司旗下产品均采用KVM虚拟化架构。可联系商家代安装iso系统。国庆活动 优惠码:hosu10-1产品介绍...
昨天我们很多小伙伴们应该都有看到,包括有隔壁的一些博主们都有发布Vultr商家新的新用户注册福利活动。以前是有赠送100美元有效期30天的,这次改成有效期14天。早年才开始的时候有效期是60天的,这个是商家行为,主要还是吸引到我们后续的充值使用,毕竟他们的体验金赠送,在同类商家中算是比较大方的。昨天活动内容:重新调整Vultr新注册用户赠送100美元奖励金有效期14天今天早上群里的朋友告诉我,两年...
postgresql9.0为你推荐
硬盘工作原理高人指点:电子存储器(U盘,储存卡,硬盘等)的工作原理梦之队官网NBA梦之队是什么游戏?www.983mm.comwww.47683.combbs.99nets.com送点卷的冒险岛私服mole.61.com谁知道摩尔庄园的网址啊789se.comhttp://gv789.com/index.php这个网站可信吗?是真的还是假的!qq530.com求教:如何下载http://www.qq530.com/ 上的音乐www.ca800.com西门子plc仿真软件有什么功能鹤城勿扰黑龙江省的那个 城市是被叫做鹤城?剑影绝杀dnf匕首刺客刷图天诛、弧光闪、迅影、绝杀斩要不要加满,给理由
100m网站空间 域名备案号查询 lamp 企业主机 dns是什么 便宜域名 uk2 账号泄露 win8升级win10正式版 本网站在美国维护 卡巴斯基官方免费版 gtt 银盘服务是什么 drupal安装 什么是web服务器 德隆中文网 测速电信 七牛云存储 香港ip 低价 更多