EnglishIf you're seeing duplicate log entries for mysqld.log in /var/lib/mysql/, it could be due to misconfiguration or multiple log handlers being active. Here's how you can address this issue:
-
Check MySQL Configuration:
-
Open your MySQL configuration file (typically
my.cnformy.ini). This file is usually located in/etc/mysql/or/etc/. -
Look for any duplicate entries related to the log file location or log handling. Remove or correct any duplicate entries.
-
-
Verify Log Configuration:
-
Confirm that you're using the correct configuration for MySQL logs. The relevant lines in your
my.cnffile should look something like this:lua
-
-
-
[mysqld] log-error=/var/log/mysql/error.log -
Ensure that there are no duplicate entries or conflicting configurations.
-
-
Check for Symlinks:
- Make sure that there are no symbolic links that could be causing the log entries to be written to the same location multiple times.
-
Check for Additional Logging Configurations:
- Some systems may have additional logging configurations in place, which could result in duplicate entries. Review any additional files in
/etc/mysql/conf.d/or similar directories.
- Some systems may have additional logging configurations in place, which could result in duplicate entries. Review any additional files in
-
Check for Log Rotations:
- Verify that log rotation processes are not causing duplicate entries. Log rotation scripts typically reside in
/etc/logrotate.d/.
- Verify that log rotation processes are not causing duplicate entries. Log rotation scripts typically reside in
-
Restart MySQL:
-
After making any necessary changes, restart MySQL for the configurations to take effect:
bash
-
-
-
systemctl restart mysql
-
-
Check for Third-Party Plugins or Tools:
- If you have third-party plugins or tools that interact with MySQL, they may be causing duplicate logging. Disable them temporarily to see if the issue persists.
-
Monitor for New Entries:
- After restarting MySQL, monitor the logs in real time to ensure that new entries are not being duplicated.
-
Review System Logs:
- Check system logs (e.g.,
/var/log/syslogor/var/log/messages) for any unusual messages or warnings related to MySQL or the logging process.
- Check system logs (e.g.,
-
Check for MySQL Updates or Bug Reports:
- Sometimes, issues like this can be caused by software bugs. Check if there are any updates available for MySQL or search for known issues or bug reports related to log duplication.
-
Consult with MySQL Support:
- If the issue persists, consider reaching out to MySQL support or community forums for further assistance. They may have specific recommendations or solutions for this issue.
Remember to proceed with caution and have backups available before making significant modifications to your server configuration. If you're unsure about any of the steps, consider seeking advice from your hosting provider or system administrator.
