Kein Verbindungsaufbau zu mysql / mariadb Server möglich.

[pfefferminzia]

Hallo miteinander,

ich arbeite mit Linux OpenSuse 15.1 und ich möchte eine Verbindung zum mysql / mariadb server aufbauen.

mysql
ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysql/mysql.sock' (2)

mariadb
ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysql/mysql.sock' (2)

Habe mich durch sämtliche Internet-Tipps durchgearbeitet und keine Lösung finden können.
So weit bin ich gekommen:

An der Firewall liegt es nicht. Wenn ich sie ausschalte macht es keinen Unterschied.
Habe nach Anleitung im Netz diverse Anpassungen an der systemdatei /etc/my.cnf ausprobiert. Auch alles ohne Effekt.
Habe Berechtigungen für /var/lib/mysql/ überprüft.
Es werden keine Log-Files angelegt, darum kann ich nicht reinschauen.
Habe auch nach der fehlenden mysql.sock gesucht. Es gibt sie nicht. Nirgends. Eine künstlich zu erschaffen mit touch hat auch nichts genützt, aber im Netzt heißt es, dass es nicht die Ursache des zu Grunde liegenden Problems sein soll, sondern eine Folge.
Dann war da noch ein Tip innod_force_recovery zu verwenden. Ich habe also mysql innod_force_recovery=1 (und andere zahlen) ausprobiert, aber es blieb bei der Fehlermeldung. Nicht sicher ob ich es richtig benutzt habe...
Habe das Paket mysql-connector-j installiert und JDBKdriver ebenfalls.

journalctl -xeu mariadb.service bringt folgende Rückmeldung

Feb 10 22:37:08 linux.fritz.box mysql-systemd-helper[5166]: MySQL didn't start, can't continue
Feb 10 22:37:08 linux.fritz.box systemd[1]: mariadb.service: Control process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ An ExecStartPre= process belonging to unit mariadb.service has exited.
░░
░░ The process' exit code is 'exited' and its exit status is 1.
Feb 10 22:37:08 linux.fritz.box systemd[1]: mariadb.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Feb 10 22:37:08 linux.fritz.box systemd[1]: Failed to start MariaDB database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ A start job for unit mariadb.service has finished with a failure.
░░
░░ The job identifier is 4138 and the job result is failed.

und das hab ich noch als Rückmeldung

susi@linux:~> sudo systemctl status mysql
[sudo] Passwort für root:
× mariadb.service - MariaDB database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
     Active: failed (Result: exit-code) since Sat 2024-02-10 21:51:01 CET; 34min ago
       Docs: man:mysqld(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 4020 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS)
    Process: 4029 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade (code=exited, status=1/FAILURE)

Feb 10 21:50:00 linux.fritz.box systemd[1]: Starting MariaDB database server...
Feb 10 21:50:00 linux.fritz.box mysql-systemd-helper[4029]: Checking MySQL configuration for obsolete options...
Feb 10 21:50:00 linux.fritz.box mysql-systemd-helper[4029]: Trying to run upgrade of MySQL databases...
Feb 10 21:50:00 linux.fritz.box mysql-systemd-helper[4029]: Running protected MySQL...
Feb 10 21:50:00 linux.fritz.box mysql-systemd-helper[4029]: Waiting for MySQL to start
Feb 10 21:51:01 linux.fritz.box mysql-systemd-helper[4029]: MySQL is still dead
Feb 10 21:51:01 linux.fritz.box mysql-systemd-helper[4029]: MySQL didn't start, can't continue
Feb 10 21:51:01 linux.fritz.box systemd[1]: mariadb.service: Control process exited, code=exited, status=1/FAILURE
Feb 10 21:51:01 linux.fritz.box systemd[1]: mariadb.service: Failed with result 'exit-code'.
Feb 10 21:51:01 linux.fritz.box systemd[1]: Failed to start MariaDB database server.

Nach der Installation von mariadb kam folgende Meldung

You have just installed MariaDB server for the first time.

You can start it via:
 systemctl start mariadb
or
 rcmysql start

During the first start, empty database will be created for you automatically.

PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER!
To do so, start the server and run the following commands:

'/usr/bin/mysqladmin' -u root password 'new-password'
'/usr/bin/mysqladmin' -u root -h <hostname> password 'new-password'

Alternatively you can run:
'/usr/bin/mysql_secure_installation'

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

Aber alle commands führen nur wieder zu der Fehlermeldung
ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysql/mysql.sock' (2)
Und so dreh ich mich im Kreis und weiß nicht weiter.

cat /etc/passwd
...
mysql:x:60:459:MySQL Server:/var/lib/mysql:/bin/false

Steht da etwas hilfreiches drin? Bin zu unerfahren um das deuten zu können...

Folgende Seiten habe ich zu rate gezogen:

Unable to connect to mysql through JDBC connector through Tomcat or externally
Solving a "communications link failure" with JDBC and MySQL
MySQL Server Through Socket /var/run/mysqld/mysqld.sock (2) Error
Missing mysqld.sock file?
Mysql doesn't start mysqld.sock is missing
Missing mysqld.sock file on linux server
What to Do if MySql.sock File is Missing - Hivelocity Hosting
MYSQL Error: 13 (Permission Denied)

Das ist alles was ich dazu habe.

 

[susejunky]

Hallo @pfefferminzia ,

herzlich willkommen im Linux-Club-Forum.

ich arbeite mit Linux OpenSuse 15.1

openSUSE Leap 15.1 wird seit 02/2021 nicht mehr gewartet. Es ist daher ziemlich unwahrscheinlich, dass sich hier im Forum jemand findet, der Dir zu dieser Version weiterhelfen kann.

Bitte verwende eine aktuelle openSUSE-Version (z.B. openSUSE Tumbleweed, openSUSE Leap 15.5, ...).

Viele Grüße

susejunky

 

[pfefferminzia]

Hallo susejunky,
oh - ich hab mich geirrt: Ich arbeite mit OpenSuse 15.5 - habe es vor kurzem erst frisch installiert. Hatte ne falsche Zahl im Kopf. Sorry für die Verwirrung.

 

