MySQL Forums
Forum List  »  Performance

Re: my.cnf file config
Posted by: Peter Brawley
Date: January 02, 2019 02:35PM

Views are saved as literal query text, they aren't compiled nor are their results saved. They organise your queries, they don't help performance.

So let's see ...

- the query on which the View is based,

- results of running Explain on it on the two servers,

- results of Show Create Table for each table referenced by the query, plus any differences in such between the two servers

- my.cnf on the two servers

Options: ReplyQuote


Subject
Views
Written By
Posted
143
January 02, 2019 02:16PM
Re: my.cnf file config
66
January 02, 2019 02:35PM


Sorry, only registered users may post in this forum.

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.