Use this form when tuning your MySQL database server to calculate the maximum MySQL memory usage…
Рубрика: Database
database system was not properly shut down; automatic recovery in progress
Далее вы делаете на свой страх и риск!!!! Бэкапьтесь!!! # pg_controldata /data/pgdata *** Latest checkpoint’s NextXID:…
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-6423569cab86d234389972/] Should output the…
open_files_limit MariaDB on Debian 9
Check Limit on System [crayon-6423569cadc58880707780/] [crayon-6423569cadc5d781510012/] Edit Limit on: [crayon-6423569cadc5f147643315/] Change limit Check [crayon-6423569cadc60689131833/] Enter command:…
Calculate table_open_cache MySQL
1. Find current value of open_tables and opened_tables [crayon-6423569cade57622924718/] 2. Find out Table cache hit rate…
xtrabackup single table
I copied data from Mysql source version to Mysql destination version and insert to database Test_Database_Backup.…
Увеличение лимита 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.…
Изменение Timeout в MySQL, MariaDB, Percona
Посмотреть все текущие лимиты можно командой: [crayon-6423569cae359643307166/] Вывод будет примерно такой: [crayon-6423569cae35e973889844/] 1. Start the…