# How do I CREATE General Query and Slow Query Log

**URL:** https://forums.percona.com/t/how-do-i-create-general-query-and-slow-query-log/1038
**Category:** Other MySQL® Questions
**Created:** [December 17, 2008, 12:58pm UTC](https://forums.percona.com/t/how-do-i-create-general-query-and-slow-query-log/1038 "2008-12-17T12:58:46Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![TurtleInAsia](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/turtleinasia/32/799_2.png) [@TurtleInAsia](https://forums.percona.com/u/TurtleInAsia)
#### Post date: [December 17, 2008, 12:58pm UTC](https://forums.percona.com/t/how-do-i-create-general-query-and-slow-query-log/1038/1 "2008-12-17T12:58:46Z")

</div>

I am searching for details on how to create the mysql. tables for logging in 5.0.45

Hoping someone can help.

---

<div class="post-metadata">

### Author: ![januzi](https://avatars.discourse-cdn.com/v4/letter/j/82dd89/32.png) [@januzi](https://forums.percona.com/u/januzi)
#### Post date: [December 17, 2008, 1:23pm UTC](https://forums.percona.com/t/how-do-i-create-general-query-and-slow-query-log/1038/2 "2008-12-17T13:23:07Z")

</div>

in my.cnf (/etc/mysql/my.cnf) or my.ini (c:\windows) add:

| [B]Quote:[/B] |
| 

long-query-time = 1  
log=/var/log/mysql/query-log  
log-slow-queries=/var/log/mysql/slow-query  
log-queries-not-using-indexes

 |

to the [mysqld] or whatever You run

under Windows second and third line should point to the c:\something\

after that restart mysql