Location of the mysql error log

my server is centos7. Why is my log_error stderr instead of the path to a file? The version of mysql I use is 5.7

clipboard.png

Mar.16,2021

the ability to log errors is turned off, and error messages are output to the standard error output stderr, before the .err error file is turned on.

  • The strange problem of mysql leftjoin

    SELECT tg.id,tg.name FROM trd_goods tg LEFT JOIN trd_goods_tag_relation tgt ON tg. id = tgt. goods_id this is my sql statement, if 50 pieces of data on the left and 100 pieces of data on the right, it is an one-to-many relationship. If I have a...

    Mar.23,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3d964-34756.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3d964-34756.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?