From owner-freebsd-questions@FreeBSD.ORG Mon Feb 17 07:01:18 2014 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 0062351C for ; Mon, 17 Feb 2014 07:01:17 +0000 (UTC) Received: from w21.org (ribe.w21.org [IPv6:2a01:238:4382:a300:3fe5:41ce:8574:8378]) by mx1.freebsd.org (Postfix) with ESMTP id B04841C75 for ; Mon, 17 Feb 2014 07:01:17 +0000 (UTC) Received: from wrixum4.ni.w21.org (p4FC0B4C8.dip0.t-ipconnect.de [79.192.180.200]) by w21.org (Postfix) with ESMTPSA id D9D131D04017; Mon, 17 Feb 2014 08:01:15 +0100 (CET) Content-Type: multipart/signed; boundary="Apple-Mail=_FD2F09BE-7A13-4B4D-A57A-821A95F30A72"; protocol="application/pgp-signature"; micalg=pgp-sha1 Mime-Version: 1.0 (Mac OS X Mail 7.1 \(1827\)) Subject: Re: MySQL logs From: Juergen Nickelsen In-Reply-To: Date: Mon, 17 Feb 2014 08:01:15 +0100 Message-Id: <595F60BF-5F24-4E90-893F-B2B9AE1EA624@w21.org> References: To: freebsd@fongaboo.com X-Mailer: Apple Mail (2.1827) Cc: FreeBSD Mailing List X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.17 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 17 Feb 2014 07:01:18 -0000 --Apple-Mail=_FD2F09BE-7A13-4B4D-A57A-821A95F30A72 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii On 2014-02-14, at 21:56, freebsd@fongaboo.com wrote: > How does one set up per-query logs on MySQL in FreeBSD? Google results = are very vague and seem to vary per OS. Average Google results will not be as relevant as the MySQL = documentation itself, which is quite okay. But admittedly, it is a bit = hidden on the MySQL web site, so I get always faster to it by searching. = Using the search terms mysql 5.1 query log should lead you straight to the relevant page; for me this works not = only with my probably strongly MySQL-primed Google search bubble, but = also with, for instance, DuckDuckGo. In my experience, including the relevant version number is helpful to = reach the official MySQL documentation instead of all those blog pages = of dubious know-it-alls. Anyway, the relevant page is http://dev.mysql.com/doc/refman/5.1/en/query-log.html For other versions, replace 5.1 in that URL with the actual version you = have in use. Be sure to check the page exactly for the version you are = using; there have been a number of changes even in version increments in = the third number. (MySQL is prone to such changes. One of these in a recent 5.1 update = with Debian stable recently broke one customer's configuration, when a = deprecated configuration keyword was finally invalidated -- in a minor = minor version update, I'd like to stress. Furrfu.) Well, indeed it is worth checking the documentation carefully in *any* = case, and Read The Whole Page. Regards, Juergen. --Apple-Mail=_FD2F09BE-7A13-4B4D-A57A-821A95F30A72 Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=signature.asc Content-Type: application/pgp-signature; name=signature.asc Content-Description: Message signed with OpenPGP using GPGMail -----BEGIN PGP SIGNATURE----- Comment: GPGTools - http://gpgtools.org iQEcBAEBAgAGBQJTAbO7AAoJEEb28HuG6YEfM+QIAI6rNjrSgFPUPvgi6HVSv+Qf d85O46rrUc/KKfXhPVVL2p5UFLwohPjSclayji6HkIApWcTm0+V3gk5nL8jNV1TE FPrgUs6RMlGnjb2O+flpU42QQm7TfGYWzPBH85AOTLiPAkPH6AL/VLKhwaaWY4U4 9ztLIWykuiowZvxtUboUSXDfBmjKkwsOHnnaXCOUANAvMoeoTKgcF8bLc/9PKF7x YTmnqMq6qam3o4ZAb/mPswJVvfMM55MTyy7jxpVO9hwDe8kNeM8FMR3yAWRY4TKM DIgPLLmV6vfuAbPpVgz3I6DDeI+2q9idwIcYbnuIiGgazitEAEDLUhj/FsOPIqY= =WFfL -----END PGP SIGNATURE----- --Apple-Mail=_FD2F09BE-7A13-4B4D-A57A-821A95F30A72--