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 call,
this file can grow very fast so watch this. One disadvantage is with stored
procedure: only the call to the stored procedure is logged, but any of the
queries inside them. Hope this help!
2009/5/27 Tompkins Neil <neil.tompkins@stripped>
> 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.