[susejunky]

Hallo @pfefferminzia ,

Ich arbeite mit OpenSuse 15.5

OK

und das hab ich noch als Rückmeldung

susi@linux:~> sudo systemctl status mysql
[sudo] Passwort für root:
× mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Sat 2024-02-10 21:51:01 CET; 34min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 4020 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS)
Process: 4029 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade (code=exited, status=1/FAILURE)
...

Dein Datenbankserver (mysqld) konnte nicht gestartet werden, also kannst Du Dich auch nicht mit ihm verbinden.

Um das weiter zu untersuchen, wären noch etwas mehr Informationen zu Deinem System hilfreich.

Bitte zeige die Ergebnisse der folgenden Befehle

cat /etc/my.cnf

ls -alR /etc/my*

ls -alR /var/lib/mysql*

ls -alR /var/log/mysql*

lsblk -f

Bitte führe alle Befehle als "root" aus und zeige hier immer die verwendete Befehlszeile, alle Ausgaben und die nächste leere Eingabeaufforderung z.B.:

# uname -a
Linux TRAGFIX 6.7.2-1-default #1 SMP PREEMPT_DYNAMIC Fri Jan 26 11:01:28 UTC 2024 (a52bf76) x86_64 x86_64 x86_64 GNU/Linux
#

Bitte verwende für jeden Befehl einen eigenen Code-Block ("</>"-Schaltfläche im Forumseditor).

Viele Grüße

susejunky

 

[susejunky]

Hallo @pfefferminzia ,

ich habe gerade das hier gefunden.

Es ist verständlich, dass Du Dein Problem schnellstmöglich lösen möchtest und daher alle Dir verfügbaren Quellen „anzapfst“, um zum Ziel zu gelangen.

Aber bitte sei fair:

Ermögliche allen, die Dir helfen wollen, auch den aktuellen Bearbeitungsstand zu Deinem Problem einsehen zu können; d.h. zeige bitte in jedem Forum Querverweise auf die jeweils andere Foren, in denen Du Dein Problem ebenfalls platziert hast.

Viele Grüße

susejunky

 

[Sauerland]

Poste mal:

zypper se -si maria mysql

 

[pfefferminzia]

Aber bitte sei fair:

Ermögliche allen, die Dir helfen wollen, auch den aktuellen Bearbeitungsstand zu Deinem Problem einsehen zu können; d.h. zeige bitte in jedem Forum Querverweise auf die jeweils andere Foren, in denen Du Dein Problem ebenfalls platziert hast.

Ja du hast Recht, das sollte ich tun. Ich hatte einfach noch nicht daran gedacht. Ich habe einfach schon sehr lange keine Frage mehr in ein Forum gestellt und noch nie in mehrere gleichzeitig. Entschuldigung.

Also hier gehts zum Datenbankforum-Thread wo ich ebenfalls diese Frage reingestellt habe.

 

[pfefferminzia]

linux:/home/susi # cat /etc/my.cnf
# The following options will be passed to all MariaDB clients
[client]
# Please note that storing the password in this file is not safe. For this
# purpose you can, for example, list your password in the [client] section
# of the '~/.my.cnf' configuration file with an access mode set to 400 or 600.
 password   = your_password
 port       = 3306
 socket     = /run/mysql/mysql.sock


# The MariaDB server
[mysqld]


# For security reasons, bind to 127.0.0.1 by default to enable networking
# only on the loopback interface.
bind-address=localhost


# If log-error is not set, mysqld will write to "/var/lib/mysql/$HOSTNAME.err"
# which is not beneficial for rotating the log file if it grows in size.
log-error=/var/log/mysql/mysqld.log


# Enable the slow query log to see queries with especially long duration
# slow_query_log=1
# slow_query_log_file = /var/log/mysql/mysqld_slow.log


# Operations 'LOAD DATA', 'SELECT ... INTO' and 'LOAD FILE()' will only
# work with files in the specified directory
secure_file_priv = /var/lib/mysql-files


# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
innodb_buffer_pool_size = 12800M
innod_force_recovery = 1


# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin=mysql-bin
# binlog_format=mixed


# Remove leading # if you want to store your database elsewhere
# datadir    = /var/lib/mysql


# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id    = 1


# These are commonly set, remove the # and set as required.
# port = 3306
# socket = /run/mysql/mysql.sock


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M


# Configure the MariaDB server to use SSL
# ssl-ca=/etc/mysql/ssl/ca-cert.pem
# ssl-cert=/etc/mysql/ssl/server-cert.pem
# ssl-key=/etc/mysql/ssl/server-key.pem


[mysqld_multi]
mysqld     = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log        = /var/log/mysqld_multi.log


# If you want to use mysqld_multi uncomment 1 or more mysqld sections
# below or add your own ones.


# WARNING
# --------
# If you uncomment mysqld1 than make absolutely sure, that database mysql,
# configured above, is not started.  This may result in corrupted data!
#
# [mysqld1]
# port       = 3306
# datadir    = /var/lib/mysql
# pid-file   = /var/lib/mysql/mysqld.pid
# socket     = /var/lib/mysql/mysql.sock
# user       = mysql


# [mysqld2]
# port       = 3307
# datadir    = /var/lib/mysql-databases/mysqld2
# pid-file   = /var/lib/mysql-databases/mysqld2/mysql.pid
# socket     = /var/lib/mysql-databases/mysqld2/mysql.sock
# user       = mysql


# [mysqld3]
# port       = 3308
# datadir    = /var/lib/mysql-databases/mysqld3
# pid-file   = /var/lib/mysql-databases/mysqld3/mysql.pid
# socket     = /var/lib/mysql-databases/mysqld3/mysql.sock
# user       = mysql


# [mysqld6]
# port       = 3309
# datadir    = /var/lib/mysql-databases/mysqld6
# pid-file   = /var/lib/mysql-databases/mysqld6/mysql.pid
# socket     = /var/lib/mysql-databases/mysqld6/mysql.sock
# user       = mysql

