mysql

We are suddenly seeing the mariadb usage hit 41% and mysql memory usage spike and stay consistently high at around 60gb out of our 128gb server. Typically this value should be around 30gb day to day but something is causing the memory useage to spike. We havent made any particular changes. If...

I have a WordPress website running on a dedicated server (Plesk Obsidian v18.0.64 and CentOS 7) which I am unable to backup from Plesk (or any other plugin whatsoever). Each time I try to backup the database I get this error: The backup Nov 11, 2024 05:55 PM was created and can be restored...

The error occurred when I wanted to migrate something via Plesk migrator, an error occurred, then I uninstalled the Plesk migrator.A new installation is no longer possible but for all uninstalled components It is possible that the performance booster has changed something in the database.I...

Hi fellow Pleskians, My backups recently started failing a couple days ago. This is the error I am getting: Upon checking the journalctl logs while trying to take a backup, I see that it restarts every couple minutes because it crashes itself. You cna find the log trace on the bottom. As far...

Hello, in the database logs I find this warning. In fact when I create users from the plesk interface I can't choose the password saving method and the passwords are stored with "mysql_native_password". I would like the "caching_sha2_password" plugin to be used by default but I can't do this...

Hello everybody, I need to access to a plesk database of one domain hosted in one server from another domain in another server with plesk. In the destination server (the server where I need to access to de database) I went to Tools & Settings > Database Servers > Settings > and click on the...

I am trying to optimize my ~large dbs (around 150 GB MySQL) to write less to SSD and more to memory, and I am comparing the variables on a Alma Linux 8.10 with Plesk 18.0.38 with MariaDB 10.3.28 vs a Rocky Linux machine with MySQL 8.x without any panel. On Plesk the MySQL status variables...

Hello, Last week I had different 5 plesk servers with the same problem. I see the error "too many connections" in the websites or control panel. All the servers are with Debian 12 and Plesk 18.0.61 #5 Restart mysql does not work. If I execute: I have to wait nearly 30 minutes and after that...

Running Plesk migrator shows: Failed to fetch information from target servers Cause: Command execution failed on the local server with non-zero exit code. command: MYSQL_PWD="$(cat /etc/psa/.psa.shadow)" mysql --silent --skip-column-names -u admin psa -e 'SHOW VARIABLES LIKE '"'"'socket'"'"''...

I have 2 mysql servers (5.7 and 8.3). 5.7 is the default one and 8.3 is the newly setup one. When customer login, he only sees the 5.7 server. There is no 8.3 in the drop-down list. How can I configure so that the customer can see both servers in the drop-down.

I woke up and this server had the my.cnf empty... I have replaced it from another one that I had... and fixed the problems that I had... Any suggestions? Thanks SO Debian 10.13 Producto Plesk Obsidian Versión 18.0.59 Actualización 2, última actualización el 13/Mar/2024 11:46 mysql -V mysql...

Hi, I have had a website created and I am deploying it on my plesk server. Everything is working fine except a data connection. I have been told that the database has to be mysql and on plesk it is using mariaDB which is not compatible with how my website is set up. I don't see an option to...

Dear Plesk forum members, Since Plesk by default doesn't seem to restrict database users to a host / hosts. I know how to set this for new users, and I also know how to alter this setting from the Plesk panel for existing users, but since I have to deal with a lot of existing unrestricted users...

I have a forum which suddenly can no longer connect to mysql. The only thing done was an upgrade which finished succesfully with the database upgrade directly after that the connection was lost. But all the file permissions look right. File owner and group is correct. The mysql settings in the...

Hi, dear community! I've got 30 domains (Plesk Obsidian, version 18.0.57, Web Pro version) I have the following problem with 1 domain: This site and domain initiate problems in SQL queries and when domain operates all MySQL bases will be down on the server (error = "Too many SQL...

Hello, I have tons of registers with this user 'monitoring' trying to log onto the mysql... How can I check where this logging attempts come from? I mean obviously from localhost, as the register itself says, but from what program, cron or whaeteber process or web is doing this... And as far...

Hello, I need to change the location of the directory /var/lib/mysql, but I can't seem to find out how to do it in Linux. I remember that it used to be possible in the past, and it's even mentioned in Plesk's Knowledge Base, but for Windows. Is there a way to do it in Linux? Thank you very...

Hi, I'm attempting to enable MySQL secure connection on 18.0.52 but when I edit panel.ini with tls.enable to true Plesk gives the following fatal error "The localhost is not compatible with enabling a secure connection." This plesk instance is connected to a localhost instance and one remote...

Hey, i want to install Password Pusher (GitHub - pglombardo/PasswordPusher: An application to securely communicate passwords over the web. Passwords automatically expire after a certain number of views and/or time has passed. Track who, what and when.) (MySQL) via docker hub, that works...

Hello, My VPS is hosted to OVH. I can't access my VPS, even via ssh (I insist: even via SSH). I did a snapshot before a mysql update: unfortunately, I couldn't go through with it... When I came back, I couldn't connect anywhere. So I asked for the snapshot to be installed, but it didn't work...