Поддержка Проблемы и решения Ошибка соединения с базой данных

  • Здравствуйте!
    Прошу помощи, на сервере постоянно стал отваливаться вордпресс.
    Ошибка соединения с базой данных, происходит в основном ночью.
    Оперативка у сервера 8 гигов, 8 ядер. Стоит панель isppanel
    База данных MariaBD, таблицы InnoDB

    Уже и память увеличивал, нагрузка маленькая. 20% от ресурсов в пик.
    Выдержка из лог файла:

    InnoDB: The log sequence number in ibdata files does not match
    InnoDB: the log sequence number in the ib_logfiles!
    InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
    211005  3:37:57  InnoDB: Waiting for the background threads to start
    211005  3:37:58 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 1008971378890
    211005  3:37:58 [Note] Plugin 'XTRADB_ADMIN_COMMAND' is disabled.
    211005  3:37:58 [Note] Plugin 'FEEDBACK' is disabled.
    211005  3:37:58 [Note] Server socket created on IP: '127.0.0.1'.
    211005  3:37:58 [Note] Event Scheduler: Loaded 0 events
    211005  3:37:58 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.5.68-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
    211007 10:05:43 mysqld_safe Number of processes running now: 0
    211007 10:05:43 mysqld_safe mysqld restarted
    211007 10:05:43 [Warning] option 'max_allowed_packet': unsigned value 8589934592 adjusted to 1073741824
    211007 10:05:43 [Note] /usr/libexec/mysqld (mysqld 5.5.68-MariaDB) starting as process 8038 ...
    211007 10:05:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    211007 10:05:43 InnoDB: Compressed tables use zlib 1.2.7
    211007 10:05:43 InnoDB: Using Linux native AIO
    211007 10:05:43 InnoDB: Initializing buffer pool, size = 5.0G
    InnoDB: mmap(5510266880 bytes) failed; errno 12
    211007 10:05:43 InnoDB: Completed initialization of buffer pool
    211007 10:05:43 InnoDB: Fatal error: cannot allocate memory for the buffer pool
    211007 10:05:43 [ERROR] Plugin 'InnoDB' init function returned error.
    211007 10:05:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    211007 10:05:43 [Note] Plugin 'XTRADB_ADMIN_COMMAND' is disabled.
    211007 10:05:43 [Note] Plugin 'FEEDBACK' is disabled.
    211007 10:05:43 [ERROR] Unknown/unsupported storage engine: InnoDB
    211007 10:05:43 [ERROR] Aborting
    211007 10:05:43 [Note] /usr/libexec/mysqld: Shutdown complete
    211007 10:05:44 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
    211008 13:03:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    211008 13:03:54 [Warning] option 'max_allowed_packet': unsigned value 8589934592 adjusted to 1073741824
    211008 13:03:54 [Note] /usr/libexec/mysqld (mysqld 5.5.68-MariaDB) starting as process 1956 ...
    211008 13:03:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    211008 13:03:54 InnoDB: Compressed tables use zlib 1.2.7
    211008 13:03:54 InnoDB: Using Linux native AIO
    211008 13:03:54 InnoDB: Initializing buffer pool, size = 5.0G
    211008 13:03:54 InnoDB: Completed initialization of buffer pool
    211008 13:03:54 InnoDB: highest supported file format is Barracuda.
    InnoDB: The log sequence number in ibdata files does not match
    InnoDB: the log sequence number in the ib_logfiles!
    InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
    211008 13:03:56  InnoDB: Waiting for the background threads to start
    211008 13:03:57 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 1008971378890
    211008 13:03:57 [Note] Plugin 'XTRADB_ADMIN_COMMAND' is disabled.
    211008 13:03:57 [Note] Plugin 'FEEDBACK' is disabled.
    211008 13:03:57 [Note] Server socket created on IP: '127.0.0.1'.
    211008 13:03:57 [Note] Event Scheduler: Loaded 0 events
    211008 13:03:57 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.5.68-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

    Настройки сервера BD

    [mysqld]
    collation-server = utf8_general_ci
    character-set-server = utf8
    local-infile=TRUE
    innodb_file_per_table = 1
    pid-file = /var/run/mysqld/mysqld.pid
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    bind-address = 127.0.0.1
    wait-timeout = 1200
    query-cache-limit = 1048576
    max-connections = 160
    innodb-flush-log-at-trx-commit = 0
    thread-cache-size = 16
    innodb-log-file-size = 5242880
    max-binlog-size = 104857600
    innodb-flush-method = O_DIRECT
    slow-query-log = TRUE
    long-query-time = 1
    expire-logs-days = 10
    max-allowed-packet = 8589934592
    innodb-file-per-table = TRUE
    innodb-max-bitmap-file-size = 104857600
    query-cache-size = 0
    innodb-use-sys-malloc = FALSE
    innodb-buffer-pool-size = 5368709120
    xtradb-admin-command = 0
    max-user-connections = 136
    key-buffer-size = 16777216
    join-buffer-size = 268435456
    tmp-table-size = 67108864
    max-heap-table-size = 67108864
    max-connect-errors = 10
    innodb-log-buffer-size = 2097152
    # Settings user and group are ignored when systemd is used.
    # If you need to run mysqld under a different user or group,
    # customize your systemd unit file for mariadb according to the
    # instructions in http://fedoraproject.org/wiki/Systemd
    
    [mysqld_safe]
    log-error=/var/log/mariadb/mariadb.log
    pid-file=/var/run/mariadb/mariadb.pid
    
    #
    # include all files from the config directory
    #
    !includedir /etc/my.cnf.d
    
    [mysqldump]
    max-allowed-packet = 8589934592
    • Тема изменена 2 недели, 4 дня назад пользователем webfantastic.
    • Тема изменена 2 недели, 4 дня назад пользователем webfantastic.