!includedir /etc/my.cnf.d
[wait_timeout][1] =10000

interactive_timeout = 10000
connect_timeout = 10000

linux:/home/susi #

 

[pfefferminzia]

linux:/home/susi # ls -alR /etc/my*
-rw-r--r-- 1 root mysql 3537 12. Feb 18:40 /etc/my.cnf
-rw-r----- 1 root mysql 1702 19. Sep 22:03 /etc/mysqlaccess.conf

/etc/my.cnf.d:
insgesamt 0
drwxr-xr-x 1 root mysql    0 19. Sep 22:03 .
drwxr-xr-x 1 root root  5320 12. Feb 18:40 ..
linux:/home/susi #

 

[pfefferminzia]

linux:/home/susi # ls -alR /var/lib/mysql*
/var/lib/mysql:
insgesamt 79304
drwxr-xr-x 1 mysql root       624 12. Feb 18:40 .
drwxr-xr-x 1 root  root       776 10. Feb 23:16 ..
-rw-rw---- 1 mysql mysql    16384 12. Feb 18:40 aria_log.00000001
-rw-rw---- 1 mysql mysql       52 12. Feb 18:40 aria_log_control
-rw-r----- 1 mysql mysql       56  9. Feb 17:01 auto.cnf
-rw-r----- 1 mysql mysql      180  9. Feb 17:09 binlog.000001
-rw-r----- 1 mysql mysql      180  9. Feb 19:25 binlog.000002
-rw-r----- 1 mysql mysql       32  9. Feb 18:35 binlog.index
-rw------- 1 mysql mysql     1676  9. Feb 17:01 ca-key.pem
-rw-r--r-- 1 mysql mysql     1112  9. Feb 17:01 ca.pem
-rw-r--r-- 1 mysql mysql     1112  9. Feb 17:01 client-cert.pem
-rw------- 1 mysql mysql     1680  9. Feb 17:01 client-key.pem
-rw-r----- 1 mysql mysql   196608  9. Feb 18:37 #ib_16384_0.dblwr
-rw-r----- 1 mysql mysql  8585216  9. Feb 17:01 #ib_16384_1.dblwr
-rw-r----- 1 mysql mysql     3427  9. Feb 19:25 ib_buffer_pool
-rw-r----- 1 mysql mysql 12582912  9. Feb 19:25 ibdata1
drwxr-x--- 1 mysql mysql      880  9. Feb 18:35 #innodb_redo
drwxr-x--- 1 mysql mysql        0  9. Feb 19:25 #innodb_temp
drw-rw---- 1 mysql mysql      178  9. Feb 17:01 mysql
-rw-r----- 1 mysql mysql 26214400  9. Feb 18:35 mysql.ibd
drwxr-x--- 1 mysql mysql     5032  9. Feb 17:01 performance_schema
-rw------- 1 mysql mysql     1676  9. Feb 17:01 private_key.pem
-rw-r--r-- 1 mysql mysql      452  9. Feb 17:01 public_key.pem
-rw-r--r-- 1 mysql mysql     1112  9. Feb 17:01 server-cert.pem
-rw------- 1 mysql mysql     1680  9. Feb 17:01 server-key.pem
drwxr-x--- 1 mysql mysql       28  9. Feb 17:01 sys
-rw-r----- 1 mysql mysql 16777216  9. Feb 18:37 undo_001
-rw-r----- 1 mysql mysql 16777216  9. Feb 18:37 undo_002

 

[pfefferminzia]

/var/lib/mysql/#innodb_redo:
insgesamt 102400
drwxr-x--- 1 mysql mysql     880  9. Feb 18:35 .
drwxr-xr-x 1 mysql root      624 12. Feb 18:40 ..
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo10_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo11_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo12_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo13_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo14_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo15_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo16_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo17_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo18_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo19_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo20_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo21_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo22_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo23_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo24_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo25_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo26_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo27_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo28_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo29_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo30_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo31_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo32_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo33_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo34_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo35_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo36_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo37_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:37 #ib_redo6
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo7_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo8_tmp
-rw-r----- 1 mysql mysql 3276800  9. Feb 18:35 #ib_redo9_tmp

 

[pfefferminzia]

/var/lib/mysql/#innodb_temp:
insgesamt 0
drwxr-x--- 1 mysql mysql   0  9. Feb 19:25 .
drwxr-xr-x 1 mysql root  624 12. Feb 18:40 ..


/var/lib/mysql/mysql:
insgesamt 32
drw-rw---- 1 mysql mysql   178  9. Feb 17:01 .
drwxr-xr-x 1 mysql root    624 12. Feb 18:40 ..
-rw-rw---- 1 mysql mysql  5972  9. Feb 17:01 general_log_213.sdi
-rw-rw---- 1 mysql mysql    35  9. Feb 17:01 general_log.CSM
-rw-rw---- 1 mysql mysql     0  9. Feb 17:01 general_log.CSV
-rw-rw---- 1 mysql mysql 12505  9. Feb 17:01 slow_log_214.sdi
-rw-rw---- 1 mysql mysql    35  9. Feb 17:01 slow_log.CSM
-rw-rw---- 1 mysql mysql     0  9. Feb 17:01 slow_log.CSV


