# Performance check

**URL:** <https://forums.percona.com/t/performance-check/541>\
**Category:** Other MySQL® Questions\
**Created:** [November 27, 2007, 4:19am UTC](https://forums.percona.com/t/performance-check/541 "2007-11-27T04:19:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![annpeter](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@annpeter](https://forums.percona.com/u/annpeter)\
**Post date:** [November 27, 2007, 4:19am UTC](https://forums.percona.com/t/performance-check/541/1 "2007-11-27T04:19:06Z")

</div>

Hi friends,  
How can i get a log to check the performance of my application in my sql.  
thanks  
annie

---

<div class="post-metadata">

**Author:** ![scoundrel](https://avatars.discourse-cdn.com/v4/letter/s/3ec8ea/32.png) [@scoundrel](https://forums.percona.com/u/scoundrel)\
**Post date:** [November 27, 2007, 3:22pm UTC](https://forums.percona.com/t/performance-check/541/2 "2007-11-27T15:22:23Z")

</div>

First of all I’d suggest to enable slow queries log:

long\_query\_time = 1log\_queries\_no\_using\_indexeslog\_slow\_queries = /var/log/mysql/mysql-slow.log

And then put your application under some load (I mean jut work with it). When you’ll get some noticeable amount of queries in the mysql-slow.log, just use mysqlsla on it and you’ll see where you need to look to optimize your aplication.