# Query optimization

**URL:** <https://forums.percona.com/t/query-optimization/6582>\
**Category:** Percona Server for MySQL 5.7\
**Created:** [September 18, 2018, 3:32am UTC](https://forums.percona.com/t/query-optimization/6582 "2018-09-18T03:32:22Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![gandalf](https://avatars.discourse-cdn.com/v4/letter/g/59ef9b/32.png) [@gandalf](https://forums.percona.com/u/gandalf)\
**Post date:** [September 21, 2018, 2:08am UTC](https://forums.percona.com/t/query-optimization/6582/8 "2018-09-21T02:08:31Z")

</div>

I’ve disabled query cache (immediatly execution time increased a lot) and added the following:

# Percona

log\_slow\_filter = full\_scan,full\_join,tmp\_table\_on\_disk,filesort,filesort\_on\_disk  
slow\_query\_log\_file = /var/log/mysql/slow.log  
long\_query\_time = 10  
slow\_query\_log = ON

I don’t see anything logged, thus all executed query are properly using indexes and not making full scans or similiar.

---

_[View the full topic](https://forums.percona.com/t/query-optimization/6582)._