/var/lib/mysql/performance_schema:
insgesamt 1640
drwxr-x--- 1 mysql mysql  5032  9. Feb 17:01 .
drwxr-xr-x 1 mysql root    624 12. Feb 18:40 ..
-rw-r----- 1 mysql mysql  6134  9. Feb 17:01 accounts_145.sdi
-rw-r----- 1 mysql mysql 13199  9. Feb 17:01 binary_log_trans_189.sdi
-rw-r----- 1 mysql mysql  3955  9. Feb 17:01 cond_instances_82.sdi
-rw-r----- 1 mysql mysql 16110  9. Feb 17:01 data_locks_160.sdi
-rw-r----- 1 mysql mysql 14116  9. Feb 17:01 data_lock_waits_161.sdi
-rw-r----- 1 mysql mysql  7639  9. Feb 17:01 error_log_83.sdi
-rw-r----- 1 mysql mysql  7663  9. Feb 17:01 events_errors_su_139.sdi
-rw-r----- 1 mysql mysql  7664  9. Feb 17:01 events_errors_su_140.sdi
-rw-r----- 1 mysql mysql  8518  9. Feb 17:01 events_errors_su_141.sdi
-rw-r----- 1 mysql mysql  7694  9. Feb 17:01 events_errors_su_142.sdi
-rw-r----- 1 mysql mysql  6822  9. Feb 17:01 events_errors_su_143.sdi
-rw-r----- 1 mysql mysql 11711  9. Feb 17:01 events_stages_cu_111.sdi
-rw-r----- 1 mysql mysql 11711  9. Feb 17:01 events_stages_hi_112.sdi
-rw-r----- 1 mysql mysql 11270  9. Feb 17:01 events_stages_hi_113.sdi
-rw-r----- 1 mysql mysql  7695  9. Feb 17:01 events_stages_su_114.sdi
-rw-r----- 1 mysql mysql  8521  9. Feb 17:01 events_stages_su_115.sdi
-rw-r----- 1 mysql mysql  7666  9. Feb 17:01 events_stages_su_116.sdi
-rw-r----- 1 mysql mysql  7667  9. Feb 17:01 events_stages_su_117.sdi
-rw-r----- 1 mysql mysql  6820  9. Feb 17:01 events_stages_su_118.sdi
-rw-r----- 1 mysql mysql 38909  9. Feb 17:01 events_statement_119.sdi
-rw-r----- 1 mysql mysql 38909  9. Feb 17:01 events_statement_120.sdi
-rw-r----- 1 mysql mysql 38468  9. Feb 17:01 events_statement_121.sdi
-rw-r----- 1 mysql mysql 26261  9. Feb 17:01 events_statement_122.sdi
-rw-r----- 1 mysql mysql 27088  9. Feb 17:01 events_statement_123.sdi
-rw-r----- 1 mysql mysql 26232  9. Feb 17:01 events_statement_124.sdi
-rw-r----- 1 mysql mysql 26233  9. Feb 17:01 events_statement_125.sdi
-rw-r----- 1 mysql mysql 25385  9. Feb 17:01 events_statement_126.sdi
-rw-r----- 1 mysql mysql 32719  9. Feb 17:01 events_statement_127.sdi
-rw-r----- 1 mysql mysql 31346  9. Feb 17:01 events_statement_128.sdi
-rw-r----- 1 mysql mysql  6125  9. Feb 17:01 events_statement_129.sdi
-rw-r----- 1 mysql mysql  7847  9. Feb 17:01 events_statement_130.sdi
-rw-r----- 1 mysql mysql 21447  9. Feb 17:01 events_transacti_131.sdi
-rw-r----- 1 mysql mysql 21447  9. Feb 17:01 events_transacti_132.sdi
-rw-r----- 1 mysql mysql 21006  9. Feb 17:01 events_transacti_133.sdi
-rw-r----- 1 mysql mysql 15786  9. Feb 17:01 events_transacti_134.sdi
-rw-r----- 1 mysql mysql 16613  9. Feb 17:01 events_transacti_135.sdi
-rw-r----- 1 mysql mysql 15757  9. Feb 17:01 events_transacti_136.sdi
-rw-r----- 1 mysql mysql 15758  9. Feb 17:01 events_transacti_137.sdi
-rw-r----- 1 mysql mysql 14910  9. Feb 17:01 events_transacti_138.sdi
-rw-r----- 1 mysql mysql 17384  9. Feb 17:01 events_waits_cur_84.sdi
-rw-r----- 1 mysql mysql 17384  9. Feb 17:01 events_waits_his_85.sdi
-rw-r----- 1 mysql mysql 16943  9. Feb 17:01 events_waits_his_86.sdi
-rw-r----- 1 mysql mysql  7666  9. Feb 17:01 events_waits_sum_87.sdi
-rw-r----- 1 mysql mysql  7996  9. Feb 17:01 events_waits_sum_88.sdi
-rw-r----- 1 mysql mysql  7694  9. Feb 17:01 events_waits_sum_89.sdi
-rw-r----- 1 mysql mysql  7665  9. Feb 17:01 events_waits_sum_90.sdi
-rw-r----- 1 mysql mysql  8520  9. Feb 17:01 events_waits_sum_91.sdi
-rw-r----- 1 mysql mysql  6819  9. Feb 17:01 events_waits_sum_92.sdi
-rw-r----- 1 mysql mysql  7543  9. Feb 17:01 file_instances_93.sdi
-rw-r----- 1 mysql mysql 20467  9. Feb 17:01 file_summary_by__94.sdi
-rw-r----- 1 mysql mysql 25622  9. Feb 17:01 file_summary_by__95.sdi
-rw-r----- 1 mysql mysql  3218  9. Feb 17:01 global_status_181.sdi
-rw-r----- 1 mysql mysql  3221  9. Feb 17:01 global_variables_184.sdi
-rw-r----- 1 mysql mysql 25310  9. Feb 17:01 host_cache_96.sdi
-rw-r----- 1 mysql mysql  5280  9. Feb 17:01 hosts_146.sdi
-rw-r----- 1 mysql mysql  9509  9. Feb 17:01 keyring_componen_191.sdi
-rw-r----- 1 mysql mysql  4663  9. Feb 17:01 keyring_keys_152.sdi
-rw-r----- 1 mysql mysql  4283  9. Feb 17:01 log_status_174.sdi
-rw-r----- 1 mysql mysql 12543  9. Feb 17:01 memory_summary_b_154.sdi
-rw-r----- 1 mysql mysql 11688  9. Feb 17:01 memory_summary_b_155.sdi
-rw-r----- 1 mysql mysql 11716  9. Feb 17:01 memory_summary_b_156.sdi
-rw-r----- 1 mysql mysql 11687  9. Feb 17:01 memory_summary_b_157.sdi
-rw-r----- 1 mysql mysql 10840  9. Feb 17:01 memory_summary_g_153.sdi
-rw-r----- 1 mysql mysql 11897  9. Feb 17:01 metadata_locks_159.sdi
-rw-r----- 1 mysql mysql  5136  9. Feb 17:01 mutex_instances_97.sdi
-rw-r----- 1 mysql mysql  7822  9. Feb 17:01 objects_summary__98.sdi
-rw-r----- 1 mysql mysql  4293  9. Feb 17:01 performance_time_99.sdi
-rw-r----- 1 mysql mysql  3224  9. Feb 17:01 persisted_variab_187.sdi
-rw-r----- 1 mysql mysql 35510  9. Feb 17:01 prepared_stateme_175.sdi
-rw-r----- 1 mysql mysql  8385  9. Feb 17:01 processlist_100.sdi
-rw-r----- 1 mysql mysql  8225  9. Feb 17:01 replication_appl_165.sdi
-rw-r----- 1 mysql mysql  4886  9. Feb 17:01 replication_appl_166.sdi
-rw-r----- 1 mysql mysql 19879  9. Feb 17:01 replication_appl_167.sdi
-rw-r----- 1 mysql mysql 27360  9. Feb 17:01 replication_appl_168.sdi
-rw-r----- 1 mysql mysql  6730  9. Feb 17:01 replication_appl_170.sdi
-rw-r----- 1 mysql mysql  4601  9. Feb 17:01 replication_appl_171.sdi
-rw-r----- 1 mysql mysql  7243  9. Feb 17:01 replication_asyn_172.sdi
-rw-r----- 1 mysql mysql  5317  9. Feb 17:01 replication_asyn_173.sdi
-rw-r----- 1 mysql mysql 46221  9. Feb 17:01 replication_conn_162.sdi
-rw-r----- 1 mysql mysql 24348  9. Feb 17:01 replication_conn_164.sdi
-rw-r----- 1 mysql mysql  9488  9. Feb 17:01 replication_grou_163.sdi
-rw-r----- 1 mysql mysql 12356  9. Feb 17:01 replication_grou_169.sdi
-rw-r----- 1 mysql mysql  5951  9. Feb 17:01 rwlock_instances_101.sdi
-rw-r----- 1 mysql mysql  4703  9. Feb 17:01 session_account__151.sdi
-rw-r----- 1 mysql mysql  4695  9. Feb 17:01 session_connect__150.sdi
-rw-r----- 1 mysql mysql  3219  9. Feb 17:01 session_status_182.sdi
-rw-r----- 1 mysql mysql  3222  9. Feb 17:01 session_variable_185.sdi
-rw-r----- 1 mysql mysql  6159  9. Feb 17:01 setup_actors_102.sdi
-rw-r----- 1 mysql mysql  3261  9. Feb 17:01 setup_consumers_103.sdi
-rw-r----- 1 mysql mysql  7937  9. Feb 17:01 setup_instrument_104.sdi
-rw-r----- 1 mysql mysql  6406  9. Feb 17:01 setup_objects_105.sdi
-rw-r----- 1 mysql mysql  6890  9. Feb 17:01 setup_threads_106.sdi
-rw-r----- 1 mysql mysql  9110  9. Feb 17:01 socket_instances_147.sdi
-rw-r----- 1 mysql mysql 21670  9. Feb 17:01 socket_summary_b_148.sdi
-rw-r----- 1 mysql mysql 20485  9. Feb 17:01 socket_summary_b_149.sdi
-rw-r----- 1 mysql mysql  4919  9. Feb 17:01 status_by_accoun_177.sdi
-rw-r----- 1 mysql mysql  4065  9. Feb 17:01 status_by_host_178.sdi
-rw-r----- 1 mysql mysql  4093  9. Feb 17:01 status_by_thread_179.sdi
-rw-r----- 1 mysql mysql  4064  9. Feb 17:01 status_by_user_180.sdi
-rw-r----- 1 mysql mysql  9649  9. Feb 17:01 table_handles_158.sdi
-rw-r----- 1 mysql mysql 32824  9. Feb 17:01 table_io_waits_s_107.sdi
-rw-r----- 1 mysql mysql 31958  9. Feb 17:01 table_io_waits_s_108.sdi
-rw-r----- 1 mysql mysql 56631  9. Feb 17:01 table_lock_waits_109.sdi
-rw-r----- 1 mysql mysql 23643  9. Feb 17:01 threads_110.sdi
-rw-r----- 1 mysql mysql 15893  9. Feb 17:01 tls_channel_stat_190.sdi
-rw-r----- 1 mysql mysql  5791  9. Feb 17:01 user_defined_fun_188.sdi
-rw-r----- 1 mysql mysql  5279  9. Feb 17:01 users_144.sdi
-rw-r----- 1 mysql mysql  4100  9. Feb 17:01 user_variables_b_176.sdi
-rw-r----- 1 mysql mysql  4096  9. Feb 17:01 variables_by_thr_183.sdi
-rw-r----- 1 mysql mysql  7960  9. Feb 17:01 variables_info_186.sdi

 

