Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    51
    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 ايفون
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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:
    51
    [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 ايفون
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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:
    51
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 Zi5, Oct 7, 2007
    Last edited: Sep 25, 2009
  4. sarhosting

    sarhosting Well-Known Member

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

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    4
    Trophy Points:
    193
    Location:
    Minneapolis, MN
    To learn more about the causes of CPU load, go to: http://servertune.com/kbase/entry/67/
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. Zi5

    Zi5 BANNED

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


    ServerTune
    Thanks too much for the Document
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. Zi5

    Zi5 BANNED

    Joined:
    Oct 5, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    51
    I am still watting help :(
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,518
    Likes Received:
    425
    Trophy Points:
    583
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. encryption

    encryption Well-Known Member

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

    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:
    166
    Location:
    Los Angeles, CA
    Very interesting and true. May I ask the URL of your forum?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  11. Zi5

    Zi5 BANNED

    Joined:
    Oct 5, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    51
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice