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
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 ba...@xaprb.com wrote:
Neil,
What is the purpose?
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
: Logging SQL queries
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
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
Enable mysql SQL logging in the configuration file.
[mysqld]
log
Cheers
Claudio
2009/5/27 Tompkins Neil neil.tompk...@googlemail.com
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.
Neil,
What is the purpose? Is it for auditing, performance analysis, ...?
Regards
Baron
On Wed, May 27, 2009 at 10:12 AM, Tompkins Neil
neil.tompk...@googlemail.com wrote:
Hi,
We've developed a new extranet system and feel that we need to record all
queries performed. What is the best /