[pfefferminzia]

/var/lib/mysql/sys:
insgesamt 112
drwxr-x--- 1 mysql mysql     28  9. Feb 17:01 .
drwxr-xr-x 1 mysql root     624 12. Feb 18:40 ..
-rw-r----- 1 mysql mysql 114688  9. Feb 17:01 sys_config.ibd


/var/lib/mysql-files:
insgesamt 0
drwxr-x--- 1 mysql mysql   0 19. Sep 22:03 .
drwxr-xr-x 1 root  root  776 10. Feb 23:16 ..


/var/lib/mysql.old:
insgesamt 79304
drwxr-x--x 1 root root      624 10. Feb 23:16 .
drwxr-xr-x 1 root root      776 10. Feb 23:16 ..
-rw-r----- 1 root root    16384 10. Feb 23:16 aria_log.00000001
-rw-r----- 1 root root       52 10. Feb 23:16 aria_log_control
-rw-r----- 1 root root       56 10. Feb 23:16 auto.cnf
-rw-r----- 1 root root      180 10. Feb 23:16 binlog.000001
-rw-r----- 1 root root      180 10. Feb 23:16 binlog.000002
-rw-r----- 1 root root       32 10. Feb 23:16 binlog.index
-rw------- 1 root root     1676 10. Feb 23:16 ca-key.pem
-rw-r--r-- 1 root root     1112 10. Feb 23:16 ca.pem
-rw-r--r-- 1 root root     1112 10. Feb 23:16 client-cert.pem
-rw------- 1 root root     1680 10. Feb 23:16 client-key.pem
-rw-r----- 1 root root   196608 10. Feb 23:16 #ib_16384_0.dblwr
-rw-r----- 1 root root  8585216 10. Feb 23:16 #ib_16384_1.dblwr
-rw-r----- 1 root root     3427 10. Feb 23:16 ib_buffer_pool
-rw-r----- 1 root root 12582912 10. Feb 23:16 ibdata1
drwxr-x--- 1 root root      880 10. Feb 23:16 #innodb_redo
drwxr-x--- 1 root root        0 10. Feb 23:16 #innodb_temp
drwxr-x--- 1 root root      178 10. Feb 23:16 mysql
-rw-r----- 1 root root 26214400 10. Feb 23:16 mysql.ibd
drwxr-x--- 1 root root     5032 10. Feb 23:16 performance_schema
-rw------- 1 root root     1676 10. Feb 23:16 private_key.pem
-rw-r--r-- 1 root root      452 10. Feb 23:16 public_key.pem
-rw-r--r-- 1 root root     1112 10. Feb 23:16 server-cert.pem
-rw------- 1 root root     1680 10. Feb 23:16 server-key.pem
drwxr-x--- 1 root root       28 10. Feb 23:16 sys
-rw-r----- 1 root root 16777216 10. Feb 23:16 undo_001
-rw-r----- 1 root root 16777216 10. Feb 23:16 undo_002


