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-6561ef46bc3c2669360320/] Should output the following: [crayon-6561ef46bc3c8882709008/] 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-6561ef46bc88d400414756/] Should output the following: [crayon-6561ef46bc892682084567/] 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-6561ef46bcd9f199764658/] Временное решение проблемы: [crayon-6561ef46bcda7252514997/] Добавить код:…
Увеличение лимита 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-6561ef46bd40d883527938/] Вывод будет примерно такой: [crayon-6561ef46bd412202017120/] 1. Start the DB server as ‘root’…