MySQL Forums
Forum List  »  Performance

Re: "Sending Data" is taking time post migration from 5.1 to 5.6
Posted by: Peter Brawley
Date: March 15, 2017 12:43PM

With 64GB RAM, innodb_buffer_pool_size can be up to 48GB.

The query profiler slows performance and isn't often helpful with optimisation.

Again: Explain is telling you MySQL can't find an index for bct_prod, so it's having to examine millions of rows; that table needs index(prodno,rstate).

Options: ReplyQuote




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.