server load up, need help with mysql

smith
  • During the day time, our server load goes up, frequently between 2 and 3, and occasionally spikes as high as 5. In WHM, it shows mysql using the majority of the memory. We were told by tech that mysql is the cause of the load problem, so now we'd like some help getting it under control. Thanks :)

    Dedicated server:
    cpu : P4 1.7 ghz
    ram: 1GB
    60GB EIDE non raid
    redhat linux 7.3
    apache 1.3.27
    php 4.3.1
    mysql 4.0.13

    3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
    I don't know what that is, so I'll assume no.
    5. your top stats
    6. your mysql configuration variables
    I have two installations of my.cnf on the server.
    One is in the WHM directory and a copy is here:
    http://www.redboxweb.com/mycnf.txt
    The other is in /etc/ and a copy is here:
    http://www.redboxweb.com/mycnf2.txt
    Btw, the one just above is the one I edited a few months ago based on another post I made, but ram usage went up after the change and things never did improve.
    7. your mysql extended-status
    http://www.redboxweb.com/mysqlinfo.php
    8. oh and is your vB the only thing on the server? or other scripts? sites?
    This is the only website in use. I do have a cookbook script installed which uses mysql, as well as a reviews script (incursio) that also uses mysql. I recently installed pmachine, which is a mysql blog.
    9. how many average and max concurrent users on your vB forum ?
    between 60 and 80 at peak periods, about 30 to 40 the rest of the time.
    10. phpinfo.php
    http://www.redboxweb.com/phpinfo.php

    11. httpd.conf
    KeepAlive ON
    MaxKeepAliveRequests 100
    KeepAliveTimeout 15
    MinSpareServers 5
    MaxSpareServers 10
    StartServers 5
    MaxClients 160

    12. what version of vB are you running ?
    2.9


  • Thanks, have updated all. I got excited because it did reduce everything for a while, but now that traffic is on the site, the load is rising. It's fluctuating a lot, from just under 1, to well over 3.


  • During the day time, our server load goes up, frequently between 2 and 3, and occasionally spikes as high as 5. In WHM, it shows mysql using the majority of the memory. We were told by tech that mysql is the cause of the load problem, so now we'd like some help getting it under control. Thanks :)

    Dedicated server:
    cpu : P4 1.7 ghz
    ram: 1GB
    60GB EIDE non raid
    redhat linux 7.3
    apache 1.3.27
    php 4.3.1
    mysql 4.0.13

    3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
    I don't know what that is, so I'll assume no.
    5. your top stats
    6. your mysql configuration variables
    I have two installations of my.cnf on the server.
    One is in the WHM directory and a copy is here:
    http://www.redboxweb.com/mycnf.txt
    The other is in /etc/ and a copy is here:
    http://www.redboxweb.com/mycnf2.txt
    Btw, the one just above is the one I edited a few months ago based on another post I made, but ram usage went up after the change and things never did improve.
    7. your mysql extended-status
    http://www.redboxweb.com/mysqlinfo.php
    8. oh and is your vB the only thing on the server? or other scripts? sites?
    This is the only website in use. I do have a cookbook script installed which uses mysql, as well as a reviews script (incursio) that also uses mysql. I recently installed pmachine, which is a mysql blog.
    9. how many average and max concurrent users on your vB forum ?
    between 60 and 80 at peak periods, about 30 to 40 the rest of the time.
    10. phpinfo.php
    http://www.redboxweb.com/phpinfo.php

    11. httpd.conf
    KeepAlive ON
    MaxKeepAliveRequests 100
    KeepAliveTimeout 15
    MinSpareServers 5
    MaxSpareServers 10
    StartServers 5
    MaxClients 160

    12. what version of vB are you running ?
    2.9
    that's 2.29 and not 2.9 vB version right ? :)


    right now

    1. change your /etc/my.cnf contents and place this in it and restart mysql


    [client]
    port = 3306
    socket = /var/lib/mysql/mysql.sock

    [mysqld]
    port = 3306
    socket = /var/lib/mysql/mysql.sock
    skip-locking
    max_connections = 450
    key_buffer = 32M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 1024
    thread_cache_size = 64
    wait_timeout = 2400
    connect_timeout = 10
    max_allowed_packet = 16M
    max_connect_errors = 10
    query_cache_limit = 1M
    query_cache_size = 32M
    query_cache_type = 1
    skip-innodb

    [mysqld_safe]
    open_files_limit = 8192

    [mysqldump]
    quick
    max_allowed_packet = 16M

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


    2. in WHM try and go to service manager and disable Melange chat, and Interchange services

    3. also dif you change maxclients to 160 in httpd.conf or was it already there ? if it was already there and you didn't change it, try changing httpd.conf maxclients from 160 to 200 and restart apache - could be cpanel catching you hitting your maxclients and automatically altering your httpd.conf







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about server load up, need help with mysql , Please add it free.


    • edit
    [SOLVED] Problem with CardLayout and FormPanel
    Paging & Proxy