Results 1 to 15 of 15
Thread: How to lower high server load
-
02-13-2008, 11:10 AM #1Web Hosting Master
- Join Date
- Feb 2003
- Location
- Taiwan
- Posts
- 1,271
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 - a Fikarast Co., Ltd. business (Accredited .WS & CentralNIC Registrar)
█We accept PayPal, Bank Transfers and all crypto currencies (BTC, ETC, LTC ...etc)
█Domain Registration http://www.toeki.net
-
02-13-2008, 11:22 AM #2Internet:Just Piracy No Scurvy
- 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
-
02-13-2008, 11:58 AM #3Web Hosting Master
- Join Date
- Feb 2003
- Location
- Taiwan
- Posts
- 1,271
mailnull uses 3.26 cpu
█Toeki - a Fikarast Co., Ltd. business (Accredited .WS & CentralNIC Registrar)
█We accept PayPal, Bank Transfers and all crypto currencies (BTC, ETC, LTC ...etc)
█Domain Registration http://www.toeki.net
-
02-13-2008, 12:39 PM #4Junior Guru
- 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
-
02-13-2008, 01:27 PM #5Web Hosting Master
- Join Date
- Feb 2003
- Location
- Taiwan
- Posts
- 1,271
so mailnul is not important? I don't really know what that is.
█Toeki - a Fikarast Co., Ltd. business (Accredited .WS & CentralNIC Registrar)
█We accept PayPal, Bank Transfers and all crypto currencies (BTC, ETC, LTC ...etc)
█Domain Registration http://www.toeki.net
-
02-13-2008, 01:35 PM #6Junior Guru
- 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
-
02-13-2008, 02:35 PM #7Web Hosting Master
- Join Date
- Feb 2003
- Location
- Taiwan
- Posts
- 1,271
actually its the mysql
mysql 58.78cpu█Toeki - a Fikarast Co., Ltd. business (Accredited .WS & CentralNIC Registrar)
█We accept PayPal, Bank Transfers and all crypto currencies (BTC, ETC, LTC ...etc)
█Domain Registration http://www.toeki.net
-
02-13-2008, 02:40 PM #8Junior Guru
- Join Date
- Jan 2008
- Location
- Sweden
- Posts
- 182
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 Stockholm, Malmö and Oslo
1000Mbit Unmetered servers
Follow us on twitter @swedendedicated
-
02-13-2008, 04:45 PM #9Web Hosting Master
- Join Date
- Sep 2005
- Location
- Canada
- Posts
- 646
Disable InnoDB (in my.conf) if you don't need it, and convert existing tables to MyISAM. That will probably improve performance hugely.
-
02-14-2008, 02:11 AM #10Web Hosting Master
- Join Date
- Feb 2003
- Location
- Taiwan
- Posts
- 1,271
Is this hard to do?
How much would it cost for somebody to do this?█Toeki - a Fikarast Co., Ltd. business (Accredited .WS & CentralNIC Registrar)
█We accept PayPal, Bank Transfers and all crypto currencies (BTC, ETC, LTC ...etc)
█Domain Registration http://www.toeki.net
-
02-14-2008, 08:01 AM #11Junior Guru
- Join Date
- Jan 2008
- Location
- Sweden
- Posts
- 182
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/InnoDBSwedenDedicated Unmanaged & managed solutions.
Dedicated Servers, VPS and colocation in Stockholm, Malmö and Oslo
1000Mbit Unmetered servers
Follow us on twitter @swedendedicated
-
02-14-2008, 08:04 AM #12Web Hosting Master
- Join Date
- Sep 2005
- Location
- Canada
- Posts
- 646
-
02-14-2008, 12:27 PM #13Web Hosting Guru
- Join Date
- Oct 2005
- Posts
- 292
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!
-
02-18-2008, 09:20 AM #14Junior Guru Wannabe
- Join Date
- Jan 2006
- Location
- Morocco
- Posts
- 74
wich version of mysql use ?
i had the same error before . resolved with upgrading to mysql 5 .From The
-
02-20-2008, 02:15 PM #15WHT Addict
- 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,
ErekSystem administration, application development, and project management.
http://erek.blumenthals.com/blog/