Questions tagged [mysql]
An open-source, relational database management system.
1,011 questions
0
votes
2
answers
55
views
What is the correct "mysql-client" package to install in Debian 12?
In Debian Desktop 12 if I want to do a remote connection as client to a MySQL Server in other machine in the LAN I need use the mysql command, when it is executed happens the following:
manueljordan@...
- 2,040
0
votes
0
answers
57
views
Install mysql (not mariadb) on raspbian bookworm and other debian
There are many servers in the network that I manage, and throughout that network, mysql is the standard and only "mysql-like" database used. (There's some postgre but that is another matter)...
- 101
1
vote
1
answer
39
views
How I can allow my user to be connected via `localhost` when I ssh tunnel my Db connection?
In a server that I do not have admin access I managed to make an ssh tunnel as:
ssh -N -L 33308:127.0.0.1:3306 [email protected]
Then I attempt to connect into mysql via the tunnel:
mysql -u testusr -...
- 1,281
0
votes
0
answers
77
views
single node Slurm machine, munge authentication problem
I'm in the process of setting up a singe-node Slurm workstation machine and I believe I followed the process closely and everything is working just fine. See below:
sudo systemctl restart slurmdbd &...
- 199
0
votes
1
answer
60
views
Does a load of 41.20 (!?) suggest a hardware failure?
I have Ubuntu 24.04 on a Raspberry Pi 4 and after months of working fine,
today it has jumped to a load 41 for no apparent reason.
Can't connect to remote MySQL instance from the server.
And gitlab ...
- 259
0
votes
0
answers
51
views
persistent - slurmdbd: error: mysql_query failed: 1193 Unknown system variable 'wsrep_on'
Hi I was working on installing Slurm and got most things sorted out but upon launching
sudo journalctl -fu slurmdbd
I get the following:
Jan 25 12:49:49 ... systemd[1]: Stopped slurmdbd.service - ...
- 199
1
vote
1
answer
55
views
MySQL general_log.CSV is 47GB in Production – How to Free Space?
I’m managing a production MySQL server running on a VM, and I just discovered that the general_log.CSV file in /var/lib/mysql/mysql/ has grown to 47GB, consuming almost 70% of the disk space.
Here’s ...
0
votes
0
answers
81
views
Install MySQL from their repository in Debian 11
I have updated Debian to 11. Mysql sources list still listed buster though. So i tried to reconfigure using mysql-apt-config_0.8.24-1_all.deb which did not help. So i downloaded mysql-apt-config_0.8....
- 665
0
votes
0
answers
18
views
How do I start the system from a vps backup?
I have an Ubuntu VPS backup from which I need to pull MySQL data.
I was trying to install mysql on my Arch linux machine and copy the /var/lib/mysql files from the backup to my system. However, I ran ...
0
votes
1
answer
47
views
What DNS records are needed to ensure pop3 delivery from external mail senders succeeds?
My setup:
Network: Low spec vps server,
Mail server: postfix + dovecot + mysql,
OS: ubuntu 16.04 (to be upgraded once mail config is complete).
I have a single domain (call it mydomain1.com) ...
- 101
1
vote
0
answers
70
views
Error logs filling up with Client AH02027/AH2026: Failed to release SSL session cache lock
My error_log is filling up with tons of entries like:
www.mine.com [Sun Dec 29 09:29:59 2024] [warn] [pid 903933] ssl_engine_mutex.c(105): (22)Invalid argument: [client AH02027: Failed to release SSL ...
- 331
-1
votes
1
answer
62
views
Mysql is closing the connection on Ubuntu
I built a MERN app (used mysql instead of MongoDB)
I deployed it on the VPS (Ubuntu 24.04)
everything seems okay but when I try to check the logs of my backend using pm2 package it gives me kind of ...
0
votes
2
answers
150
views
mysqldump fails constantly - ubuntu 20.04
we recently are being confronted by an error which always occurs now when trying to create a dump of the database running on mysql Ver 8.0.40-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu 20.04)). ...
- 59
1
vote
2
answers
3k
views
mysql-server on debian 12 has no installation candidate?
I have a fresh Debian 12, and I want MySQL 8, not MariaDB. The internet says that's not a problem, but I can't install mysql-server.
What I did:
sudo apt install gnupg
wget https://dev.mysql.com/get/...
- 113
2
votes
3
answers
319
views
Find positions of keyword in GZ'ipped file
I'm trying to identify parts of a MySQL DB that take most space in GZipped dumps that I need to frequently save and restore so that I can archive some tables partially.
I have a suspicion that ...
- 149