/var/lib/mysql.old/#innodb_redo:
insgesamt 102400
drwxr-x--- 1 root root     880 10. Feb 23:16 .
drwxr-x--x 1 root root     624 10. Feb 23:16 ..
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo10_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo11_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo12_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo13_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo14_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo15_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo16_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo17_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo18_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo19_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo20_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo21_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo22_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo23_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo24_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo25_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo26_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo27_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo28_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo29_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo30_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo31_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo32_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo33_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo34_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo35_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo36_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo37_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo6
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo7_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo8_tmp
-rw-r----- 1 root root 3276800 10. Feb 23:16 #ib_redo9_tmp


/var/lib/mysql.old/#innodb_temp:
insgesamt 0
drwxr-x--- 1 root root   0 10. Feb 23:16 .
drwxr-x--x 1 root root 624 10. Feb 23:16 ..


/var/lib/mysql.old/mysql:
insgesamt 32
drwxr-x--- 1 root root   178 10. Feb 23:16 .
drwxr-x--x 1 root root   624 10. Feb 23:16 ..
-rw-r----- 1 root root  5972 10. Feb 23:16 general_log_213.sdi
-rw-r----- 1 root root    35 10. Feb 23:16 general_log.CSM
-rw-r----- 1 root root     0 10. Feb 23:16 general_log.CSV
-rw-r----- 1 root root 12505 10. Feb 23:16 slow_log_214.sdi
-rw-r----- 1 root root    35 10. Feb 23:16 slow_log.CSM
-rw-r----- 1 root root     0 10. Feb 23:16 slow_log.CSV

 

[pfefferminzia]

