Server load --- nedd help - Page 2

**mvital** · September 17th, 2004, 4:27 AM

ok i will take a look .... thz miakeru

**miakeru** · September 17th, 2004, 4:43 AM

Quote:

Originally Posted by mvital

ok i will take a look .... thz miakeru

Let me know how it goes.

**mvital** · September 17th, 2004, 9:56 AM

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 ..

**Bigjohn** · September 17th, 2004, 10:00 AM

did you install the program that mike recommended? mysqladmin?

**miakeru** · September 17th, 2004, 1:10 PM

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?

**mvital** · September 18th, 2004, 5:21 AM

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

**mvital** · September 18th, 2004, 5:27 AM

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

**mvital** · September 18th, 2004, 5:30 AM

found and intalled mysqladmin ... some help with the comands prompt !!

**mvital** · September 18th, 2004, 5:34 AM

Quote:

here is the process list ... any clue ???

September 17th, 2004, 4:27 AM	#10 (permalink)
mvital Surpass Fan Seasoned Poster 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 -----------------------------------------------------------------------

September 17th, 2004, 10:00 AM	#13 (permalink)
Bigjohn minor deity Super #1 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!

September 18th, 2004, 5:30 AM	#17 (permalink)
mvital Surpass Fan Seasoned Poster 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 -----------------------------------------------------------------------

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

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