MySQL Forums
Forum List  »  General

Procedure Sometimes Won't Return
Posted by: Mikey H
Date: August 07, 2017 01:02PM

Hello Everyone,

So I have a mysql procedure that I use to select some data from many(maybe about 10) tables/views that are joined together. The procedure returns in a few seconds, but if I run it too many times, it will hang. I have several programs that call the procedure about 100 times, and eventually one of the calls will hang(the query won't return, and I have to manually kill the process).

I know the views are created each time in memory, is it possible that I'm running out of some kind of memory? Is there a mysql configuration I change to help with this? Most of the views/joins are indexed, but not all of them. Could this be causing it to hang?

The query is procedure is long and private, otherwise I would post. Thanks for your help.

Options: ReplyQuote


Subject
Written By
Posted
Procedure Sometimes Won't Return
August 07, 2017 01:02PM


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.