I realize that.
The documentation states that username and timestamp,
by default, are logged to (update log, binary update log, and slow queries
log, whatever log has been activated). But apparently it isn't.
I was hoping that there was a way to get that information in the binary
log, but it appears more likely the documentation is wrong.
~jerry
On Fri, 5 Aug 2005, Gleb Paharenko wrote:
Hello.
I think these lines from sql/mysqld.cc from 4.1.13 distribution shows
that --log-long-format doesn't affect the behavior of MySQL:
{log-long-format, '0',
Log some extra information to update log. Please note that this
option is deprecated; see --log-short-format option.,
0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
^^^
User names are written to the general log.
Jerry Bonner [EMAIL PROTECTED] wrote:
The current documentation states :
Log some extra information to the log files (update log, binary update
log, and slow queries log, whatever log has been activated). For example,
username and timestamp are logged for queries. Before MySQL 4.1, if you
are using --log-slow-queries and --log-long-format, queries that are not
using indexes also are logged to the slow query log. --log-long-format is
deprecated as of MySQL version 4.1, when --log-short-format was
introduced. (Long log format is the default setting since version 4.1.)
Also note that starting with MySQL 4.1, the
--log-queries-not-using-indexes option is available for the purpose of
logging queries that do not use indexes to the slow query log.
I'm using 4.1.13, however, I don't see username or host information for
binary logs, just slow query logs. Am I missing something?
Jerry Bonner
Systems Engineer
CP Telecom
[EMAIL PROTECTED]
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
