Sie befinden sich im systemd-Journal. Sie können mit aufgerufen werdenjournalctl -u mariadb.service
Wo werden die MySQL-Statusmeldungen / -protokolle gespeichert?
287
KingsInnerSoul
Wenn ich renne, service mysql status
bekomme ich:
mariadb.service - MariaDB 10.1.33 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled) Drop-In: /etc/systemd/system/mariadb.service.d └─migrated-from-my.cnf-settings.conf Active: active (running) since Tue 2018-06-12 16:59:36 EDT; 4min 45s ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Process: 10381 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 10368 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS) Process: 10186 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS) Process: 10180 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 10177 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Main PID: 10338 (mysqld) Status: "Taking your SQL requests now..." CGroup: /system.slice/mariadb.service └─10338 /usr/sbin/mysqld Jun 12 16:59:36 some.fqdm.com mysqld[10338]: 2018-06-12 16:59:36 140338049574848 [Note] InnoDB: Percona XtraDB (h...29464 Jun 12 16:59:36 some.fqdn.com mysqld[10338]: 2018-06-12 16:59:36 140337108481792 [Note] InnoDB: Dumping buffer poo...arted Jun 12 16:59:36 some.fqdn.com mysqld[10338]: 2018-06-12 16:59:36 140338049574848 [Note] Plugin 'FEEDBACK' is disabled. Jun 12 16:59:36 some.fqdn.com mysqld[10338]: 2018-06-12 16:59:36 140338049574848 [Note] Server socket created on IP: '::'. Jun 12 16:59:36 some.fqdn.com mysqld[10338]: 2018-06-12 16:59:36 140338049574848 [Note] Reading of all Master_info...ceded Jun 12 16:59:36 some.fqdn.com mysqld[10338]: 2018-06-12 16:59:36 140338049574848 [Note] Added new Master_info '' t...table Jun 12 16:59:36 some.fqdn.com mysqld[10338]: 2018-06-12 16:59:36 140338049574848 [Note] /usr/sbin/mysqld: ready fo...ions. Jun 12 16:59:36 some.fqdn.com mysqld[10338]: Version: '10.1.33-MariaDB-1~jessie' socket: '/var/run/mysqld/mysqld....ution Jun 12 16:59:36 some.fqdn.com mysqld[10368]: Checking for corrupt, not cleanly closed and upgrade needing tables. Jun 12 16:59:36 some.fqdn.com systemd[1]: Started MariaDB 10.1.33 database server. Hint: Some lines were ellipsized, use -l to show in full. mariadb.service - MariaDB 10.1.33 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled) Drop-In: /etc/systemd/system/mariadb.service.d └─migrated-from-my.cnf-settings.conf Active: active (running) since Tue 2018-06-12 16:59:36 EDT; 4min 45s ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Process: 10381 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 10368 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS) Process: 10186 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS) Process: 10180 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 10177 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Main PID: 10338 (mysqld) Status: "Taking your SQL requests now..." CGroup: /system.slice/mariadb.service └─10338 /usr/sbin/mysqld Jun 12 16:59:36 some.fqdm.com mysqld[10338]: 2018-06-12 16:59:36 140338049574848 [Note] InnoDB: Percona XtraDB (h...29464 Jun 12 16:59:36 some.fqdn.com mysqld[10338]: 2018-06-12 16:59:36 140337108481792 [Note] InnoDB: Dumping buffer poo...arted Jun 12 16:59:36 some.fqdn.com mysqld[10338]: 2018-06-12 16:59:36 140338049574848 [Note] Plugin 'FEEDBACK' is disabled. Jun 12 16:59:36 some.fqdn.com mysqld[10338]: 2018-06-12 16:59:36 140338049574848 [Note] Server socket created on IP: '::'. Jun 12 16:59:36 some.fqdn.com mysqld[10338]: 2018-06-12 16:59:36 140338049574848 [Note] Reading of all Master_info...ceded Jun 12 16:59:36 some.fqdn.com mysqld[10338]: 2018-06-12 16:59:36 140338049574848 [Note] Added new Master_info '' t...table Jun 12 16:59:36 some.fqdn.com mysqld[10338]: 2018-06-12 16:59:36 140338049574848 [Note] /usr/sbin/mysqld: ready fo...ions. Jun 12 16:59:36 some.fqdn.com mysqld[10338]: Version: '10.1.33-MariaDB-1~jessie' socket: '/var/run/mysqld/mysqld....ution Jun 12 16:59:36 some.fqdn.com mysqld[10368]: Checking for corrupt, not cleanly closed and upgrade needing tables. Jun 12 16:59:36 some.fqdn.com systemd[1]: Started MariaDB 10.1.33 database server. Hint: Some lines were ellipsized, use -l to show in full.
Die Frage ist, wo sind die Nachrichten mit dem Zeitstempel? Ich konnte die Protokolldatei nicht finden, wenn überhaupt.
Sie sollten sich in einer Datei mit der Erweiterung ".err" im Datenverzeichnis befinden.
Dave vor 5 Jahren
0
1 Antwort auf die Frage
0
danblack
Verwandte Probleme
-
2
Wie kann ich mein Mikrofon unter Debian GNOME zum Laufen bringen?
-
6
Vollbild-Flash langsam in KDE 4
-
3
Pakete in einem seltsamen Zustand
-
8
Finden Sie, zu welchem Paket eine Datei in Ubuntu / Debian gehört?
-
2
Wie richte ich ein automatisches Login bei Debian (Lenny) ein?
-
1
Amaroks hört nach einem Song auf zu spielen
-
3
Amarok weigert sich, * .ogg-Dateien abzuspielen
-
2
Kopete, um mit GTalk zu arbeiten
-
4
Sendmail-Ersatz auf einem Debian-Heimcomputer
-
4
Wie finden Sie die Ubuntu-Version (Versionsnummer / -name) über die Befehlszeile?