Results 1 to 15 of 15
  1. #1
    Join Date
    Feb 2003
    Location
    Taiwan
    Posts
    1,267

    How to lower high server load

    When i check the server status is shows a high server load.
    How do I lower the server load? it looks like for mysql activity.
    Toeki Enterprises Co. (Accredited .WS & CentralNIC Registrar)
    We accept PayPal, MoneyBookers, Credit Card, Bank Transfers and Western Union. [AWBS Reseller]
    █Domain Registration http://www.toeki.net / http://www.dots.ws

  2. #2
    Join Date
    May 2007
    Location
    Hiding under your bed
    Posts
    1,275
    Look at the cou processes and see which one(s) is/are the most demanding
    Cheapest Multiple C Class IP Hosting

  3. #3
    Join Date
    Feb 2003
    Location
    Taiwan
    Posts
    1,267
    mailnull uses 3.26 cpu
    Toeki Enterprises Co. (Accredited .WS & CentralNIC Registrar)
    We accept PayPal, MoneyBookers, Credit Card, Bank Transfers and Western Union. [AWBS Reseller]
    █Domain Registration http://www.toeki.net / http://www.dots.ws

  4. #4
    Join Date
    Aug 2006
    Location
    Regina, Saskatchewan, CA
    Posts
    221
    An immediate fix would be to kill the process that's taking up so much CPU though you would probably want to investigate as to why that process is so much of a resource hog before you do.
    Bill - Support Analyst - Liveblock Auctions International
    http://www.LiveGlobalBid.com

  5. #5
    Join Date
    Feb 2003
    Location
    Taiwan
    Posts
    1,267
    so mailnul is not important? I don't really know what that is.
    Toeki Enterprises Co. (Accredited .WS & CentralNIC Registrar)
    We accept PayPal, MoneyBookers, Credit Card, Bank Transfers and Western Union. [AWBS Reseller]
    █Domain Registration http://www.toeki.net / http://www.dots.ws

  6. #6
    Join Date
    Aug 2006
    Location
    Regina, Saskatchewan, CA
    Posts
    221
    I'm not saying it's not important. It seems to be an anti-spam application of some kind. If that's the case, it's probably worth keeping alive.
    Bill - Support Analyst - Liveblock Auctions International
    http://www.LiveGlobalBid.com

  7. #7
    Join Date
    Feb 2003
    Location
    Taiwan
    Posts
    1,267
    actually its the mysql
    mysql 58.78cpu
    Toeki Enterprises Co. (Accredited .WS & CentralNIC Registrar)
    We accept PayPal, MoneyBookers, Credit Card, Bank Transfers and Western Union. [AWBS Reseller]
    █Domain Registration http://www.toeki.net / http://www.dots.ws

  8. #8
    Join Date
    Jan 2008
    Location
    Sweden
    Posts
    169
    Tweak the mysql config, for mysql 4 it's called my.cnf I forgot the new file(s)
    Try lowering values and change/disable some options that you don't need.
    SwedenDedicated Unmanaged & managed solutions.
    Dedicated Servers, VPS and colocation in Sweden - Stockholm.
    100Mbit Unmetered servers
    Follow us on twitter @swedendedicated

  9. #9
    Join Date
    Sep 2005
    Location
    Canada
    Posts
    645
    Disable InnoDB (in my.conf) if you don't need it, and convert existing tables to MyISAM. That will probably improve performance hugely.
    VPSVille.com
    Toronto, London, Dallas, Los Angeles
    Quality VPS hosting on Premium bandwidth

  10. #10
    Join Date
    Feb 2003
    Location
    Taiwan
    Posts
    1,267
    Is this hard to do?
    How much would it cost for somebody to do this?
    Toeki Enterprises Co. (Accredited .WS & CentralNIC Registrar)
    We accept PayPal, MoneyBookers, Credit Card, Bank Transfers and Western Union. [AWBS Reseller]
    █Domain Registration http://www.toeki.net / http://www.dots.ws

  11. #11
    Join Date
    Jan 2008
    Location
    Sweden
    Posts
    169
    Quote Originally Posted by Toeki View Post
    Is this hard to do?
    How much would it cost for somebody to do this?
    InnoDB can be disabled in the config, it's just changing 1 line. To convert your tables to MyISAM: http://www.red91.com/articles/2007/1...-innodb-myisam
    Also take a look at: http://en.wikipedia.org/wiki/InnoDB
    SwedenDedicated Unmanaged & managed solutions.
    Dedicated Servers, VPS and colocation in Sweden - Stockholm.
    100Mbit Unmetered servers
    Follow us on twitter @swedendedicated

  12. #12
    Join Date
    Sep 2005
    Location
    Canada
    Posts
    645
    Quote Originally Posted by Toeki View Post
    Is this hard to do?
    How much would it cost for somebody to do this?
    For working with MySQL I recommend Navicat, its excellent software.

    You can covert table types with it and browse the database beautifully.

    Innodb can be disabled by uncommenting 'skip-innodb' in the config file.
    VPSVille.com
    Toronto, London, Dallas, Los Angeles
    Quality VPS hosting on Premium bandwidth

  13. #13
    Join Date
    Oct 2005
    Posts
    289
    check which apps are demanding via 'top'
    also, check the output of 'iostat' and 'vmstat', perhaps most load is generated by io-wait from io-bound processes. Insufficient memory can introduce swapping which may start increasing your load.

    so check you processes, check which resource is lacking (memory, cpu, sockets, etc.). check your logs for clues (e.g. /var/log/messages, errorlogs, etc)

    Cheers!

  14. #14
    Join Date
    Jan 2006
    Location
    Morocco
    Posts
    73
    wich version of mysql use ?

    i had the same error before . resolved with upgrading to mysql 5 .
    From The

  15. #15
    Join Date
    Jul 2003
    Location
    Olean, NY
    Posts
    143
    I would recommend killing apache and mysql to reduce server load.

    My apologies, I woke up in sarcasm mode today. Seriously, if you think mysql is a large part of your problem, log into mysql and run SHOW PROCESSES; a few times to see what pages are running long queries. Also consider enabling the slow query log from there. You'll be able to see if maybe a few customers have seriously unoptimized code.

    After you do that and similiar steps for your other subsystems and you still have a problem it is time to consider adding a new server or upgrading your hardware.

    Cheers,
    Erek
    System administration, application development, and project management.
    http://erek.blumenthals.com/blog/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •