HELP - mySQL question - GoFuckYourself.com

Jinn · 02-04-2003, 02:04 PM

My server is running FreeBSD + apache + php + mySQL. Recently, I keep getting error messages like this:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

When I check the memory and cpu usage, there are a couple hundreds of MB ram free. But the cpu idle is 0.0%! And mysqld is taking 95% or more of the cpu time. The server was running well and there is no new scripts installed and no significant increase in traffic. Anyone can provide some insight about what went wrong here? I don't know if it's related, but the problem started just a couple days after the recent internet worm attack.

Any help please? Thanks!

Jin

gothweb · 02-04-2003, 02:06 PM

FuqALot · 02-04-2003, 02:09 PM

Yes, this could be indeed the sql worm, I suggest you contact your system admin or something :-P.

http://www.microsoft.com/Downloads/d...7-2DE45CFA6A89

DrGuile · 02-04-2003, 02:13 PM

are you running the latest version?

ahahhahah, this as no chance to be the SLAMMER worm...

its an MS-SQL worm...

Jinn · 02-04-2003, 02:44 PM

I am running mysql version 3.23.49. Do you think the upgrade will help here? I don't believe it's from the slammer worm, either.

Backov · 02-04-2003, 02:59 PM

Jesus fucking christ.

It's not the SQL worm, that only affects MS SQL.

You are probably running out of connections.. And if mysql is taking 100% of your CPU, then whatever script you are running was written by a retarded monkey. You wouldn't believe the abuse I can put mysql through before it even starts to break a sweat.

The short of it: Talk to your sysadmin. He'll be able to up your connections, or restart the server, or whatever has gone wrong with MySQL.

Cheers,
Backov

gothweb · 02-04-2003, 03:02 PM

Actually... Could the worm be causing traffic that would explain the load on a non-MS SQl server?

wwwcashmountain · 02-04-2003, 03:43 PM

Quote:

Jesus fucking christ.

It's not the SQL worm, that only affects MS SQL.

Heh.

You'll get this error if

a) all your mysql connections are taken up
b) mysql isnt running

I'd say you have a slow process running. Restart the DB and sit in a mysql window doing a 'show processlist' to see what's going on.

Rob.

boldy · 02-04-2003, 03:49 PM

try todo a 'show processlist' to see which queries are fucking up your system.

May b one of your indexes is corrupt, try todo a

mysqlcheck -o --all-databases -p

02-04-2003, 02:04 PM	#1
Jinn Confirmed User Join Date: Nov 2001 Posts: 72	HELP - mySQL question My server is running FreeBSD + apache + php + mySQL. Recently, I keep getting error messages like this: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) When I check the memory and cpu usage, there are a couple hundreds of MB ram free. But the cpu idle is 0.0%! And mysqld is taking 95% or more of the cpu time. The server was running well and there is no new scripts installed and no significant increase in traffic. Anyone can provide some insight about what went wrong here? I don't know if it's related, but the problem started just a couple days after the recent internet worm attack. Any help please? Thanks! Jin

02-04-2003, 02:06 PM	#2
gothweb Confirmed User Join Date: Jun 2002 Location: Back in the USSA Posts: 8,849	__________________ Photos by Ian X.: Distinctive photos of goth babes. Blood Money:Your traffic, my sites, our money. MojoHost: Still the best.

02-04-2003, 02:09 PM	#3
FuqALot Confirmed User Join Date: Dec 2001 Location: Malibu Posts: 3,817	Yes, this could be indeed the sql worm, I suggest you contact your system admin or something :-P. http://www.microsoft.com/Downloads/d...7-2DE45CFA6A89 Last edited by FuqALot; 02-04-2003 at 02:11 PM..

02-04-2003, 02:13 PM	#4
DrGuile Confirmed User Join Date: Jan 2002 Posts: 2,025	are you running the latest version? ahahhahah, this as no chance to be the SLAMMER worm... its an MS-SQL worm... __________________ LiveBucks / Privatefeeds - Giving you money since 1999 Up to 50% Commission! 25% Webmaster Referal Powered by Gamma

02-04-2003, 02:59 PM	#6
Backov Confirmed User Join Date: Mar 2001 Location: Cat Detector Van Posts: 1,600	Jesus fucking christ. It's not the SQL worm, that only affects MS SQL. You are probably running out of connections.. And if mysql is taking 100% of your CPU, then whatever script you are running was written by a retarded monkey. You wouldn't believe the abuse I can put mysql through before it even starts to break a sweat. The short of it: Talk to your sysadmin. He'll be able to up your connections, or restart the server, or whatever has gone wrong with MySQL. Cheers, Backov __________________ <embed src="http://banners.spotbrokers.com/button.swf" FlashVars="clickURL=http://banners.spotbrokers.com" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="120" height="60"></embed>

02-04-2003, 02:44 PM	#5
Jinn Confirmed User Join Date: Nov 2001 Posts: 72	I am running mysql version 3.23.49. Do you think the upgrade will help here? I don't believe it's from the slammer worm, either.

02-04-2003, 03:02 PM	#7
gothweb Confirmed User Join Date: Jun 2002 Location: Back in the USSA Posts: 8,849	Actually... Could the worm be causing traffic that would explain the load on a non-MS SQl server? __________________ Photos by Ian X.: Distinctive photos of goth babes. Blood Money:Your traffic, my sites, our money. MojoHost: Still the best.

02-04-2003, 03:49 PM	#9
boldy Macdaddy coder Industry Role: Join Date: Feb 2002 Location: MacDaddy pimp coder Posts: 2,806	try todo a 'show processlist' to see which queries are fucking up your system. May b one of your indexes is corrupt, try todo a mysqlcheck -o --all-databases -p __________________ MacDaddy Coder.