mysql

How i can change or configurate the memory for MYSQL ?? i have installed MariaDB 10.3.39 and via Docker mysql 5.7.34 Docker show : Ressourcen Memory : 1.7 GB from 31.4 GB

Hi all, I was reading a lot, but still not getting it. Under DB Server I have MySQL 8, and no choice to build new DB as MariaDB...??? In "update" I get only MySQL to install as component. No MariaDB to choice. How can I change to MariaDB, because I want to upgrade Ubuntu18 to 20 with...

I have created a docker container, which runs in my local network at home. One runs on synology, the other on a raspberry pi. I have a database and username which allow remote connections on a database. When i use the container in my synology or my windows computer, i can connect to the database...

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...