Server load --- nedd help

**mvital** · September 16th, 2004, 8:10 AM

hi ...

last days im having this processes running that causes a high load server , can someone tell me or explain this lines ???

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 57.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 31.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 have no ideia ...

Thz in advanced

**Kayla** · September 16th, 2004, 8:15 AM

What uses MySQL on your website? It is doing a lot of processing.

**mvital** · September 16th, 2004, 10:25 AM

i have several sites using mysql ... but i cant know wich one is doing this

**Rai** · September 16th, 2004, 10:53 AM

But what specifically is connecting to mySQL?

Like forums would be a specific answer.

Knowing these specific answers could help people with experience suggest to you what is causing the high server load. (I personally couldn't help, cause I haven't reached the stage of a dedicated server.

)

**miakeru** · September 16th, 2004, 11:48 AM

Quote:

Originally Posted by Kayla - Admin

What uses MySQL on your website? It is doing a lot of processing.

Wow, yeah.. MySQL is definitely working a tad harder than it usually should.

Like the others have asked: What do you have that using MySQL?

**Kayla** · September 16th, 2004, 11:56 AM

I think he gave me a negative reputation point because I asked the same.

**mvital** · September 16th, 2004, 12:14 PM

i have several Foruns (BBphp, Nuke , and other stuff that uses mySql and PhP ) and some fantastico scripts ( oscommerce, ticket sustem , etc ..)

but i have this for a long time just in the last few days start to happen this

**mvital** · September 16th, 2004, 6:34 PM

any ideias ????

before post to support .... :p

**miakeru** · September 16th, 2004, 6:43 PM

Quote:

Originally Posted by mvital

any ideias ????

before post to support .... :p

Do you have MySQLAdmin installed? If so run: mysqladmin processlist

This will give you a list of connections MySQL is making. It displays where the connections are coming from, and going to. Once you see this list, you'll be able to tell what's using the most amount of connections, and you can go from there.

If you don't have MySQLAdmin installed, install it.

September 16th, 2004, 10:25 AM	#3 (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	i have several sites using mysql ... but i cant know wich one is doing this __________________ ----------------------------------------------------------------------- Mário Vital Design Online WebHosting Do Host WebHosting Design Online Templates Cheap Web Templates server: vital.do-host.com -----------------------------------------------------------------------

September 16th, 2004, 10:53 AM	#4 (permalink)
Rai Senior Member Super #1 Joined in Nov 2003 Lives in Canada Hosted on Pass14 3,763 posts Gave thanks: 4 Thanked 20 times	But what specifically is connecting to mySQL? Like forums would be a specific answer. Knowing these specific answers could help people with experience suggest to you what is causing the high server load. (I personally couldn't help, cause I haven't reached the stage of a dedicated server. ) __________________

September 16th, 2004, 12:14 PM	#7 (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	i have several Foruns (BBphp, Nuke , and other stuff that uses mySql and PhP ) and some fantastico scripts ( oscommerce, ticket sustem , etc ..) but i have this for a long time just in the last few days start to happen this __________________ ----------------------------------------------------------------------- Mário Vital Design Online WebHosting Do Host WebHosting Design Online Templates Cheap Web Templates server: vital.do-host.com -----------------------------------------------------------------------

September 16th, 2004, 6:34 PM	#8 (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	any ideias ???? before post to support .... :p __________________ ----------------------------------------------------------------------- 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

September 16th, 2004, 8:15 AM	#2 (permalink)
Kayla Searcher Surpass Staff Joined in May 2003 Lives in Orlando 24,692 posts Gave thanks: 943 Thanked 806 times	What uses MySQL on your website? It is doing a lot of processing.

September 16th, 2004, 11:56 AM	#6 (permalink)
Kayla Searcher Surpass Staff Joined in May 2003 Lives in Orlando 24,692 posts Gave thanks: 943 Thanked 806 times	I think he gave me a negative reputation point because I asked the same.

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