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: mysql -v Should output the following: Welcome to the…
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: mysql -v Should output the following: Welcome to the…
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 – Как обновить tail /var/log/mariadb/mariadb.log 2019-04-11 9:38:27 0 InnoDB: Creating…
Увеличение лимита 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
Посмотреть все текущие лимиты можно командой: show variables like '%timeout%'; Вывод будет примерно такой: mysql> show variables like '%timeout%'; +-----------------------------+----------+…