major/MySQLTuner-perl

Support for syslog (MariaDB 10.3 & Ubuntu 18.04)

Open

#440 opened on Jun 16, 2019

View on GitHub
 (1 comment) (0 reactions) (1 assignee)Perl (9,452 stars) (1,293 forks)batch import
Help Wantedenhancement

Description

There is no error log file on fresh installation of MariaDB 10.3 on Ubuntu Server 18.04. Syslog is used instead. Is possible to add support for syslog?

Current status:

-------- Log file Recommendations ------------------------------------------------------------------ [--] Log file: /var/lib/mysql/manitu.err(0B) [!!] Log file /var/lib/mysql/manitu.err doesn't exist [!!] Log file /var/lib/mysql/manitu.err isn't readable.

All logged messages can be found with command cat /var/log/syslog | grep "mysqld"

Contributor guide

Tech stack
None
Domain
database
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Familiarity with PerlKnowledge of MySQL error loggingUnderstanding of syslog
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
40
Research direction
Investigate the MySQLTuner Perl script to locate where it checks for error log files (likely near log file recommendations). Modify the code to detect when syslog is used instead of a file, and output recommendations based on syslog entries using commands like 'cat /var/log/syslog | grep mysqld'. Consider adding a command line option or automatic detection. Review any existing comments or linked issues for additional context.