MySQL Forums :: Performance :: Long query locking up MySQL Server


Advanced Search

Long query locking up MySQL Server
Posted by: Radek Antoniuk ()
Date: December 01, 2010 05:23AM

Hey,

I'd like to review my attitude to one problem.
I have a database with approx. 1M records in a MyISAM table, but that is not important I think.

The thing is. A Web Application is running a query on a database, that is using filesort,where,temporary.
This query takes appros 1200s to complete (at least).
After this SELECT is executed, it gets stored in CACHE, which is good.
However, when the server is restarted, and the query has to be cached first, then the web application piles up those queries ending up with number of those queries(exactly the same) running and the machine load going sky high.
Eventually, the server locks up.

How to avoid that situation? Any good practices?
My idea is that the web application has to check if that query is being executed but... maybe that can be achieved somehow on mysql level?

Thanks for help.

Options: ReplyQuote


Subject Views Written By Posted
Long query locking up MySQL Server 3196 Radek Antoniuk 12/01/2010 05:23AM
Re: Long query locking up MySQL Server 782 Shawn Taylor 12/01/2010 02:54PM
Re: Long query locking up MySQL Server 839 Rick James 12/02/2010 12:27AM
Re: Long query locking up MySQL Server 777 Radek Antoniuk 12/03/2010 05:54AM
Re: Long query locking up MySQL Server 725 Shawn Taylor 12/03/2010 08:05AM
Re: Long query locking up MySQL Server 768 Rick James 12/03/2010 08:46AM
Re: Long query locking up MySQL Server 771 Radek Antoniuk 12/03/2010 11:59AM
Re: Long query locking up MySQL Server 729 Shawn Taylor 12/03/2010 01:52PM
Re: Long query locking up MySQL Server 733 Shawn Taylor 12/03/2010 02:23PM
Re: Long query locking up MySQL Server 681 Radek Antoniuk 12/03/2010 02:32PM
Re: Long query locking up MySQL Server 678 Shawn Taylor 12/03/2010 03:20PM
Re: Long query locking up MySQL Server 670 Rick James 12/03/2010 09:21PM
Re: Long query locking up MySQL Server 744 Radek Antoniuk 12/04/2010 01:52AM
Re: Long query locking up MySQL Server 1645 Rick James 12/04/2010 11:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.