MySQL Forums
Forum List  »  Views

Re: Creating Views problem in 5.6/5.7
Posted by: Peter Brawley
Date: June 22, 2017 06:04PM

Ok, vanilla joins but lots of them; some 5.6-7 optimisation changes may be having effects, going to need to look at ...

- Explain result for the three queries used in those Create View statements in each of 5.5 and 5.7, each Explain result inside BBCode [ code ] [ /code ] tags without the spaces (for readability)

- Show Create Table results for the referenced base tables

- my.ini settings

- either the results of show variables and of show engine innodb status\G, or the result of running the "cheatsheet" code under that heading at https://www.artfulsoftware.com/infotree/mysqltips.php

Options: ReplyQuote


Subject
Views
Written By
Posted
1054
June 22, 2017 02:12PM
Re: Creating Views problem in 5.6/5.7
510
June 22, 2017 06:04PM


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.