#1  
Old 21st October 2009, 18:17
mqrd2000 mqrd2000 is offline
Junior Member
 
Join Date: Oct 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy Server Hight CPU load

Hello everybody

i am using a linux server 12 Gb Ram intel i7 720 8 core i am currently encoutring a problem of CPU load caused by Mysql i think.

the server recieve same times more then 2500 simultaneous user

an exemple of running process :

CPU load averages: 5.50 (1 mins) , 19.47 (5 mins) , 18.08 (15 mins)
CPU type: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz , 8 cores

ID Owner CPU Command
20472 mysql 140 % /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-f ...
9106 apache 6.0 % /usr/sbin/httpd
9090 apache 4.0 % /usr/sbin/httpd
9100 apache 4.0 % /usr/sbin/httpd
9103 apache 3.5 % /usr/sbin/httpd
9081 apache 3.1 % /usr/sbin/httpd
9097 apache 3.0 % /usr/sbin/httpd
9102 apache 3.0 % /usr/sbin/httpd
9111 apache 3.0 % /usr/sbin/httpd
9080 apache 2.7 % /usr/sbin/httpd
9088 apache 2.6 % /usr/sbin/httpd
9105 apache 2.5 % /usr/sbin/httpd
9093 apache 2.3 % /usr/sbin/httpd
...


any help or suggestion or advice will be grateful
Reply With Quote
Sponsored Links
  #2  
Old 22nd October 2009, 17:51
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

You can try to optimize MySQL and Apache:
http://dev.mysql.com/doc/refman/5.0/...arameters.html
http://www.howtoforge.com/configurin...um_performance
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 22nd October 2009, 19:27
mqrd2000 mqrd2000 is offline
Junior Member
 
Join Date: Oct 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Thank you very much i solved the problem using same exemples of my.cnf found in mysql website
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
User unknown in relay recipient table Taxick Installation/Configuration 12 9th April 2013 12:31
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 10:49
FTP cannot open remote folder!?! andysm849 Server Operation 23 16th October 2008 23:34
Rejecting outbound mail tristanlee85 General 11 20th May 2007 17:04
server blocked/stopped by host Ovidiu Technical 11 14th February 2006 10:50


All times are GMT +2. The time now is 13:56.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.