Outlier

Tem 17 2010 · OS : FreeBSD

MaxClients = Total available memory * 80% / Max memory usage of apache process
#ps -ylC httpd --sort:rss
DirectoryIndex index.php index.html index.htm
Options -Indexes FollowSymLinks

<IfModule mod_expires.c>
 ExpiresActive On
 ExpiresDefault "access plus 1 seconds"
 ExpiresByType text/html "access plus 1 seconds"
 ExpiresByType image/gif "access plus 1 week"
 ExpiresByType image/jpeg "access plus 1 week"
 ExpiresByType image/png "access plus 1 week"
 ExpiresByType text/css "access plus 1 week"
 ExpiresByType text/javascript "access plus 1 week"
 ExpiresByType application/x-javascript "access plus 1 week"
 ExpiresByType text/xml "access plus 1 seconds"
 </IfModule>

#cp -rpv /usr/local/pgsql/data/postgresql.conf /usr/local/pgsql/data/postgresql.conf_org
FATAL:  could not create shared memory segment: Invalid argument
DETAIL:  Failed system call was shmget(key=5432001, size=660709376, 03600).
HINT:  This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter.
You can either reduce the request size or reconfigure the kernel with larger SHMMAX.
To reduce the request size (currently 660709376 bytes), reduce PostgreSQL's shared_buffers parameter (currently 78592) and/or its max_connections parameter (currently 43).
If the request size is already small, it's possible that it is less than your kernel's SHMMIN parameter, in which case raising the request size or reconfiguring SHMMIN is called for.
The PostgreSQL documentation contains more information about shared memory configuration.
# sysctl -w kern.ipc.shmmax=2147483648
kern.ipc.shmmax: 536870912 -> 2147483648
# sysctl -w kern.ipc.shmall=524288
kern.ipc.shmall: 131072 -> 524288
# vi /usr/local/pgsql/data/postgresql.conf
shared_buffers = 512MB
# /usr/local/etc/rc.d/postgresql restart
# SHOW shared_buffers ;
 shared_buffers
----------------
 512MB
(1 row)

kern.ipc.shmmax=2147483648
kern.ipc.shmall=524288
# SHOW effective_cache_size ;
 effective_cache_size
----------------------
 128MB
(1 row)

effective_cache_size = 2048MB
# SHOW effective_cache_size ;
effective_cache_size
----------------------
 2GB
(1 row)

/usr/local/bin/vacuumdb -z -a -U database_user
#portsnap fetch

#portsnap extract
# cd  /usr/ports/lang/php52
 # make
 # make install
 # make clean
ctype:    The ctype shared extension for php
curl:    The curl shared extension for php
dom:      The dom shared extension for php
gd:       The gd shared extension for php
imap:     The imap shared extension for php
mbstring: The mbstring shared extension for php
mcrypt:   The mcrypt shared extension for php
mysql:    The mysql shared extension for php
mysqli:   The mysqli shared extension for php
pcre:     The pcre shared extension for php
posix:  The posix shared extension for php
session:  The session shared extension for php
simplexml: The simplexml shared extension for php
xml:  The xml shared extension for php
xmlreader: The xmlreader shared extension for php
xmlwriter: The xmlwriter shared extension for php
zlib:  The zlib shared extension for php

# cd /usr/ports/lang/php52-extensions
 # make
 # make install
 # make clean
# cd /usr/ports/www/lighttpd
# make
# make install
# make clean
# echo 'lighttpd_enable="YES"' >> /etc/rc.conf
# mkdir -p /usr/local/www/data
# echo 'HELLO. LIGHTTPD WORKS' > /usr/local/www/data/index.html

# nano +43 /usr/local/etc/lighttpd.conf

server.errorlog             = "/var/log/lighttpd.error.log"

server.errorlog             = "/var/log/<em>lighttpd/</em>lighttpd.error.log"

accesslog.filename          = "/var/log/lighttpd.access.log"

accesslog.filename          = "/var/log/<em>lighttpd/</em>lighttpd.access.log"

