Date: Mon, 17 Feb 2014 08:01:15 +0100 From: Juergen Nickelsen <ni@w21.org> To: freebsd@fongaboo.com Cc: FreeBSD Mailing List <freebsd-questions@freebsd.org> Subject: Re: MySQL logs Message-ID: <595F60BF-5F24-4E90-893F-B2B9AE1EA624@w21.org> In-Reply-To: <alpine.BSF.2.00.1402141555000.5347@helix.wtfayla.net> References: <alpine.BSF.2.00.1402141555000.5347@helix.wtfayla.net>
next in thread | previous in thread | raw e-mail | index | archive | help
--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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?595F60BF-5F24-4E90-893F-B2B9AE1EA624>