MySQL 5.0.45 - Unable to log queries
Posted by: Eye Gee Kua
Date: February 13, 2017 03:45AM

I am using MySQL 5.0.45 and trying to log all the queries and have set the following in my.ini:

********************************************************
log=query.log
#Log all queries that have taken more than long_query_time seconds to execute to file.
long_query_time=1
#Don't cache results that are bigger than this.
query_cache_limit=1M
#Enter a name for the slow query log. Otherwise a default name will be used.
log-slow-queries=slow_query.log
********************************************************
I run sql but can't find any sql in query.log but following log:

\ProgramData\Quest Software\BMF\Repository\MySQL\bin\mysqld-max-nt.exe, Version: 5.0.15-nt-max-log. started with:
TCP Port: 4570, Named Pipe: (null)
Time Id Command Argument
C:\ProgramData\Quest Software\BMF\Repository\MySQL\bin\mysqld-max-nt.exe, Version: 5.0.15-nt-max-log. started with:
TCP Port: 4570, Named Pipe: (null)
Time Id Command Argument

********************************************************

When I tried to show variables I found the following:

| log | OFF
|
| log_bin | OFF
|
| log_queries_not_using_indexes | OFF
|
| log_slave_updates | OFF
|
| log_slow_queries | OFF

********************************************************

Anybody, any recommendations ?

Options: ReplyQuote


Subject
Written By
Posted
MySQL 5.0.45 - Unable to log queries
February 13, 2017 03:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.