Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

How do I CREATE General Query and Slow Query Log

TurtleInAsiaTurtleInAsia EntrantCurrent User Role Beginner
I am searching for details on how to create the mysql. tables for logging in 5.0.45

Hoping someone can help.

Comments

  • januzijanuzi Advisor Inactive User Role Beginner
    in my.cnf (/etc/mysql/my.cnf) or my.ini (c:\windows\) add:
    <table border="0" align="center" width="90%" cellpadding="3" cellspacing="1"><tr><td class="SmallText">Quote:</td></tr><tr><td class="quote">

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

    </td></tr></table>
    to the [mysqld] or whatever You run

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

    after that restart mysql
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.