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-6380a604e65e6831569864/]   Should output the…

open_files_limit MariaDB on Debian 9

Check Limit on System [crayon-6380a604e833e900797821/] [crayon-6380a604e8343156634158/] Edit Limit on: [crayon-6380a604e8345159290071/] Change limit Check [crayon-6380a604e8346671493485/] Enter command:…

Calculate table_open_cache MySQL

1. Find current value of open_tables and opened_tables [crayon-6380a604e86ed496647717/] 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-6380a604e8c5e056122924/] Вывод будет примерно такой: [crayon-6380a604e8c63410874560/]   1. Start the…