[Linux-sunucu] Re: veritabanı cluster önerisi

[Osman Yozgatlioglu]

Dosya ekte.

2011/1/4 Devrim GÜNDÜZ <dev...@gunduz.org>:
> On Tue, 2011-01-04 at 15:12 +0200, Osman Yozgatlioglu wrote:
>> Aslında iç tarafta ne gibi sorunlar var bilmiyorum. Sorunu black box
>> olarak görüp çözüm üretmem isteniyor. :)
>
> Peki :)
>
> Ne kadar kara kutu? PostgreSQL'e girip ayar yapıp log çıkartabilecek
> durumda mısınız? PostgreSQL'in hangi sürümü? Memory ayarları ne durumda?
> Bunları öğrenebilecekseniz ben size hangi parametreleri
> sorgulayacağımızı yazabilirim.
>
> ya da siz şunu indirip:
>
> http://bucardo.org/downloads/boxinfo.pl
>
> aşağıdaki komutu çalıştırabilirsiniz:
>
> perl boxinfo.pl  --nomysql --format=html
>
> Oluşacak boxinfo.html dosyasını ister bana özelden, ister listeye
> gönderin, beraber bakalım.
>
> ...derim :)
> --
> Devrim GÜNDÜZ
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> PostgreSQL RPM Repository: http://yum.pgrpms.org
> Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
>
> _______________________________________________
> Linux-sunucu E-Posta Listesi
> Linux-sunucu@liste.linux.org.tr
>
> Liste kurallarını http://liste.linux.org.tr/kurallar.php  bağlantısından 
> okuyabilirsiniz;
>
> Bu Listede neden bulunduğunuzu bilmiyorsanız veya artık bu listeden gelen 
> e-postaları almak istemiyorsanız aşağıdaki bağlantı adresini kullanarak 1 
> dakika içinde üyeliğinizi sonlandırabilirsiniz.
> https://liste.linux.org.tr/mailman/listinfo/linux-sunucu
>
>


[[ACME]] Postgres server payrollapp:


Date gathered:Tue Jan  4 15:32:08 EET 2011
Program version:1.3.2
Hostname:payrollapp
OS:linux
CPU:4 x AMD Phenom(tm) II X4 955 Processor (3214 MHz) Cache size: 512 KB
RAM:7.70 GB
VM:No

Uptime:161 days

Users:1

Load average:0.95

Debian version:5.0.5

Kernel info:Kernel name: LinuxKernel release: 2.6.26-2-amd64Kernel version: #1 SMP Sun Jun 20 20:16:30 UTC 2010Hardware name: x86_64

Memory:shmmax: 32 MB
shmmni: 4096
shmall: 2 MB
swappiness: 60
dirty_ratio: 10
dirty_background_ratio: 5
Free: 881.51 MB
Cached: 4.43 GB
Active: 6.07 GB
Swap Total: 6.09 GB


Active shared mem:Active segments: 1
Active semaphores: 7
Active messages: 0


Interfaces:
NameIPStatusSpeedeth0212.58.21.62Active?
lo127.0.0.1ActiveN/A


Routes:
DestinationGatewayGenmaskInterface212.58.21.560.0.0.0255.255.255.248eth0
0.0.0.0212.58.21.570.0.0.0eth0


Mounting info:
NameMountSize/Used %Inode %Filesystem (options)/dev/sda1/141G/15%2%
ext3 (rw,errors=remount-ro)
tmpfs/dev/shm3.9G/0%1%
tmpfs (rw,nosuid,nodev)
udev/dev10M/8%1%
tmpfs (rw,mode=0755)


Kernel queue info:
BlockRead ahead sizeSchedulersda64 KBnoop anticipatory deadline [cfq] 


Program versions:
NameVersionNameVersion
apt-get0.7.20.2 aptitude0.4.11.11awk3.1.5 bash3.2.39(1)-releasebzip21.0.5 dpkg1.14.29exim4.69 find4.4.0gpg1.4.9 gzip1.3.12iconv2.7 mii-tool1.9nano2.0.7 openssl0.9.8gperl5.10.0 pg_dump8.3.11psql8.3.11 python2.5.2rsync3.0.3 sar8.1.2screen4.00.03jw4 sed4.1.5ssh5.1p1 syslog-ng2.0.9vi7.1 vim7.1wget1.11.4 zip2.32

