File Manager

X7ROOT File Manager

Current Path: /usr/share/mysql

📁 ..
📄 binary-configure(1.13 KB)
📁 bulgarian
📁 charsets
📁 chinese
📁 czech
📁 danish
📁 dutch
📁 english
📄 errmsg-utf8.txt(811.29 KB)
📁 estonian
📄 fill_help_tables.sql(2.04 MB)
📁 french
📁 georgian
📁 german
📁 greek
📁 hindi
📁 hungarian
📁 italian
📁 japanese
📁 korean
📄 magic(1.44 KB)
📄 maria_add_gis_sp.sql(1.67 KB)
📄 maria_add_gis_sp_bootstrap.sql(1.64 KB)
📄 mariadb.logrotate(1.82 KB)
📄 mini-benchmark(9.37 KB)
📄 mysql.server(12.4 KB)
📄 mysql_performance_tables.sql(1.91 KB)
📄 mysql_sys_schema.sql(604.71 KB)
📄 mysql_system_tables.sql(29.86 KB)
📄 mysql_system_tables_data.sql(3.25 KB)
📄 mysql_test_data_timezone.sql(10.17 KB)
📄 mysql_test_db.sql(1.73 KB)
📄 mysqld_multi.server(1.53 KB)
📁 norwegian
📁 norwegian-ny
📁 policy
📁 polish
📁 portuguese
📁 romanian
📁 russian
📁 serbian
📁 slovak
📁 spanish
📁 swedish
📁 systemd
📁 ukrainian
📄 wsrep.cnf(3.39 KB)
📄 wsrep_notify(4.86 KB)

Editing: mariadb.logrotate

# This is the MariaDB configuration for the logrotate utility
#
# Note that on most Linux systems logs are written to journald, which has its
# own rotation scheme.
#
# Read https://mariadb.com/kb/en/error-log/ to learn more about logging and
# https://mariadb.com/kb/en/rotating-logs-on-unix-and-linux/ about rotating logs.

/var/lib/mysql/mysqld.log /var/lib/mysql/mariadb.log /var/log/mariadb/*.log {

# Depends on a mysql@localhost unix_socket authenticated user with RELOAD privilege
  su mysql mysql

# If any of the files listed above is missing, skip them silently without
  # emitting any errors
  missingok

# If file exists but is empty, don't rotate it
  notifempty

# Run monthly
  monthly

# Keep 6 months of logs
  rotate 6

# If file is growing too big, rotate immediately
  maxsize 500M

# If file size is too small, don't rotate at all
  minsize 50M

# Compress logs, as they are text and compression will save a lot of disk space
  compress

# Don't compress the log immediately to avoid errors about "file size changed while zipping"
  delaycompress

# Don't run the postrotate script for each file configured in this file, but
  # run it only once if one or more files were rotated
  sharedscripts

# After each rotation, run this custom script to flush the logs. Note that
  # this assumes that the mariadb-admin command has database access, which it
  # has thanks to the default use of Unix socket authentication for the 'mysql'
  # (or root on Debian) account used everywhere since MariaDB 10.4.
  postrotate
    if test -r /etc/mysql/debian.cnf
    then
      EXTRAPARAM='--defaults-file=/etc/mysql/debian.cnf'
    fi

if test -x /usr/bin/mariadb-admin
    then
      /usr/bin/mariadb-admin $EXTRAPARAM --local flush-error-log \
        flush-engine-log flush-general-log flush-slow-log
    fi
  endscript
}

X7ROOT File Manager

Editing: mariadb.logrotate

Upload File

Create Folder