icon Get the most out of Surmunity, read our tips here! Need an interesting blog to read? You've got to read the Surpass Blog! | Welcome! Please register to access all of our features.

» Surpass Web Hosting Forums » Discussions » Private Hosting » Server load --- nedd help

Private Hosting Questions about VPS, dedicated servers and colocation.

Closed Thread
 
LinkBack Thread Tools Search this Thread
Old September 17th, 2004, 4:27 AM   #10 (permalink)
Surpass Fan
Seasoned Poster
 
mvital's Avatar
 
Joined in Sep 2003
Lives in LISBON - Portugal
Hosted on VITAL
47 posts
Gave thanks: 1
Thanked 1 Time in 1 Post
ok i will take a look .... thz miakeru
__________________
-----------------------------------------------------------------------
Mário Vital
Design Online WebHosting
Do Host WebHosting
Design Online Templates Cheap Web Templates

server: vital.do-host.com
-----------------------------------------------------------------------
mvital is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old September 17th, 2004, 4:43 AM   #11 (permalink)
Web Hosting Super Ninj4
Super #1
 
miakeru's Avatar
 
Joined in Sep 2003
Lives in Fullerton, CA
1,581 posts
Gave thanks: 0
Thanked 2 times
Quote:
Originally Posted by mvital
ok i will take a look .... thz miakeru
Let me know how it goes.
miakeru is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old September 17th, 2004, 9:56 AM   #12 (permalink)
Surpass Fan
Seasoned Poster
 
mvital's Avatar
 
Joined in Sep 2003
Lives in LISBON - Portugal
Hosted on VITAL
47 posts
Gave thanks: 1
Thanked 1 Time in 1 Post
it cames again today ....

Quote:
Top Process %CPU 61.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/vital.do-host.com.pid --skip-locking --port3306 --socket/tmp/mysql.sock
Top Process %CPU 60.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/vital.do-host.com.pid --skip-locking --port3306 --socket/tmp/mysql.sock
Top Process %CPU 59.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/vital.do-host.com.pid --skip-locking --port3306 --socket/tmp/mysql.sock
i do the following
enter via ssh and go to

/var/lib/mysql/vital.do-host.com.pid ( process id is save at this file )

and do a kill to the process ... for now it works ,this process its not running ,but still dont know from this came ...

Any clue will welcome ..
__________________
-----------------------------------------------------------------------
Mário Vital
Design Online WebHosting
Do Host WebHosting
Design Online Templates Cheap Web Templates

server: vital.do-host.com
-----------------------------------------------------------------------
mvital is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old September 17th, 2004, 10:00 AM   #13 (permalink)
minor deity
Super #1
 
Bigjohn's Avatar
 
Joined in Apr 2004
Lives in Georgia
Hosted on XEON
7,338 posts
Gave thanks: 23
Thanked 93 times
did you install the program that mike recommended? mysqladmin?
__________________
Proud to be a Surmunity Mod!
XEON PASS60 PASS61
Make a fundamental difference!
My Sites:
Curious about Brewing Beer? Join the community!
>>>>> Some Change is GOOD! Keep your paycheck! Support the Fair Tax
Get into an Art museum
Victorian London
It's your brain -ON WEB - mybrainhost.com (under development)
What SHOULD Government do? Much Less than it Does!
Bigjohn is online now  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old September 17th, 2004, 1:10 PM   #14 (permalink)
Web Hosting Super Ninj4
Super #1
 
miakeru's Avatar
 
Joined in Sep 2003
Lives in Fullerton, CA
1,581 posts
Gave thanks: 0
Thanked 2 times
Quote:
Originally Posted by mvital
it cames again today ....



i do the following
enter via ssh and go to

/var/lib/mysql/vital.do-host.com.pid ( process id is save at this file )

and do a kill to the process ... for now it works ,this process its not running ,but still dont know from this came ...

Any clue will welcome ..
You really should give MySQLAdmin a shot. It will tell you where all of the connections are coming from, and allow you to see what's using the most of them. Once you've figured that out, you can tweak the script that's overloading it and calm the server down.

Just out of curiosity, how much memory does your system have, and what percentage is being used?
miakeru is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old September 18th, 2004, 5:21 AM   #15 (permalink)
Surpass Fan
Seasoned Poster
 
mvital's Avatar
 
Joined in Sep 2003
Lives in LISBON - Portugal
Hosted on VITAL
47 posts
Gave thanks: 1
Thanked 1 Time in 1 Post
no i dont install mysqladmin but i will try today to see where those connections are coming from.
Memory -> ( 512Mb)

This is where that process comes up my system status start at
Quote:
Server Load 1.61 (1 cpu) sometimes goes to 5.68 hrrrggg
Memory Used 86.4 %
after install mySqlAdmin i say something to u guys ...
Thz to all
__________________
-----------------------------------------------------------------------
Mário Vital
Design Online WebHosting
Do Host WebHosting
Design Online Templates Cheap Web Templates

server: vital.do-host.com
-----------------------------------------------------------------------
mvital is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old September 18th, 2004, 5:27 AM   #16 (permalink)
Surpass Fan
Seasoned Poster
 
mvital's Avatar
 
Joined in Sep 2003
Lives in LISBON - Portugal
Hosted on VITAL
47 posts
Gave thanks: 1
Thanked 1 Time in 1 Post
start again ...

Quote:
mysql 4.92 13.49 0.0
Top Process %CPU 61.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/vital.do-host.com.pid --skip-locking --port3306 --socket/tmp/mysql.sock
Top Process %CPU 59.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/vital.do-host.com.pid --skip-locking --port3306 --socket/tmp/mysql.sock
Top Process %CPU 58.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/vital.do-host.com.pid --skip-locking --port3306 --socket/tmp/mysql.sock
where can find mysqladmin ...
thz again
__________________
-----------------------------------------------------------------------
Mário Vital
Design Online WebHosting
Do Host WebHosting
Design Online Templates Cheap Web Templates

server: vital.do-host.com
-----------------------------------------------------------------------
mvital is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old September 18th, 2004, 5:30 AM   #17 (permalink)
Surpass Fan
Seasoned Poster
 
mvital's Avatar
 
Joined in Sep 2003
Lives in LISBON - Portugal
Hosted on VITAL
47 posts
Gave thanks: 1
Thanked 1 Time in 1 Post
found and intalled mysqladmin ... some help with the comands prompt !!
__________________
-----------------------------------------------------------------------
Mário Vital
Design Online WebHosting
Do Host WebHosting
Design Online Templates Cheap Web Templates

server: vital.do-host.com
-----------------------------------------------------------------------
mvital is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old September 18th, 2004, 5:34 AM   #18 (permalink)
Surpass Fan
Seasoned Poster
 
mvital's Avatar
 
Joined in Sep 2003
Lives in LISBON - Portugal
Hosted on VITAL
47 posts
Gave thanks: 1
Thanked 1 Time in 1 Post
Quote:
mysqladmin processlist
+-------+-----------+-----------+-----------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+-----------+-----------+-----------+---------+------+-------+------------------+
| 651 | eximstats | localhost | eximstats | Sleep | 122 | | |
| 66091 | pnsm_pnsm | localhost | pnsm_pnsm | Sleep | 5 | | |
| 66094 | root | localhost | | Query | 0 | | show processlist |
+-------+-----------+-----------+-----------+---------+------+-------+------------------+
here is the process list ... any clue ???
__________________
-----------------------------------------------------------------------
Mário Vital
Design Online WebHosting
Do Host WebHosting
Design Online Templates Cheap Web Templates

server: vital.do-host.com
-----------------------------------------------------------------------
mvital is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On