MySQL Memory Calculator
Use this form when tuning your MySQL database server to calculate the maximum MySQL memory usage based on configuration settings…
MariaDB InnoDB: Possible causes for this error In case (b) you need to set innodb_log_file_size
Ошибка “InnoDB: Possible causes for this error In case (b) you need to set innodb_log_file_size” в MariaDB обычно возникает из-за…
HOW TO UPGRADE MARIADB 5.5 TO MARIADB 10.4 ON CENTOS 7.5 (1804)
1. MAKE SURE YOU’RE RUNNING MARIADB 5.5 Run the following command: [crayon-647fe6632a03c250949376/] Should output the following: [crayon-647fe6632a043567614411/] Perfect,…
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: [crayon-647fe6632a53c554228072/] Should output the following: [crayon-647fe6632a544815504697/] Perfect,…
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 – Как обновить [crayon-647fe6632aa93702064054/] Временное решение проблемы: [crayon-647fe6632aa9b113315174/] Добавить код:…
Увеличение лимита 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…
Изменение Timeout в MySQL, MariaDB, Percona
Посмотреть все текущие лимиты можно командой: [crayon-647fe6632b576408107642/] Вывод будет примерно такой: [crayon-647fe6632b57b258943655/] 1. Start the DB server as ‘root’…