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
1326
January 02, 2019 02:16PM
Re: my.cnf file config
464
January 02, 2019 02:35PM


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.