Mariadb | GalaxyData Community

All posts tagged "mariadb"

  • Database
    HOW TO UPGRADE MARIADB 5.5 TO MARIADB 10.3 ON CENTOS 7.5 (1804)

    1. MAKE SURE YOU’RE RUNNING MARIADB 5.5 Run the following command:   Should output the following:   Perfect, let’s keep going!   2. ADD THE MARIADB 10.3 REPOSITORY Run the following command to add the MariaDB 10.3 repository to yum:   Paste the following into the editor  ...

  • Linux
    MariaDB 10.3 [ERROR] mysqld: Can’t create/write to file ‘/var/run/mysqld/mysqld.pid’ (Errcode: 2 «No such file or directory»)

    Появяилась новая проблема на CentOS 7, при установке MariaDB 10.3 — Как обновить Временное решение проблемы: Добавить код: Включить новую службу в systemd Перезапустите сервер или mariadb   Source https://felix90.ru/2018/01/error-mysqld-cant-createwrite-to-file-varrunmysqldmysqld-pid-errcode-2-no-such-file-or-directory/

  • Application
    Увеличение лимита open-files-limit в MariaDB on CentOS 7 с помощью systemd

    Gone are the days where simply changing /etc/my.cnf would be sufficient. Enter the new systemd world. systemd itself has a limit that controls how many files a service can open, regardless if what you configure in /etc/my.cnf or /etc/security/limits.conf. To increase the open files limit in MariaDB running on a RHEL or...

  • Database
    Изменение Timeout в MySQL, MariaDB, Percona

    Посмотреть все текущие лимиты можно командой: Вывод будет примерно такой:   1. Start the DB server as ‘root’ user with  the comandline option and check the values of ‘net_read_timeout’ and ‘wait_timeout’ The result may be like this : mysql> SHOW SESSION VARIABLES LIKE ‘net_read_timeout’; +——————+——-+ | Variable_name    | Value...