mysql logfile configuration

mysql logfile configuration

am 18.04.2008 12:25:33 von Uwe Kiewel

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi @all,

ich have configured in /etc/my.cf as follow:

[...]
log="/var/log/mysqld.log"
[...]


Now, mysqld writes every query to the log file. How can I avoid the
queries in the log file? I want to see any action done by mysql, but not
the queries.

Thx,
Uwe
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iQEVAwUBSAh3Hds3frmum9swAQIZbgf7B40LUiqjZchb2fyefyy9mNjxEIeM /ftt
tBVIjnrVVesyJo6FZJdZo3tlfNh3hkrrNIqTbR6Dy5P2sDRZ+4GIyMs+MEX9 A4dw
NBjaMoj648HyQivjomJYe0vwWBKF+UmTM2qOsQEQi1AArJtg33mBGTNOA++6 HigX
TpVGkn991+AyTUt+JYXDXOyHOjaLoSz/AhWSjvz5kM5lgyZPcssDKWVDzWDA OtrO
KTnYsby59+ctK3h61tkAecJeAElZq0JnMlalJlwXnIbcolGcO59Z/gC0U80V MYyf
kGdRzHbegCVd+r2M1haLdk6Ygunk/3KQa/GW+gqhuYjRMpCcudJqkw==
=el3Y
-----END PGP SIGNATURE-----

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: mysql logfile configuration

am 18.04.2008 16:17:10 von Ananda Kumar

------=_Part_7263_26426644.1208528230044
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

just comment this parameter, all actions done by mysql will be in
hostnam.err file


On 4/18/08, Uwe Kiewel wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi @all,
>
> ich have configured in /etc/my.cf as follow:
>
> [...]
> log="/var/log/mysqld.log"
> [...]
>
>
> Now, mysqld writes every query to the log file. How can I avoid the
> queries in the log file? I want to see any action done by mysql, but not
> the queries.
>
> Thx,
> Uwe
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.7 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iQEVAwUBSAh3Hds3frmum9swAQIZbgf7B40LUiqjZchb2fyefyy9mNjxEIeM /ftt
> tBVIjnrVVesyJo6FZJdZo3tlfNh3hkrrNIqTbR6Dy5P2sDRZ+4GIyMs+MEX9 A4dw
> NBjaMoj648HyQivjomJYe0vwWBKF+UmTM2qOsQEQi1AArJtg33mBGTNOA++6 HigX
> TpVGkn991+AyTUt+JYXDXOyHOjaLoSz/AhWSjvz5kM5lgyZPcssDKWVDzWDA OtrO
> KTnYsby59+ctK3h61tkAecJeAElZq0JnMlalJlwXnIbcolGcO59Z/gC0U80V MYyf
> kGdRzHbegCVd+r2M1haLdk6Ygunk/3KQa/GW+gqhuYjRMpCcudJqkw==
> =el3Y
> -----END PGP SIGNATURE-----
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=anandkl@gmail.com
>
>

------=_Part_7263_26426644.1208528230044--