• 21-03-2007, 10:52:35
    #1
    Üyeliği durduruldu
    makına p4 3.0 1 gb ram centoz direckadmin

    cat /etc/my.cnf

    [root@ipc1 ~]# cat /etc/my.cnf_orig
    [mysqld]
    datadir = /var/lib/mysql
    basedir = /usr/
    port = 3306
    wait_timeout = 15
    socket = /var/lib/mysql/mysql.sock
    skip-locking
    skip-innodb
    max_connections = 500
    key_buffer = 16M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 1800
    thread_cache_size = 384
    wait_timeout = 60
    connect_timeout = 30
    tmp_table_size = 64M
    max_allowed_packet = 64M
    max_connect_errors = 10
    query_cache_limit = 2M
    query_cache_size = 64M
    query_cache_type = 1
    query_prealloc_size = 16384
    query_alloc_block_size = 16384

    [mysqld_safe]
    open_files_limit = 8192

    [mysqldump]
    quick
    max_allowed_packet = 16M

    [myisamchk]
    key_buffer = 256M
    sort_buffer = 256M
    read_buffer = 2M
    write_buffer = 2m

    [mysqlhotcopy]
    interactive-timeout
    [root@ipc1 ~]#



    [root@ipc1 ~]# uname -a
    Linux ipc1.ipcare.nl 2.6.9-34.ELsmp #1 SMP Wed Mar 8 00:27:03 CST 2006 i686 i686 i386 GNU/Linux
    [root@ipc1 ~]#


    [root@ipc1 ~]# ulimit -aH
    core file size (blocks, -c) unlimited
    data seg size (kbytes, -d) unlimited
    file size (blocks, -f) unlimited
    pending signals (-i) 1024
    max locked memory (kbytes, -l) 32
    max memory size (kbytes, -m) unlimited
    open files (-n) 1024
    pipe size (512 bytes, -p) 8
    POSIX message queues (bytes, -q) 819200
    stack size (kbytes, -s) unlimited
    cpu time (seconds, -t) unlimited
    max user processes (-u) 16379
    virtual memory (kbytes, -v) unlimited
    file locks (-x) unlimited
    [root@ipc1 ~]#


    top - 09:49:34 up 1 day, 8:56, 1 user, load average: 4.59, 4.69, 3.00
    Tasks: 134 total, 2 running, 132 sleeping, 0 stopped, 0 zombie
    Cpu(s): 30.8% us, 9.9% sy, 0.0% ni, 10.5% id, 44.4% wa, 4.4% hi, 0.0% si
    Mem: 1034332k total, 553712k used, 480620k free, 1736k buffers
    Swap: 1048568k total, 21724k used, 1026844k free, 44144k cached

    PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
    24481 apache 16 0 33268 15m 4448 R 14 1.6 0:09.24 httpd
    24483 apache 15 0 33916 17m 4460 S 9 1.7 0:10.37 httpd
    29708 mysql 18 0 39332 15m 1620 D 9 1.5 0:00.31 mysqld
    22071 apache 16 0 31488 14m 4460 S 8 1.5 0:05.98 httpd
    29710 mysql 18 0 39332 15m 1620 S 7 1.5 0:00.22 mysqld
    18972 apache 15 0 34160 17m 4476 S 6 1.7 0:18.76 httpd
    26709 apache 16 0 31212 14m 4448 S 5 1.4 0:01.71 httpd
    22072 apache 15 0 32720 16m 4456 S 2 1.6 0:09.53 httpd
    21403 apache 15 0 31448 14m 4548 S 2 1.5 0:18.23 httpd
    19300 apache 15 0 34020 17m 4460 S 1 1.7 0:16.00 httpd
    14717 dovecot 16 0 4692 1108 1056 S 1 0.1 0:02.83 imap-login
    15112 named 16 0 48004 2076 1612 S 1 0.2 0:03.41 named
    18725 apache 15 0 32352 15m 4452 S 1 1.5 0:21.86 httpd
    19714 apache 15 0 32108 15m 4564 S 1 1.5 0:14.52 httpd
    25525 apache 16 0 30832 14m 4448 S 1 1.4 0:04.26 httpd
    21399 apache 15 0 31336 14m 4452 S 0 1.4 0:18.06 httpd
    24479 apache 15 0 34052 17m 4552 S 0 1.7 0:09.78 httpd



    [root@ipc1 ~]# cat /proc/cpuinfo
    processor : 0
    vendor_id : GenuineIntel
    cpu family : 15
    model : 4
    model name : Intel(R) Pentium(R) 4 CPU 3.00GHz
    stepping : 9
    cpu MHz : 3002.341
    cache size : 1024 KB
    physical id : 0
    siblings : 2
    core id : 0
    cpu cores : 1
    fdiv_bug : no
    hlt_bug : no
    f00f_bug : no
    coma_bug : no
    fpu : yes
    fpu_exception : yes
    cpuid level : 5
    wp : yes
    flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe lm pni monitor ds_cpl cid xtpr
    bogomips : 6008.78

    processor : 1
    vendor_id : GenuineIntel
    cpu family : 15
    model : 4
    model name : Intel(R) Pentium(R) 4 CPU 3.00GHz
    stepping : 9
    cpu MHz : 3002.341
    cache size : 1024 KB
    physical id : 0
    siblings : 2
    core id : 0
    cpu cores : 1
    fdiv_bug : no
    hlt_bug : no
    f00f_bug : no
    coma_bug : no
    fpu : yes
    fpu_exception : yes
    cpuid level : 5
    wp : yes
    flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe lm pni monitor ds_cpl cid xtpr
    bogomips : 5999.41

    [root@ipc1 ~]#


    [root@ipc1 ~]# free
    total used free shared buffers cached
    Mem: 1034332 521104 513228 0 2212 53628
    -/+ buffers/cache: 465264 569068
    Swap: 1048568 21724 1026844
    [root@ipc1 ~]#
  • 21-03-2007, 10:54:13
    #2
    Üyeliği durduruldu
    Timeout 60
    KeepAlive On
    MaxKeepAliveRequests 500
    KeepAliveTimeout 3
    MinSpareServers 16
    MaxSpareServers 32
    StartServers 8
    MaxClients 450
    MaxRequestsPerChild 256
  • 21-03-2007, 10:58:12
    #3
    Kurumsal PLUS
    Sana daha önce bir my.cnf vermiştim aynısını kullan gitsin..

    bunlarıda değiştir httpd.conf dan

    Timeout 30
    KeepAlive Off
    MaxKeepAliveRequests 100
    KeepAliveTimeout 5
    MinSpareServers 8
    MaxSpareServers 18
    StartServers 10
    MaxClients 300
    MaxRequestsPerChild 500

    Bir değişim yoksa bu ayarlardan sonra tekrar yaz..
  • 21-03-2007, 22:10:02
    #4
    Üyeliği durduruldu
    bir denıyeyım hocam saol
  • 21-03-2007, 23:42:17
    #5
    Üyeliği durduruldu
    [root@webserver ~]# w
    22:44:10 up 1 day, 4:04, 1 user, load average: 12.56, 12.42, 6.25
    USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
    root pts/0 88.241.41.120 20:43 0.00s 0.13s 0.00s w
    [root@webserver ~]#


    hocam hala yuksek
  • 21-03-2007, 23:44:20
    #6
    sunucuda ne barınıyor ? hitleri nedir ?
  • 21-03-2007, 23:47:29
    #7
    Üyeliği durduruldu
    +1200 vbuleltın forum
  • 21-03-2007, 23:48:56
    #8
    anlık online kullanıcı ne kadar ortalama
  • 22-03-2007, 00:33:23
    #9
    Kurumsal PLUS
    Aman haa makinanı bozar bu!