/var/lib/mysql.old/performance_schema:
insgesamt 1640
drwxr-x--- 1 root root  5032 10. Feb 23:16 .
drwxr-x--x 1 root root   624 10. Feb 23:16 ..
-rw-r----- 1 root root  6134 10. Feb 23:16 accounts_145.sdi
-rw-r----- 1 root root 13199 10. Feb 23:16 binary_log_trans_189.sdi
-rw-r----- 1 root root  3955 10. Feb 23:16 cond_instances_82.sdi
-rw-r----- 1 root root 16110 10. Feb 23:16 data_locks_160.sdi
-rw-r----- 1 root root 14116 10. Feb 23:16 data_lock_waits_161.sdi
-rw-r----- 1 root root  7639 10. Feb 23:16 error_log_83.sdi
-rw-r----- 1 root root  7663 10. Feb 23:16 events_errors_su_139.sdi
-rw-r----- 1 root root  7664 10. Feb 23:16 events_errors_su_140.sdi
-rw-r----- 1 root root  8518 10. Feb 23:16 events_errors_su_141.sdi
-rw-r----- 1 root root  7694 10. Feb 23:16 events_errors_su_142.sdi
-rw-r----- 1 root root  6822 10. Feb 23:16 events_errors_su_143.sdi
-rw-r----- 1 root root 11711 10. Feb 23:16 events_stages_cu_111.sdi
-rw-r----- 1 root root 11711 10. Feb 23:16 events_stages_hi_112.sdi
-rw-r----- 1 root root 11270 10. Feb 23:16 events_stages_hi_113.sdi
-rw-r----- 1 root root  7695 10. Feb 23:16 events_stages_su_114.sdi
-rw-r----- 1 root root  8521 10. Feb 23:16 events_stages_su_115.sdi
-rw-r----- 1 root root  7666 10. Feb 23:16 events_stages_su_116.sdi
-rw-r----- 1 root root  7667 10. Feb 23:16 events_stages_su_117.sdi
-rw-r----- 1 root root  6820 10. Feb 23:16 events_stages_su_118.sdi
-rw-r----- 1 root root 38909 10. Feb 23:16 events_statement_119.sdi
-rw-r----- 1 root root 38909 10. Feb 23:16 events_statement_120.sdi
-rw-r----- 1 root root 38468 10. Feb 23:16 events_statement_121.sdi
-rw-r----- 1 root root 26261 10. Feb 23:16 events_statement_122.sdi
-rw-r----- 1 root root 27088 10. Feb 23:16 events_statement_123.sdi
-rw-r----- 1 root root 26232 10. Feb 23:16 events_statement_124.sdi
-rw-r----- 1 root root 26233 10. Feb 23:16 events_statement_125.sdi
-rw-r----- 1 root root 25385 10. Feb 23:16 events_statement_126.sdi
-rw-r----- 1 root root 32719 10. Feb 23:16 events_statement_127.sdi
-rw-r----- 1 root root 31346 10. Feb 23:16 events_statement_128.sdi
-rw-r----- 1 root root  6125 10. Feb 23:16 events_statement_129.sdi
-rw-r----- 1 root root  7847 10. Feb 23:16 events_statement_130.sdi
-rw-r----- 1 root root 21447 10. Feb 23:16 events_transacti_131.sdi
-rw-r----- 1 root root 21447 10. Feb 23:16 events_transacti_132.sdi
-rw-r----- 1 root root 21006 10. Feb 23:16 events_transacti_133.sdi
-rw-r----- 1 root root 15786 10. Feb 23:16 events_transacti_134.sdi
-rw-r----- 1 root root 16613 10. Feb 23:16 events_transacti_135.sdi
-rw-r----- 1 root root 15757 10. Feb 23:16 events_transacti_136.sdi
-rw-r----- 1 root root 15758 10. Feb 23:16 events_transacti_137.sdi
-rw-r----- 1 root root 14910 10. Feb 23:16 events_transacti_138.sdi
-rw-r----- 1 root root 17384 10. Feb 23:16 events_waits_cur_84.sdi
-rw-r----- 1 root root 17384 10. Feb 23:16 events_waits_his_85.sdi
-rw-r----- 1 root root 16943 10. Feb 23:16 events_waits_his_86.sdi
-rw-r----- 1 root root  7666 10. Feb 23:16 events_waits_sum_87.sdi
-rw-r----- 1 root root  7996 10. Feb 23:16 events_waits_sum_88.sdi
-rw-r----- 1 root root  7694 10. Feb 23:16 events_waits_sum_89.sdi
-rw-r----- 1 root root  7665 10. Feb 23:16 events_waits_sum_90.sdi
-rw-r----- 1 root root  8520 10. Feb 23:16 events_waits_sum_91.sdi
-rw-r----- 1 root root  6819 10. Feb 23:16 events_waits_sum_92.sdi
-rw-r----- 1 root root  7543 10. Feb 23:16 file_instances_93.sdi
-rw-r----- 1 root root 20467 10. Feb 23:16 file_summary_by__94.sdi
-rw-r----- 1 root root 25622 10. Feb 23:16 file_summary_by__95.sdi
-rw-r----- 1 root root  3218 10. Feb 23:16 global_status_181.sdi
-rw-r----- 1 root root  3221 10. Feb 23:16 global_variables_184.sdi
-rw-r----- 1 root root 25310 10. Feb 23:16 host_cache_96.sdi
-rw-r----- 1 root root  5280 10. Feb 23:16 hosts_146.sdi
-rw-r----- 1 root root  9509 10. Feb 23:16 keyring_componen_191.sdi
-rw-r----- 1 root root  4663 10. Feb 23:16 keyring_keys_152.sdi
-rw-r----- 1 root root  4283 10. Feb 23:16 log_status_174.sdi
-rw-r----- 1 root root 12543 10. Feb 23:16 memory_summary_b_154.sdi
-rw-r----- 1 root root 11688 10. Feb 23:16 memory_summary_b_155.sdi
-rw-r----- 1 root root 11716 10. Feb 23:16 memory_summary_b_156.sdi
-rw-r----- 1 root root 11687 10. Feb 23:16 memory_summary_b_157.sdi
-rw-r----- 1 root root 10840 10. Feb 23:16 memory_summary_g_153.sdi
-rw-r----- 1 root root 11897 10. Feb 23:16 metadata_locks_159.sdi
-rw-r----- 1 root root  5136 10. Feb 23:16 mutex_instances_97.sdi
-rw-r----- 1 root root  7822 10. Feb 23:16 objects_summary__98.sdi
-rw-r----- 1 root root  4293 10. Feb 23:16 performance_time_99.sdi
-rw-r----- 1 root root  3224 10. Feb 23:16 persisted_variab_187.sdi
-rw-r----- 1 root root 35510 10. Feb 23:16 prepared_stateme_175.sdi
-rw-r----- 1 root root  8385 10. Feb 23:16 processlist_100.sdi
-rw-r----- 1 root root  8225 10. Feb 23:16 replication_appl_165.sdi
-rw-r----- 1 root root  4886 10. Feb 23:16 replication_appl_166.sdi
-rw-r----- 1 root root 19879 10. Feb 23:16 replication_appl_167.sdi
-rw-r----- 1 root root 27360 10. Feb 23:16 replication_appl_168.sdi
-rw-r----- 1 root root  6730 10. Feb 23:16 replication_appl_170.sdi
-rw-r----- 1 root root  4601 10. Feb 23:16 replication_appl_171.sdi
-rw-r----- 1 root root  7243 10. Feb 23:16 replication_asyn_172.sdi
-rw-r----- 1 root root  5317 10. Feb 23:16 replication_asyn_173.sdi
-rw-r----- 1 root root 46221 10. Feb 23:16 replication_conn_162.sdi
-rw-r----- 1 root root 24348 10. Feb 23:16 replication_conn_164.sdi
-rw-r----- 1 root root  9488 10. Feb 23:16 replication_grou_163.sdi
-rw-r----- 1 root root 12356 10. Feb 23:16 replication_grou_169.sdi
-rw-r----- 1 root root  5951 10. Feb 23:16 rwlock_instances_101.sdi
-rw-r----- 1 root root  4703 10. Feb 23:16 session_account__151.sdi
-rw-r----- 1 root root  4695 10. Feb 23:16 session_connect__150.sdi
-rw-r----- 1 root root  3219 10. Feb 23:16 session_status_182.sdi
-rw-r----- 1 root root  3222 10. Feb 23:16 session_variable_185.sdi
-rw-r----- 1 root root  6159 10. Feb 23:16 setup_actors_102.sdi
-rw-r----- 1 root root  3261 10. Feb 23:16 setup_consumers_103.sdi
-rw-r----- 1 root root  7937 10. Feb 23:16 setup_instrument_104.sdi
-rw-r----- 1 root root  6406 10. Feb 23:16 setup_objects_105.sdi
-rw-r----- 1 root root  6890 10. Feb 23:16 setup_threads_106.sdi
-rw-r----- 1 root root  9110 10. Feb 23:16 socket_instances_147.sdi
-rw-r----- 1 root root 21670 10. Feb 23:16 socket_summary_b_148.sdi
-rw-r----- 1 root root 20485 10. Feb 23:16 socket_summary_b_149.sdi
-rw-r----- 1 root root  4919 10. Feb 23:16 status_by_accoun_177.sdi
-rw-r----- 1 root root  4065 10. Feb 23:16 status_by_host_178.sdi
-rw-r----- 1 root root  4093 10. Feb 23:16 status_by_thread_179.sdi
-rw-r----- 1 root root  4064 10. Feb 23:16 status_by_user_180.sdi
-rw-r----- 1 root root  9649 10. Feb 23:16 table_handles_158.sdi
-rw-r----- 1 root root 32824 10. Feb 23:16 table_io_waits_s_107.sdi
-rw-r----- 1 root root 31958 10. Feb 23:16 table_io_waits_s_108.sdi
-rw-r----- 1 root root 56631 10. Feb 23:16 table_lock_waits_109.sdi
-rw-r----- 1 root root 23643 10. Feb 23:16 threads_110.sdi
-rw-r----- 1 root root 15893 10. Feb 23:16 tls_channel_stat_190.sdi
-rw-r----- 1 root root  5791 10. Feb 23:16 user_defined_fun_188.sdi
-rw-r----- 1 root root  5279 10. Feb 23:16 users_144.sdi
-rw-r----- 1 root root  4100 10. Feb 23:16 user_variables_b_176.sdi
-rw-r----- 1 root root  4096 10. Feb 23:16 variables_by_thr_183.sdi
-rw-r----- 1 root root  7960 10. Feb 23:16 variables_info_186.sdi

 