server.modules              += ( "mod_fastcgi" )
fastcgi.server = ( ".php" =>
( "localhost" =>
                     (
                        "socket" => "/tmp/php-fastcgi.socket",
                        "bin-path" => "/usr/local/bin/php-cgi"
                      )
                   )
)
# mkdir /var/log/lighttpd
# chown www:www /var/log/lighttpd
# /usr/local/etc/rc.d/lighttpd start
# cd /usr/ports/databases/postgresql84-server
# make config
# make install clean
# echo 'postgresql_enable="YES"' >> /etc/rc.conf
# /usr/local/etc/rc.d/postgresql initdb
/usr/local/etc/rc.d/postgresql initdb
The files belonging to this database system will be owned by user "pgsql".
This user must also own the server process.

The database cluster will be initialized with locale C.
The default text search configuration will be set to "english".

fixing permissions on existing directory /usr/local/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 40
selecting default shared_buffers ... 28MB
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.

Success. You can now start the database server using:

    /usr/local/bin/postgres -D /usr/local/pgsql/data
or
    /usr/local/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start

# /usr/local/etc/rc.d/postgresql start
$ su -
# cd /usr/local/etc/rc.d/
# vi myscript.sh

#!/bin/sh
# This shell script is a test and will paste a "test.txt" file on my desktop
echo 'Test' > ~charles/Desktop/test.txt
chown charles:charles ~charles/Desktop/test.txt

# chmod +x myscript.sh

# vi /etc/rc.conf

myscript_enable="YES"

Pts	Sal	Çar	Per	Cum	Cts	Paz
« Ağu
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30

Outlier

WEB Server Performansını Nasıl Arttırırım? -3

3- İşletim Sistemi Performans Arttırımı

4- WEB Server Performans Arttırımı

a) PHP Performans Arttırımı

b) Apache Performans Arttırımı

c) Lighttpd, NginX ve Cherokee Performans Arttırımı

3- İşletim Sistemi Performans Arttırımı

4- WeB Server Performans Arttırımı

a) PHP Performans Arttırımı

b) Apache Performans Arttırımı

c) Lighttpd, NginX ve Cherokee Performans Arttırımı

KAYNAKLAR;

PostgreSQL Performans Tuning

OS : FreeBSD

CPU: Dual-Core AMD Opteron(tm) Processor 1210 (1809.29-MHz K8-class CPU)

real memory = 4294967296 (4096 MB)

ad4: 238475MB <Seagate ST3250310AS 3.AAF> at ata2-master SATA150

1. shared_buffers miktarını arttırın;

2. effective_cache_size miktarını arttırın;

3. VACUUM işlemini sıklıkla yapın;

***autovacuum işlemi;

4.ANALYZE işlemini sıklıkla yapın;

5. VACUUM FULL komutunu çok sık çalıştırmayın;

6. WAL dosyalarını fiziksel olarak ayrı diske taşıyın;

7. sort_mem değerini arttırın;

8. random_page_cost değerini düşürün;

9.max_fsm_pages ve max_fsm_relations değerlerini arttırın;

10. wal_buffers değerini arttırın;

En Süper WEB Server için 5 Elementin Birleşmesi (FreeBSD 8.0, PHP52, Lighttpd, PostgreSQL ve Ben)

FreeBSD 8.0 Release

PHP52

Lighttpd 1.4.26

PostgreSQL 8.4.4

Ben

FreeBSD 8.0 Kurulumu;

PHP52 Kurulumu;

Lighttpd 1.4.26 Kurulumu;

PostgreSQL 8.4.4 Kurulumu;

3 Adımda FreeBSD Başlangıç Açılışında Script Çalıştırma

1- Scripti Yazalım

2- Çalıştırma Hakkı

3- Çalıştır şunu ey FreeBSD

FreeBSD de Özel Kernel Oluşturma ve Derleme

1. `shared_buffers` miktarını arttırın;

2. `effective_cache_size` miktarını arttırın;

7. `sort_mem` değerini arttırın;

8. `random_page_cost` değerini düşürün;

9.`max_fsm_pages` ve `max_fsm_relations` değerlerini arttırın;