Package: mysql-server-5.0 Version: 5.0.38-1 Severity: wishlist Hello I run a server with several virtual domains, several databases and several users.
For debugging and security purpose, I'd like to be able to log separately the queries sent to each database or sent by each user. I know that binlog permits to get separates datas for differents databases, but it's not possible to "tail" its output and furthermore it only logs the changes to databases, not the SELECT queries. It's why for now I still use mysql.log but the use of : tail -f /var/log/mysql/mysql.log is a bit confused if there are many queries sent at the same time, and it's not possible to filter the output with grep as the database name is only written on the first line. I've looked for a workaround on many forums, asked this question many times, but I never got any answer. -- System Information: Debian Release: lenny/sid APT prefers testing APT policy: (500, 'testing'), (500, 'stable') Architecture: i386 (i686) Kernel: Linux 2.6.18-4-686 (SMP w/1 CPU core) Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15) Shell: /bin/sh linked to /bin/bash Versions of packages mysql-server-5.0 depends on: ii adduser 3.102 Add and remove users and groups ii debconf [debconf-2.0] 1.5.13 Debian configuration management sy ii libc6 2.3.6.ds1-13 GNU C Library: Shared libraries ii libdbi-perl 1.53-1 Perl5 database interface by Tim Bu ii libgcc1 1:4.1.1-21 GCC support library ii libmysqlclient15off 5.0.38-1 mysql database client library ii libncurses5 5.5-5 Shared libraries for terminal hand ii libreadline5 5.2-2 GNU readline and history libraries ii libstdc++6 4.1.1-21 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-13 Wietse Venema's TCP wrappers libra ii lsb-base 3.1-23.1 Linux Standard Base 3.1 init scrip ii mysql-client-5.0 5.0.38-1 mysql database client binaries ii mysql-common 5.0.38-1 mysql database common files (e.g. ii passwd 1:4.0.18.1-7 change and administer password and ii perl 5.8.8-7 Larry Wall's Practical Extraction ii psmisc 22.3-1 Utilities that use the proc filesy ii zlib1g 1:1.2.3-13 compression library - runtime Versions of packages mysql-server-5.0 recommends: ii mailx 1:8.1.2-0.20050715cvs-1 A simple mail user agent -- debconf information: * mysql-server/root_password: (password omitted) mysql-server-5.0/really_downgrade: false mysql-server-5.0/start_on_boot: true mysql-server-5.0/nis_warning: mysql-server-5.0/postrm_remove_databases: false mysql-server-5.0/no_upgrade_with_isam_tables: * mysql-server-5.0/mysql_install_db_notes: mysql-server-5.0/need_sarge_compat: false mysql-server/error_setting_password: mysql-server-5.0/mysql_update_hints1: mysql-server-5.0/need_sarge_compat_done: true -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
