Not the answer you need?
Register and ask your own question!

optimize query

jposposjpospos EntrantCurrent User Role Beginner
Hi, I need some advice regarding this query.

https://tools.percona.com/query/PTsWIJSJ/advice

I've already optimized my MySQL server configuration usually it takes around 300-380 seconds to finish, after optimization it now just takes around 100-120 seconds.

Querying happens from a remote server but on a local network.

Thanks,

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    This is really complex query, joining many tables with some sub-selects. Definitely it's not OLTP type, so don't expect it to finish in less then second :)
    Provide EXPLAIN plan and all related tables definitions, maybe there are some index opportunities to make it faster.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.