mariadb

Hi all, I want to log slow queries from Mariab (Plesk Onyx 17.8 - 5.5.60-MariaDB version 10). I have updated the file /etc/my.cnf with: slow_query_log = 1 log-slow-queries = /var/log/mysql-slow.log long_query_time = 2 And after restarted Mariadb: #service mariadb restart All like that: How...

Hi! I have installed MariaDB 10.4.0 from Docker. But in customers accounts (Log In as Customer) I can add only default mysql 10.1.37. see screenshot please How can I add docker-installed MariaDB 10.4 for my customers ?

Hello guys, we need your help. We can not access plesk. Server Error 500 Zend_Db_Adapter_Exception SQLSTATE[HY000] [2002] No such file or directory Type Zend_Db_Adapter_Exception Message SQLSTATE[HY000] [2002] No such file or directory File Abstract.php Line 144 But plesk repair does not...

I'm using MariaDB 10.3.9. I am troubled because the setting value of table_open_cache in /etc/my.cnf is not setted. I'm enter the mysql with "mysql -uadmin -p`cat /etc/psa/.psa.shadow`". If I run it with "set global table_open_cache = XXX;" the setting will be setted. I check the value of that...

Does "mysqld.service" exist in Plesk (17.8.11)? At least it currently does not exist on my server. When asking a certain person, I was told that MariaDB should also have mysqld.service. mysqld.service does not exist because I am using Plesk? I installed a database search program from rpm. Then...

CentOS 7 is shipped with MariaDB. MariaDB 10.x version is a drop-in replacement for MySQL 5.5-5.7. Open the SSH terminal by the root user and/or sudo with your username if you have rights to upgrade: Domain / IP adress : Portnumber : Username & Password Create a backup of all databases with...

Dear pleskers! Love your forum and platform. Plesk is my main server manager and I totally love it. Unfortunately there are some things that are different when considering plesk installed. I got a new server with couple of websites on it (im providing hosting). It hosts big woo commerce...

I am trying to migrate a huge website from cpanel to plesk. This website is a WordPress multisite that allows users to create their own blog. Wordpress multisite create new tables for each new user and blog, this is how it works. I have set open-files-limit to 65535 on both servers but I am...

Hi , since nowadays centos7 comes out with MariaDB 5.5 so any plesk I installed on centos7 , it is already binded with mariadb how can I switch to Percona or Mysql ? because all I googled out is about change from mysql to mariadb, no vice versa.

Hi, what are you using on yours servers, MariaDB or MySQL and why?

Hello In mariadb log file I see this errors: 171021 10:38:35 [ERROR] Can't create IP socket: Success 171021 10:38:35 [ERROR] Aborting I use Plesk Onyx 17.5.3 and mariadb 5.5.56.

As the thread title says really but we can't We suspect this MAY be linked back to the MySql / Maria DB setup... We want to ensure that if/when on the rare occasions that Roundcube is used, it's via https only. Post_#6 in that previous thread clearly explains how to do this. However, in our...

Hi, i've this version plesk 17.5.3 patch #26 installed on a centos 7.4.1708 and this morning i've realized that mariadb service is down because of this : Oct 24 11:01:50 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:50 139851548907648 [Note] InnoDB: Starting shutdown... Oct 24 11:01:51...

Hello. Server Details: OS: ‪CentOS Linux 7.3.1611 (Core)‬ Product: Plesk Onyx Version 17.5.3 Update #19 Mariadb: 5.5.52-MariaDB I am trying to upgrade mysql using this link How to upgrade MySQL 5.5 to 5.6/5.7 on Linux but I am getting this error when I run "yum install mariadb" Error...

Hi I'm new to this forum. Just turned from cPanel to Plesk and I'm loving it. Anyway, I managed to Install Onyx on CentOS7 with no problem and the forum really helped. I was trying to secure my installation so I did not know Plesk changed root to admin so I updated admin user's password and my...

Hi Everyone, I've seen on various best practices websites that people are recommending mariadb10 now over 5 (which is pre-installed on Plesk. Is there any real benefits and how easy is it to upgrade?

Hi all, I tried to run "mysql_secure_installation" command on my server where Onyx is running but I always get login error because the Onyx default db user is admin and not root: I also tried to run: "mysql_secure_installation -uadmin" but with no success. Can anyone help me on this and tell...

Hi all, We have a dedicated Centos 7.3 server which came with Plesk Onyx 17.5.3 and MariaDB. We followed this guide: Database Server to change the DB to Percona. The only step that wasn't carried out was the re-installation of Plesk, which seems to have been an optional step. Everything...

Tip to everyone: Plesk itself uses mysql. Dont fool around if you're not sure what you're doing! You might mess up your installation. EDIT 7 june 2017: Do not follow up with code posted below here! If I find out the proper way I will post it! just messed up my server! ...which is the reason...

Hello experts, I checked the search function of the forum and google. So far I couldn't resolve my issue. I would would like to switch to mariaDB and planned to do so after updating to Plesk 17.5 which I run on Ubuntu 16.04 LTS. I followed this Instruction Database Server Including step...