MySQL Forums
Forum List  »  Views

Re: SELECT from view crashes
Posted by: Peter Brawley
Date: May 19, 2015 11:27AM

Did you try setting optimizer_search_depth=4?

If joining a few tables routinely caused crashes, we'd have heard by now. The problem has to be with your setup and/or tables.

Again, let's see the result of Explain Extended on the query, together with Show Create Table results for all referenced tables, and Show Create View for all referenced Views.

Options: ReplyQuote


Subject
Views
Written By
Posted
4179
May 18, 2015 04:18PM
1388
May 18, 2015 09:42PM
1302
May 19, 2015 02:21AM
Re: SELECT from view crashes
1306
May 19, 2015 11:27AM
1192
May 19, 2015 02:33AM


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.