The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

High Load ? And Something wrong

Discussion in 'General Discussion' started by Zi5, Oct 5, 2007.

  1. Zi5

    Zi5 BANNED

    Joined:
    Oct 5, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    Hello ,
    I have 2 servers
    Dual Quad Core 5310
    One for Mysql and the other one for Httpd
    I have one large website , when i put this website in one server i mean by one server is making the website work with mysql and httpd in one server no external server it's load seems to be on 1 - 5 but when i but the mysql on other server the load got high and i got high httpd connections , also when i try to see the the amount connections between the servers it's too high in one of them and low in the other and i am always suffering from load .
    here the details
    192.168.0.1 the mysql server
    192.168.0.2 httpd server

    [root@httpd etc]# netstat -n | grep 192.168 | wc -l
    453



    this the mysql server my.cnf conf
    [root@mysql ~]# cat /etc/my.cnf
    [mysqld]
    safe-show-database
    skip-name-resolve
    skip-innodb
    max_connections = 800
    key_buffer = 96M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 2500
    thread_cache_size = 384
    wait_timeout = 30
    connect_timeout = 10
    tmp_table_size = 128M
    max_heap_table_size = 128M
    max_allowed_packet = 64M
    max_connect_errors = 10
    thread_concurrency = 8
    read_rnd_buffer_size = 1M
    bulk_insert_buffer_size = 8M
    query_cache_limit = 8M
    query_cache_size = 128M
    query_cache_type = 1
    query_prealloc_size = 131072
    query_alloc_block_size = 65536

    [mysqld_safe]
    nice = -10
    open_files_limit = 8192

    [mysqldump]
    quick
    max_allowed_packet = 16M

    [myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M

    [mysqlhotcopy]
    interactive-timeout

    [root@mysql ~]#

    this the httpd.conf config
    Timeout 30
    KeepAlive On
    MaxKeepAliveRequests 120
    KeepAliveTimeout 1
    MinSpareServers 15
    MaxSpareServers 25
    StartServers 15
    MaxClients 256
    MaxRequestsPerChild 1000


    here the total connections in the mysql server
    [root@mysql ~]# netstat -n | grep 192.168 | wc -l
    25
    [root@mysql ~]#

    [root@mysql ~]# netstat -n | grep 192.168
    tcp 0 0 192.168.0.1:3306 192.168.0.2:47876 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:48923 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:46610 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:47142 TIME_WAIT
    tcp 0 0 192.168.0.1:3306 192.168.0.2:49209 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:44344 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:44365 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:44359 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:46406 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:44355 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:44352 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:48217 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:47208 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:46463 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:47229 TIME_WAIT
    tcp 0 0 192.168.0.1:3306 192.168.0.2:46459 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:47987 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:46469 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:42371 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:47259 TIME_WAIT
    tcp 0 0 192.168.0.1:3306 192.168.0.2:47252 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:46480 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:47275 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:47293 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:47291 TIME_WAIT
    tcp 0 0 192.168.0.1:3306 192.168.0.2:47311 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:47304 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:47303 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:46530 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:49089 ESTABLISHED
    tcp 0 100740 192.168.0.1:3306 192.168.0.2:47318 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:47315 ESTABLISHED
    tcp 0 0 192.168.0.1:3306 192.168.0.2:47312 ESTABLISHED
    [root@mysql ~]#

    Do you see the high different number between connections !!
    I am sorry for bad english but i am really get more pain daily with the high load
    My server kernel
    Linux httpd 2.6.18-8.1.8.el5 #1 SMP Tue Jul 10 06:50:22 EDT 2007 i686 i686 i386 GNU/Linux
    I use CentOS 5 and httpd 1.3 and php 4.4.7
    I try to upgrade them to httpd 2.0 and php 5.2.4 but most users can't browse the site so i come back to 1.3
    Thanks ,
    Zi5
    ايفونTrip نوكيا بوابة نوكيا Trip ايفون
     
    #1 Zi5, Oct 5, 2007
    Last edited: Sep 16, 2009
  2. Zi5

    Zi5 BANNED

    Joined:
    Oct 5, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    [root@httpd etc]#netstat -n | grep 192.168
    tcp 0 0 192.168.0.2:44355 192.168.0.1:3306 ESTABLISHED
    tcp 0 0 192.168.0.2:44359 192.168.0.1:3306 ESTABLISHED
    tcp 0 0 192.168.0.2:44344 192.168.0.1:3306 ESTABLISHED
    tcp 0 0 192.168.0.2:42371 192.168.0.1:3306 ESTABLISHED
    tcp 0 0 192.168.0.2:47252 192.168.0.1:3306 ESTABLISHED
    tcp 0 0 192.168.0.2:47987 192.168.0.1:3306 ESTABLISHED
    tcp 0 0 192.168.0.2:47876 192.168.0.1:3306 ESTABLISHED
    tcp 0 0 192.168.0.2:48217 192.168.0.1:3306 ESTABLISHED
    tcp 0 0 192.168.0.2:48923 192.168.0.1:3306 ESTABLISHED
    tcp 0 0 192.168.0.2:49089 192.168.0.1:3306 ESTABLISHED
    tcp 0 0 192.168.0.2:46416 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46417 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46418 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46419 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46420 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46421 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46422 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46423 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46424 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46425 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46426 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46427 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46428 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46429 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46430 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46431 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46400 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46401 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46402 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46403 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46404 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46405 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46406 192.168.0.1:3306 ESTABLISHED
    tcp 0 0 192.168.0.2:46407 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46408 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46409 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46410 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46411 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46412 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46413 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46414 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46415 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46448 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46449 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46450 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46451 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46452 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46453 192.168.0.1:3306 TIME_WAIT
    tcp 0 0 192.168.0.2:46454 192.168.0.1:3306 TIME_WAIT
    [root@httpd etc]#

    I remove a lot of them because of cpanel forums rules no more then 10000 characters

    نوكيا بوابة نوكيا Trip ايفون
     
    #2 Zi5, Oct 5, 2007
    Last edited: Sep 16, 2009
  3. Zi5

    Zi5 BANNED

    Joined:
    Oct 5, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
  4. sarhosting

    sarhosting Well-Known Member

    Joined:
    Oct 1, 2007
    Messages:
    164
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    United States
    cPanel Access Level:
    Root Administrator
    Twitter:
    Is your script closing connections to the database or leaving them open?
     
  5. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    To learn more about the causes of CPU load, go to: http://servertune.com/kbase/entry/67/
     
  6. Zi5

    Zi5 BANNED

    Joined:
    Oct 5, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    I use Only vBulletin Script in my site .


    ServerTune
    Thanks too much for the Document
     
  7. Zi5

    Zi5 BANNED

    Joined:
    Oct 5, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
  8. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,470
    Likes Received:
    198
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:

    There's a Server Configuration forum setup over at VB that might be useful.

    http://www.vbulletin.com/forum/forumdisplay.php?f=14

    Why would you need two servers for one forum anyway? I'm unclear about that. Is it that large of a forum?
     
  9. encryption

    encryption Well-Known Member

    Joined:
    Jun 24, 2005
    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    6

    Yep, a dual server setup (one for the webserver and the other for MySQL) greatly helps performance. Forums with over 600 simultaneous users online (having a cookie timeout of 900 and less) will greatly benefit with a Dual server setup.
     
  10. markfrompf

    markfrompf Well-Known Member

    Joined:
    Mar 27, 2006
    Messages:
    176
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Los Angeles, CA
    Very interesting and true. May I ask the URL of your forum?
     
  11. Zi5

    Zi5 BANNED

    Joined:
    Oct 5, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    Infopro
    I use there config that they give it me .

    encryption
    With my problem nothing differnet i think there are a wrong between my servers

    markfrompf
    I am sorry I can't provide my forum link now .


    Still looking for help
     
Loading...

Share This Page