Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

2 minutes to kill server [message #1156] Wed, 25 April 2007 17:53  Thorton Messages: 19 Registered: March 2007 Junior Member Hello, I have extreme problems with mysql on 2xdual Opteron + 2GB RAM server which is more than enough to handle many requests, I believe. I don't know if my queries are not optimized (but I think they are ok). When I start mysql, it takes 2 minutes to kill server because and sites become not accessible. While Apache is processing about 100-200 requests at the same time, there are hundreds of mysql proccesses for unknown reasons. I'm attaching screenshot how everything looks. Screenshot also displays what queries are used, may be queries are wrong? Any help is more than welcome, because all my sites are down about 22-23 hours per day due to heavy sql load and I can't do anything Attachment: sql.gif (Size: 107.94KB, Downloaded 289 time(s)) Report message to a moderator

	2 minutes to kill server By: Thorton on Wed, 25 April 2007 17:53
	Re: 2 minutes to kill server By: sterin on Thu, 26 April 2007 09:55
	Re: 2 minutes to kill server By: Thorton on Thu, 26 April 2007 15:01
	Re: 2 minutes to kill server By: sterin on Thu, 26 April 2007 19:35
	Re: 2 minutes to kill server By: Thorton on Fri, 27 April 2007 02:06
	Re: 2 minutes to kill server By: sterin on Fri, 27 April 2007 04:29
	Re: 2 minutes to kill server By: Thorton on Fri, 27 April 2007 04:57
	Re: 2 minutes to kill server By: Thorton on Mon, 30 April 2007 16:31
	Re: 2 minutes to kill server By: sterin on Mon, 30 April 2007 17:24
	Re: 2 minutes to kill server By: Thorton on Mon, 30 April 2007 17:31
	Re: 2 minutes to kill server By: Thorton on Tue, 01 May 2007 07:22
	Re: 2 minutes to kill server By: sterin on Tue, 01 May 2007 18:10
	Re: 2 minutes to kill server By: Thorton on Wed, 02 May 2007 17:41
	Re: 2 minutes to kill server By: linuxrunner on Thu, 03 May 2007 20:31
	Re: 2 minutes to kill server By: Thorton on Fri, 04 May 2007 16:13
	Re: 2 minutes to kill server By: sterin on Fri, 04 May 2007 16:26
	Re: 2 minutes to kill server By: Thorton on Fri, 04 May 2007 16:43
	Re: 2 minutes to kill server By: linuxrunner on Fri, 04 May 2007 19:06

Previous Topic:	Lost connection to MySQL server during query
Next Topic:	Injecting large amounts of random data

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]