Mysqld logs

Mysqld logs

[Paul Sopka]

[-- Attachment #1.1.1: Type: text/plain, Size: 322 bytes --]

Hey everybody

 From what I could find, mysqld, a server deamon for mysql,
seems to only be able to output logs to files.
Is it a bad idea to run it in the following way?

     mysqld --log_error=/dev/stdout

e.g. in that there any Unix you know about that does not support 
/dev/stdout?

Regards

Paul


[-- Attachment #1.1.2: OpenPGP public key --]
[-- Type: application/pgp-keys, Size: 3195 bytes --]

[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 840 bytes --]

Re: Mysqld logs

[Brett Neumeier via supervision]

On Sat, 7 Dec 2024 15:40:30 +0100
Paul Sopka <psopka@sopka.ch> wrote:

> Hey everybody
> 
>  From what I could find, mysqld, a server deamon for mysql,
> seems to only be able to output logs to files.
> Is it a bad idea to run it in the following way?
> 
>      mysqld --log_error=/dev/stdout
> 
> e.g. in that there any Unix you know about that does not support 
> /dev/stdout?

I don't know of any. If you're concerned, though, you can always
create a FIFO and write log output to it, and then read from that
FIFO in your logging service. That's my common practice when a
program prefers to write log messages to a file. (Or when I set up
a program to write to several different logs, like nginx.)

One thing, though -- MariaDB is the fork of MySQL that I use, and
it has a `--console` option that causes those messages to be written
to stdout already. Perhaps MySQL has that option as well?
That would be even simpler.

Cheers,

Brett

-- 
Brett Neumeier <random@freesa.org>

Re: Mysqld logs

[Paul Sopka]

[-- Attachment #1.1.1: Type: text/plain, Size: 339 bytes --]

Thanks for your reply!

> One thing, though -- MariaDB is the fork of MySQL that I use, and
> it has a `--console` option that causes those messages to be written
> to stdout already. Perhaps MySQL has that option as well?
> That would be even simpler.
Mysqld has this option too, but it does not seem to work.

Regards

Paul


[-- Attachment #1.1.2: OpenPGP public key --]
[-- Type: application/pgp-keys, Size: 3195 bytes --]

[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 840 bytes --]