Ошибка соединения с базой данных
-
Здравствуйте!
Прошу помощи, на сервере постоянно стал отваливаться вордпресс.
Ошибка соединения с базой данных, происходит в основном ночью.
Оперативка у сервера 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
- Тема «Ошибка соединения с базой данных» закрыта для новых ответов.