Perl info:
Version:5.10.0
IThreads:Yes
Multiplicity:Yes


Perl modules:
ModuleVersion[http://search.cpan.org/dist/Digest-MD5 Digest::MD5]2.36_01
[http://search.cpan.org/dist/Sys-Syslog Sys::Syslog]0.22
[http://search.cpan.org/dist/Time-HiRes Time::HiRes]1.9711


Active Postgres clusters:
PortSocket dirVersion
5432/var/run/postgresql/?


User limits:
NameLimitPOSIX message queues819200
core file size0
cpu timeunlimited
data seg sizeunlimited
file locksunlimited
file sizeunlimited
max locked memory32
max memory sizeunlimited
max user processes70656
open files1024
pending signals70656
pipe size8
real-time priority0
scheduling priority0
stack size8192
virtual memoryunlimited


ENVs:
NameValue
HOME/root
LANGen_US.UTF-8
LOGNAMEroot
MAIL/var/mail/root
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
SHELL/bin/bash
USERroot
_/usr/bin/perl


apt-get installs:
NameAutomatic?
NameAutomatic
acpi-support-baseNo
acpidNo
adduserNo
aptNo
apt-utilsNo
aptitudeNo
arjNo
atNo
avahi-daemonYes
base-filesNo
base-passwdNo
bashNo
bash-completionNo
bcNo
bind9-hostNo
bsd-mailxNo
bsdmainutilsNo
bsdutilsNo
busyboxNo
bwm-ngNo
bzip2No
console-commonNo
console-dataNo
console-terminusNo
console-toolsNo
coreutilsNo
cpioNo
cronNo
dbusYes
dbus-x11Yes
dcNo
debconfNo
debconf-i18nNo
debian-archive-keyringNo
debian-faqNo
debianutilsNo
defomaYes
dhcp3-clientNo
dhcp3-commonNo
dictionaries-commonNo
diffNo
dmidecodeNo
dnsutilsNo
doc-debianNo
doc-linux-textNo
dpkgNo
e2fslibsNo
e2fsprogsNo
edNo
ejectNo
exim4No
exim4-baseNo
exim4-configNo
exim4-daemon-lightNo
fileNo
findutilsNo
ftpNo
gawkYes
gcc-4.2-baseNo
gcc-4.3-baseNo
gettext-baseNo
gnupgNo
gpgvNo
grepNo
groff-baseNo
grubNo
grub-commonYes
gsfontsYes
gsfonts-x11Yes
gzipNo
hostnameNo
iamericanNo
ibritishNo
ifupdownNo
infoNo
initramfs-toolsNo
initscriptsNo
installation-reportNo
iotopNo
iprouteNo
iptablesNo
iputils-pingNo
ispellNo
java-commonYes
klibc-utilsYes
language-envNo
laptop-detectNo
lessNo
libacl1No
libasound2Yes
libattr1No
libavahi-common-dataYes
libavahi-common3Yes
libavahi-core5Yes
libbind9-40No
libbind9-50Yes
libblkid1No
libbz2-1.0No
libc6No
libc6-i386No
libcap1Yes
libcap2No
libcomerr2No
libconsoleNo
libcwidget3No
libdaemon0Yes
libdb4.5No
libdb4.6No
libdbus-1-3Yes
libdevmapper1.02.1No
libdns45No
libdns55Yes
libedit2No
libept0No
libevent1No
libevtlog0Yes
libexpat1Yes
libfontenc1Yes
libfreetype6Yes
libgc1c2No
libgcc1No
libgcrypt11No
libgdbm3No
libglib2.0-0Yes
libglib2.0-dataYes
libgnutls26No
libgpg-error0No
libgpm2No
libgssglue1No
libice6Yes
libidn11No
libio-multiplex-perlYes
libisc45No
libisc52Yes
libisccc40No
libisccc50Yes
libisccfg40No
libisccfg50Yes
libkeyutils1No
libklibcYes
libkrb53No
libldap-2.4-2No
liblocale-gettext-perlNo
liblockfile1No
libltdl3Yes
liblwres40No
liblwres50Yes
libmagic1No
libncurses5No
libncursesw5No
libnet-cidr-perlYes
libnet-server-perlYes
libnet-snmp-perlYes
libnewt0.52No
libnfsidmap2No
libnss-mdnsYes
libossp-uuid15Yes
libpam-modulesNo
libpam-runtimeNo
libpam0gNo
libpcap0.8Yes
libpci3No
libpcre3No
libpopt0No
libpq5Yes
libreadline5No
librpcsecgss3No
librsync1Yes
libsasl2-2No
libselinux1No
libsensors4Yes
libsepol1No
libsigc++-2.0-0c2aNo
libslang2No
libsm6Yes
libsqlite3-0No
libss2No
libssl0.9.8No
libstatgrab6Yes
libstdc++6No
libtasn1-3No
libtext-charwidth-perlNo
libtext-iconv-perlNo
libtext-wrapi18n-perlNo
libusb-0.1-4No
libuuid1No
libvolume-id0Yes
libwrap0No
libx11-6Yes
libx11-dataYes
libxapian15No
libxau6Yes
libxcb-xlib0Yes
libxcb1Yes
libxdmcp6Yes
libxext6Yes
libxfont1Yes
libxi6Yes
libxml2No
libxmuu1Yes
libxslt1.1Yes
libxt6Yes
libxtst6Yes
linux-image-2.6-amd64No
linux-image-2.6.26-2-amd64Yes
lm-sensorsNo
localesNo
lockfile-progsYes
loginNo
logrotateNo
lsb-baseNo
lsofNo
lynxNo
lynx-curYes
lzmaNo
m4No
makedevNo
man-dbNo
manpagesNo
manpages-trNo
mawkNo
mcNo
mime-supportNo
mktempNo
mlocateNo
module-init-toolsNo
mountNo
munin-nodeNo
muttNo
nanoNo
ncurses-baseNo
ncurses-binNo
ncurses-termNo
net-toolsNo
netbaseNo
netcat-traditionalNo
nfs-commonNo
nmapNo
ntpdateNo
odbcinst1debian1Yes
openbsd-inetdNo
openssh-blacklistYes
openssh-blacklist-extraYes
openssh-clientNo
openssh-serverYes
opensslYes
openssl-blacklistYes
passwdNo
patchNo
pciutilsNo
perlNo
perl-baseNo
perl-modulesNo
portmapNo
postgresqlNo
postgresql-8.3Yes
postgresql-client-8.3Yes
postgresql-client-commonYes
postgresql-commonYes
postgresql-contrib-8.3No
procmailNo
procpsNo
pythonNo
python-centralNo
python-minimalNo
python-supportYes
python2.5No
python2.5-minimalNo
rarNo
rdiffNo
readline-commonNo
reportbugNo
rsyncNo
screenNo
sedNo
smartmontoolsNo
sshNo
ssl-certYes
stunnelNo
stunnel4Yes
sun-java6-binYes
sun-java6-jdkNo
sun-java6-jreYes
syslog-ngNo
sysstatNo
sysv-rcNo
sysvinitNo
sysvinit-utilsNo
tarNo
taskselNo
tasksel-dataNo
tcpdNo
telnetNo
texinfoNo
timeNo
tracerouteNo
tzdataNo
ucfNo
udevNo
unixodbcYes
unrarNo
unzipNo
update-inetdNo
usbutilsNo
util-linuxNo
util-linux-localesNo
vim-commonNo
vim-tinyNo
w3mNo
wamericanNo
wgetNo
whiptailNo
whoisNo
x11-commonYes
xauthYes
xfonts-encodingsYes
xfonts-utilsYes
zipNo
zlib1gNo
 



_______________________________________________
Linux-sunucu E-Posta Listesi
Linux-sunucu@liste.linux.org.tr

Liste kurallarını http://liste.linux.org.tr/kurallar.php  bağlantısından 
okuyabilirsiniz;

Bu Listede neden bulunduğunuzu bilmiyorsanız veya artık bu listeden gelen 
e-postaları almak istemiyorsanız aşağıdaki bağlantı adresini kullanarak 1 
dakika içinde üyeliğinizi sonlandırabilirsiniz.
https://liste.linux.org.tr/mailman/listinfo/linux-sunucu

[[Category:Postgres servers]]