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 18th, 2004, 11:23 AM   #19 (permalink)
minor deity
Super #1
 
Bigjohn's Avatar
 
Joined in Apr 2004
Lives in Georgia
Hosted on XEON
7,394 posts
Gave thanks: 28
Thanked 94 times
ok.

when your memory gets that full, the CPU will spike because it's swapping "virtual memory" on the hard disk.

Let us know what you find from the mysqladmin program!

John
__________________
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 offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old September 18th, 2004, 1:03 PM   #20 (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
in my last thread its the result of MySQLAdmin , everthing looks allright
Quote:
+-------+-----------+-----------+-----------+---------+------+-------+------------------+
| 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 |
+-------+-----------+-----------+-----------+---------+------+-------+------------------+
any other sugestions ?
__________________
-----------------------------------------------------------------------
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, 1:53 PM   #21 (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 Bigjohn
ok.

when your memory gets that full, the CPU will spike because it's swapping "virtual memory" on the hard disk.

Let us know what you find from the mysqladmin program!

John
Ditto. Looks like low memory may be your problem.
miakeru is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old September 20th, 2004, 1:38 PM   #22 (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
here´s some report

Quote:
root[at]vital [/var/lib/mysql]# mysqladmin processlist
+----+-----------+-----------+-----------+---------+------+--------------+------
--------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info
|
+----+-----------+-----------+-----------+---------+------+--------------+------
--------------------------------------------+
| 17 | pnsm_pnsm | localhost | pnsm_pnsm | Sleep | 0 | |
|
| 20 | pnsm_pnsm | localhost | pnsm_pnsm | Sleep | 0 | |
|
| 23 | pnsm_pnsm | localhost | pnsm_pnsm | Query | 0 | Sending data | selec
t * from phpbb_users where username ='Miau' |
| 30 | root | localhost | | Query | 0 | | show
processlist |
+----+-----------+-----------+-----------+---------+------+--------------+------
--------------------------------------------+

root[at]vital [/var/lib/mysql]# mysqladmin status
Uptime: 45 Threads: 2 Questions: 1339 Slow queries: 0 Opens: 54 Flush table
s: 1 Open tables: 48 Queries per second avg: 29.756
root[at]vital [/var/lib/mysql]#
server status

Quote:
Server Load 1.82 (1 cpu)
Memory Used 44.9 %
processes

Quote:
mysql 11.97 26.13 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
pnsm portugalnoseumelhor.com 9.50 19.97 0.9
Top Process %CPU 13.5 httpd [www.portugalnoseumelhor.com] [/index.php?id833&vote9]
Top Process %CPU 8.6 httpd [www.portugalnoseumelhor.com] [/index.php?id833&vote9]
Top Process %CPU 7.5 httpd [www.portugalnoseumelhor.com] [/?r1&showpic2639]
root 2.78 1.77 2.0
Top Process %CPU 78.0 gzip
Top Process %CPU 77.5 gzip
Top Process %CPU 71.6 gzip

dont found nothing anormal !!
maybe should pass this to support !! any clue for this ??
__________________
-----------------------------------------------------------------------
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