MySQL Forums
Forum List  »  Performance

Re: MySQL 8.0 - View Performance
Posted by: Peter Brawley
Date: September 20, 2019 11:18PM

> The initial SQL without any subviews hasn't run successfully in MySql.

Then it needs first to be optimised as a straight query with all its subqueries.

For help with that, please post the query with ...

- Show Create Table results for each referenced table

- inside BBCode code tags, the results of running Explain on the query

- innodb_buffer_pool_size setting

- Tail of Show Engine InnoDB Status whilst the query is running

Options: ReplyQuote


Subject
Views
Written By
Posted
960
September 20, 2019 07:47PM
457
September 20, 2019 09:14PM
244
September 20, 2019 10:29PM
Re: MySQL 8.0 - View Performance
247
September 20, 2019 11:18PM
255
September 21, 2019 12:18AM


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.