Hi
Thanks for the response. In fact my main requirement is to track the
queries executed in the event we have some data which has been contaminated
in some way - which will help us with our investigations. Basically I've
designed a brand new back end office - and feel I need to record the querie
Hi
The purpose is really for auditing and constant performance analysis ? I
could save each query in my own user generated table. But thought maybe
best to use mysql's built in feature.
Neil
On Wed, May 27, 2009 at 5:22 PM, Baron Schwartz wrote:
> Neil,
>
> What is the purpose? Is it for au
Neil,
What is the purpose? Is it for auditing, performance analysis, ...?
Regards
Baron
On Wed, May 27, 2009 at 10:12 AM, Tompkins Neil
wrote:
> Hi,
>
> We've developed a new extranet system and feel that we need to record all
> queries performed. What is the best / recommended way to achieve
Enable mysql SQL logging in the configuration file.
[mysqld]
log
Cheers
Claudio
2009/5/27 Tompkins Neil
> Hi,
>
> We've developed a new extranet system and feel that we need to record all
> queries performed. What is the best / recommended way to achieve this.
>
> Thanks
> Neil
>
Hi, you can start mysql server with --log=/someplace/my_queries.txt and
every query the server runs is logged in that file. Keep in mind that if the
server runs another systems all queries are logged so you need to identify
the ones belong to your system. Also, if you system has a lot of query ca
Neil,
You can turn on the general query log by adding a line like this to your
configuration file:
log=/var/log/mysql_queries.log
Regards,
Nathan
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Wednesday, May 27, 2009 9:13 AM
To: [MySQL]
Subject: Log
