Members   Search   Help    Register    Login   Home

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

Strange MySQL behavior [message #2067] Tue, 16 October 2007 03:42  AlexN Messages: 20 Registered: October 2007 Location: Moscow,Russia Junior Member Some days ago I encountered with a strange problem. MySQL and Apache resides both on the same server. In attempt to optimize MySQL someone increased the key buffer too much. Also the number of temp tables has been set too large. At first it worked fine, but when the server load increased, Apache used some memory, while MySQL started to create temp tables on disk instead of memory. Queries took more time to complete, and new connections continued to arrive. In less than 20 minutes the whole server nearly stopped. There were about 20 running processes, all in the state "Copying to temp table". The question is: how to avoid such situation ? In, for example, MSSQL this scenario is hardly possible. Report message to a moderator

	Strange MySQL behavior By: AlexN on Tue, 16 October 2007 03:42
	Re: Strange MySQL behavior By: sterin on Tue, 16 October 2007 09:21
	Re: Strange MySQL behavior By: AlexN on Tue, 16 October 2007 10:23
	Re: Strange MySQL behavior By: sterin on Tue, 16 October 2007 12:24
	Re: Strange MySQL behavior By: AlexN on Wed, 17 October 2007 03:35
	Re: Strange MySQL behavior By: sterin on Wed, 17 October 2007 19:55
	Re: Strange MySQL behavior By: AlexN on Thu, 18 October 2007 03:06
	Re: Strange MySQL behavior By: sterin on Thu, 18 October 2007 05:03
	Re: Strange MySQL behavior By: AlexN on Thu, 18 October 2007 06:26
	Re: Strange MySQL behavior By: sterin on Thu, 18 October 2007 08:26

Previous Topic:	IS NOT NULL condition - MySQL doesn't use index
Next Topic:	Query tuning - Performance Issue

Goto Forum:

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