[pfefferminzia]

linux:/home/susi # lsblk -f
NAME  FSTYPE FSVER LABEL UUID                                 FSAVAIL FSUSE% MOUNTPOINTS
sda                                                                         
├─sda1
│                                                                           
├─sda2
│     vfat   FAT32       438D-D87B                                           
├─sda3
│                                                                           
├─sda4
│     btrfs              c4f969f5-3a76-4a80-a647-513a89070a3e   12,6G    54% /usr/local
│                                                                            /var
│                                                                            /tmp
│                                                                            /srv
│                                                                            /root
│                                                                            /opt
│                                                                            /boot/grub2/x86_64-efi
│                                                                            /boot/grub2/i386-pc
│                                                                            /
├─sda5
│     ext2   1.0         ca3b4596-191b-47d6-92f8-e0efb5959cd7   66,2G     6% /home
└─sda6
      swap   1           405cc751-a5c2-4192-8fe0-758c0388ced1                [SWAP]
linux:/home/susi #

 

[Fex]

CODE]linux:/home/susi # cat /etc/my.cnf
# The following options will be passed to all MariaDB clients
[client]
# Please note that storing the password in this file is not safe. For this
# purpose you can, for example, list your password in the [client] section
# of the '~/.my.cnf' configuration file with an access mode set to 400 or 600.
password = your_password #gehe davon aus, dass das nicht dein PW ist; einmal auskommentieren
port = 3306
socket = /run/mysql/mysql.sock

vermute, dass das nicht dein root-PW ist
Starte einmal die DB mit systemctl start mariadb & und poste die Systemausgabe.

 

[pfefferminzia]

susi@linux:~> systemctl start mariadb &
[3] 4732
susi@linux:~> Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.

[2] Exit 1 systemctl start mariadb
[3]- Exit 1 systemctl start mariadb
susi@linux:~>

 

[susejunky]

Hallo @pfefferminzia ,

vorab zu Deiner Information: Ich verwende openSUSE Tumbleweed. Es besteht somit die Möglichkeit, dass einiges/alles (?) was ich nachfolgend sage, für Dein System nicht zutrifft.

Auf meinem System existiert ein Benutzer mysql, welcher auch einer Gruppe mysql angehört:

# id mysql
uid=60(mysql) gid=472(mysql) Gruppen=472(mysql)
#

Bei dem Datenbankverzeichnis auf meinem System sind andere Zugriffsrechte gesetzt, als das bei Deinem System der Fall ist:

Dein System:

linux:/home/susi # ls -alR /var/lib/mysql*
/var/lib/mysql:
insgesamt 79304
drwxr-xr-x 1 mysql root       624 12. Feb 18:40 .
drwxr-xr-x 1 root  root       776 10. Feb 23:16 ..
...

Mein System:

# ls -al /var/lib/mysql*
insgesamt 8
drwxr-x---  2 mysql mysql 4096  2. Feb 21:33 .
drwxr-xr-x 58 root  root  4096  2. Feb 17:16 ..
...
#

Möglicherweise kann ein

chown mysql:mysql /var/lib/mysql

zur Lösung Deines Problems beitragen.

Viele Grüße

susejunky

 

[bmk]

Hallo pfefferminzia,

in deiner /etc/my.cnf ist mir aufgefallen:

bind-address=localhost

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
innodb_buffer_pool_size = 12800M
innod_force_recovery = 1

bei mir steht

bind-address = 127.0.0.1

Ich denke, ob localhost oder dediz. IP-Adresse solle egal sein

Ist innodb_buffer_pool_size = 12800M wirklich so gewollt (12.8 GB) ??

Bei innod_force_recovery = 1 fehlt das b bei innodb, diese Option habe ich noch nie verwendet, sie sollte nur in Ausnahmefällen verwendet werden:

Only set innodb_force_recovery to a value greater than 0 in an emergency situation

Grüße bmk

 

[Fex]

Kannst du einmal die Installationsübersicht,wie in #6 angegeben, ausgeben.

Poste mal:

zypper se -si maria mysql