Падает mysql.

[aleksndr]

Добрый час.Обновился пару недель назад, с 3.1 до 3.2.9 (php 7.4)
Теперь при увеличение трафика, если на сайте около 300 онлайн, падает БД -

Код: Выделить всё

General Error
SQL ERROR [ mysqli ]

Connection refused [2002]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

В логах СУБД наблюдаем следующие ошибки:

Код: Выделить всё

200126 1:31:26 [ERROR] mysqld: Out of memory (Needed 128917504 bytes)
200126 1:31:26 [ERROR] mysqld: Out of memory (Needed 96681984 bytes)

В логах на сервере:

Код: Выделить всё

[Sun Jan 26 05:49:14.393825 2020] [fcgid:warn] [pid 19256] [client 77.111.247.5:41790] mod_fcgid: stderr: PHP Fatal error:  SQL ERROR [ mysqli ]<br /><br />Connection refused [2002]<br /><br />An sql error occurred while fetching this page. Please contact an administrator if this problem persists. in /home/admin/web/foxtor.site/public_html/phpbb/db/driver/driver.php on line 997, referer: http://foxtor.site/viewtopic.php?f=2&t=12932

Раньше на 3.1, такого не когда не было.
ТП сервера - рекомендуем Вам рассматривать переход на тариф выше.Не хватает ОЗУ
Конфиг VDS : (2 СPU/2 GB RAM/30 GB SSD)

Может кто знает, как решить этот вопрос без перехода на более дорогой тариф?
Читал, что даже при 500 мб памяти, phpbb выдерживал по 70 000 уников в день.
За ранее спасибо!

[rxu]

как решить этот вопрос без перехода на более дорогой тариф

Очевидно, что оптимизацией настроек сервера. Плюс, возможно, серверным кэшированием.
Но это к спецам по серверам.

Какие лимиты по памяти выделены в настройках MySQL? Таблицы InnoDB или MyISAM? Что в метриках производительности SQL сервера? Какие еще есть ошибки в логе? Такое есть?

Код: Выделить всё

InnoDB: Fatal error: cannot allocate memory for the buffer pool
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

В общем, маловато информации.

[aleksndr]

Какие еще есть ошибки в логе? Такое есть?

Всё что в логах ошибок на данном домене

Код: Выделить всё

[Sun Jan 26 04:04:39.066746 2020] [fcgid:warn] [pid 4300] (32)Broken pipe: [client 154.16.54.201:45210] mod_fcgid: ap_pass_brigade failed in handle_request_ipc function
[Sun Jan 26 05:49:14.393825 2020] [fcgid:warn] [pid 19256] [client 77.111.247.5:41790] mod_fcgid: stderr: PHP Fatal error:  SQL ERROR [ mysqli ]<br /><br />Connection refused [2002]<br /><br />An sql error occurred while fetching this page. Please contact an administrator if this problem persists. in /home/admin/web/foxtor.site/public_html/phpbb/db/driver/driver.php on line 997, referer: http://foxtor.site/viewtopic.php?f=2&t=12932
[Sun Jan 26 05:54:51.376253 2020] [fcgid:warn] [pid 19256] [client 77.111.247.5:42098] mod_fcgid: stderr: PHP Fatal error:  SQL ERROR [ mysqli ]<br /><br />Connection refused [2002]<br /><br />An sql error occurred while fetching this page. Please contact an administrator if this problem persists. in /home/admin/web/foxtor.site/public_html/phpbb/db/driver/driver.php on line 997, referer: http://foxtor.site/viewtopic.php?f=2&t=14763

Это настройки MARIADB

Код: Выделить всё

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0

skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 16M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

#innodb_use_native_aio = 0
innodb_file_per_table

max_connections=70
max_user_connections=30
wait_timeout=100
interactive_timeout=50
long_query_time=5

#slow_query_log=1
#slow_query_log_file=/var/log/mysql-slow-queries.log



[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

Отправлено спустя 40 секунд:

 

max_connections
70


max_user_connections
30


wait_timeout
100


interactive_timeout
50


max_allowed_packet
16M

[rxu]

Всё что в логах ошибок на данном домене

Я говорил про лог MySQL сервера.

Отправлено спустя 4 минуты 59 секунд:
mysqltuner есть? Что показывает?

[aleksndr]

mysqltuner есть?

Как проверить на centos 7 ?

Отправлено спустя 4 минуты 22 секунды:
Наверное не установлено
perl mysqltuner.pl --user root --pass rootpassword - No such file or directory

Отправлено спустя 9 минут 50 секунд:

ЛОГ 

200124 14:03:49 [Warning] IP address '39.104.20.230' could not be resolved: Name or service not known
200124 14:20:24 [Warning] IP address '106.54.248.203' could not be resolved: Name or service not known
200124 14:55:23 [Warning] IP address '47.106.168.137' could not be resolved: Name or service not known
200124 15:00:46 [Warning] IP address '47.108.94.25' could not be resolved: Name or service not known
200124 15:06:39 [Warning] IP address '13.76.100.118' could not be resolved: Name or service not known
200124 15:13:15 [Warning] IP address '60.51.17.238' could not be resolved: Name or service not known
200124 15:18:09 [Warning] IP address '47.89.38.111' could not be resolved: Name or service not known
200124 15:33:54 [Warning] IP address '47.102.121.106' could not be resolved: Name or service not known
200124 16:00:19 [Warning] IP address '47.97.73.89' could not be resolved: Name or service not known
200124 16:13:14 [Warning] IP address '43.248.127.187' could not be resolved: Name or service not known
200124 16:34:25 [Warning] IP address '39.104.20.250' could not be resolved: Name or service not known
200124 19:17:51 [Warning] IP address '170.130.187.6' could not be resolved: Name or service not known
200124 22:32:08 [Warning] IP address '83.97.20.47' has been resolved to the host name '47.20.97.83.ro.ovo.sc', which resembles IPv4-address itself.
200125 18:07:48 [Note] Hostname 'ser1a3l.serenity-inverter.website' does not resolve to '104.140.188.18'.
200125 18:07:48 [Note] Hostname 'ser1a3l.serenity-inverter.website' has the following IP addresses:
200125 18:07:48 [Note] - 198.54.117.197

200125 18:07:48 [Note] - 198.54.117.198

200125 18:07:48 [Note] - 198.54.117.199

200125 18:07:48 [Note] - 198.54.117.200

200125 21:10:21 [Warning] IP address '83.97.20.35' has been resolved to the host name '35.20.97.83.ro.ovo.sc', which resembles IPv4-address itself.
200125 23:43:08 [Warning] IP address '71.6.232.5' could not be resolved: Name or service not known
200126 01:28:39 mysqld_safe Number of processes running now: 0
200126 01:28:39 mysqld_safe mysqld restarted
200126 1:28:39 [Note] /usr/libexec/mysqld (mysqld 5.5.64-MariaDB) starting as process 3229 ...
200126 1:28:39 InnoDB: The InnoDB memory heap is disabled
200126 1:28:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
200126 1:28:39 InnoDB: Compressed tables use zlib 1.2.7
200126 1:28:39 InnoDB: Using Linux native AIO
200126 1:28:39 InnoDB: Initializing buffer pool, size = 128.0M
200126 1:28:39 InnoDB: Completed initialization of buffer pool
200126 1:28:39 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...
200126 1:28:40 InnoDB: Waiting for the background threads to start
200126 1:28:41 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 3183251737
200126 1:28:41 [Note] Plugin 'FEEDBACK' is disabled.
200126 1:28:41 [Note] Server socket created on IP: '0.0.0.0'.
200126 1:28:41 [Note] Event Scheduler: Loaded 0 events
200126 1:28:41 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.64-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
200126 1:28:45 [ERROR] mysqld: Table './admin_test/phpbb_config' is marked as crashed and should be repaired
200126 1:28:45 [Warning] Checking table: './admin_test/phpbb_config'
200126 1:28:45 [ERROR] mysqld: Table './admin_test/phpbb_users' is marked as crashed and should be repaired
200126 1:28:45 [Warning] Checking table: './admin_test/phpbb_users'
200126 1:28:46 [ERROR] mysqld: Table './admin_test/phpbb_sessions' is marked as crashed and should be repaired
200126 1:28:46 [Warning] Checking table: './admin_test/phpbb_sessions'
200126 1:28:46 [ERROR] mysqld: Table './admin_test/phpbb_forums' is marked as crashed and should be repaired
200126 1:28:46 [Warning] Checking table: './admin_test/phpbb_forums'
200126 1:28:46 [ERROR] mysqld: Table './admin_test/phpbb_posts' is marked as crashed and should be repaired
200126 1:28:46 [Warning] Checking table: './admin_test/phpbb_posts'
200126 1:28:46 [ERROR] mysqld: Table './admin_test/phpbb_topics' is marked as crashed and should be repaired
200126 1:28:46 [Warning] Checking table: './admin_test/phpbb_topics'
200126 1:28:47 [ERROR] mysqld: Table './admin_test/phpbb_attachments' is marked as crashed and should be repaired
200126 1:28:47 [Warning] Checking table: './admin_test/phpbb_attachments'
200126 1:28:47 [ERROR] mysqld: Table './admin_test/phpbb_tracker_rtrack' is marked as crashed and should be repaired
200126 1:28:47 [Warning] Checking table: './admin_test/phpbb_tracker_rtrack'
200126 1:28:47 [ERROR] mysqld: Table './admin_test/phpbb_tracker_rannounces' is marked as crashed and should be repaired
200126 1:28:47 [Warning] Checking table: './admin_test/phpbb_tracker_rannounces'
200126 1:28:47 [ERROR] mysqld: Table './admin_test/phpbb_tracker_cron' is marked as crashed and should be repaired
200126 1:28:47 [Warning] Checking table: './admin_test/phpbb_tracker_cron'
200126 1:28:48 [ERROR] mysqld: Table './admin_test/phpbb_user_group' is marked as crashed and should be repaired
200126 1:28:48 [Warning] Checking table: './admin_test/phpbb_user_group'
200126 1:28:53 [ERROR] mysqld: Table './admin_test/phpbb_tracker_peers' is marked as crashed and should be repaired
200126 1:28:53 [Warning] Checking table: './admin_test/phpbb_tracker_peers'
200126 01:31:26 mysqld_safe Number of processes running now: 0
200126 01:31:26 mysqld_safe mysqld restarted
200126 1:31:26 [Note] /usr/libexec/mysqld (mysqld 5.5.64-MariaDB) starting as process 3997 ...
200126 1:31:26 InnoDB: The InnoDB memory heap is disabled
200126 1:31:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins
200126 1:31:26 InnoDB: Compressed tables use zlib 1.2.7
200126 1:31:26 InnoDB: Using Linux native AIO
200126 1:31:26 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137756672 bytes) failed; errno 12
200126 1:31:26 InnoDB: Completed initialization of buffer pool
200126 1:31:26 InnoDB: Fatal error: cannot allocate memory for the buffer pool
200126 1:31:26 [ERROR] Plugin 'InnoDB' init function returned error.
200126 1:31:26 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
200126 1:31:26 [ERROR] mysqld: Out of memory (Needed 128917504 bytes)
200126 1:31:26 [ERROR] mysqld: Out of memory (Needed 96681984 bytes)
200126 1:31:26 [Note] Plugin 'FEEDBACK' is disabled.
200126 1:31:26 [ERROR] Unknown/unsupported storage engine: InnoDB
200126 1:31:26 [ERROR] Aborting

200126 1:31:26 [Note] /usr/libexec/mysqld: Shutdown complete

200126 01:31:27 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
200126 01:41:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
200126 1:41:57 [Note] /usr/libexec/mysqld (mysqld 5.5.64-MariaDB) starting as process 6019 ...
200126 1:41:57 InnoDB: The InnoDB memory heap is disabled
200126 1:41:57 InnoDB: Mutexes and rw_locks use GCC atomic builtins
200126 1:41:57 InnoDB: Compressed tables use zlib 1.2.7
200126 1:41:57 InnoDB: Using Linux native AIO
200126 1:41:57 InnoDB: Initializing buffer pool, size = 128.0M
200126 1:41:57 InnoDB: Completed initialization of buffer pool
200126 1:41:57 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...
200126 1:41:57 InnoDB: Waiting for the background threads to start
200126 1:41:58 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 3183261090
200126 1:41:58 [Note] Plugin 'FEEDBACK' is disabled.
200126 1:41:58 [Note] Server socket created on IP: '0.0.0.0'.
200126 1:41:58 [Note] Event Scheduler: Loaded 0 events
200126 1:41:58 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.64-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
200126 1:41:59 [ERROR] mysqld: Table './admin_test/phpbb_users' is marked as crashed and should be repaired
200126 1:41:59 [Warning] Checking table: './admin_test/phpbb_users'
200126 1:41:59 [ERROR] mysqld: Table './admin_test/phpbb_sessions' is marked as crashed and should be repaired
200126 1:41:59 [Warning] Checking table: './admin_test/phpbb_sessions'
200126 1:42:00 [ERROR] mysqld: Table './admin_test/phpbb_topics' is marked as crashed and should be repaired
200126 1:42:00 [Warning] Checking table: './admin_test/phpbb_topics'
200126 1:42:00 [ERROR] mysqld: Table './admin_test/phpbb_tracker_cron' is marked as crashed and should be repaired
200126 1:42:00 [Warning] Checking table: './admin_test/phpbb_tracker_cron'
200126 04:04:26 mysqld_safe Number of processes running now: 0
200126 04:04:26 mysqld_safe mysqld restarted
200126 4:04:26 InnoDB: The InnoDB memory heap is disabled
200126 4:04:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins
200126 4:04:26 InnoDB: Compressed tables use zlib 1.2.7
200126 4:04:26 InnoDB: Using Linux native AIO
200126 4:04:26 [Note] /usr/libexec/mysqld (mysqld 5.5.64-MariaDB) starting as process 4431 ...
200126 4:04:26 InnoDB: Initializing buffer pool, size = 128.0M
200126 4:04:26 InnoDB: Completed initialization of buffer pool
200126 4:04:26 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...
200126 4:04:26 InnoDB: Waiting for the background threads to start
200126 4:04:27 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 3183431771
200126 4:04:27 [Note] Plugin 'FEEDBACK' is disabled.
200126 4:04:28 [Note] Server socket created on IP: '0.0.0.0'.
200126 4:04:28 [Note] Event Scheduler: Loaded 0 events
200126 4:04:28 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.64-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
200126 4:04:30 [ERROR] mysqld: Table './admin_test/phpbb_users' is marked as crashed and should be repaired
200126 4:04:30 [ERROR] mysqld: Table './admin_test/phpbb_users' is marked as crashed and should be repaired
200126 4:04:30 [ERROR] mysqld: Table './admin_test/phpbb_users' is marked as crashed and should be repaired
200126 4:04:30 [ERROR] mysqld: Table './admin_test/phpbb_users' is marked as crashed and should be repaired
200126 4:04:30 [ERROR] mysqld: Table './admin_test/phpbb_users' is marked as crashed and should be repaired
200126 4:04:30 [ERROR] mysqld: Table './admin_test/phpbb_users' is marked as crashed and should be repaired
200126 4:04:30 [Warning] Checking table: './admin_test/phpbb_users'
200126 4:04:32 [ERROR] mysqld: Table './admin_test/phpbb_sessions' is marked as crashed and should be repaired
200126 4:04:32 [Warning] Checking table: './admin_test/phpbb_sessions'
200126 4:04:33 [ERROR] mysqld: Table './admin_test/phpbb_forums' is marked as crashed and should be repaired
200126 4:04:33 [Warning] Checking table: './admin_test/phpbb_forums'
200126 4:04:33 [ERROR] mysqld: Table './admin_test/phpbb_topics' is marked as crashed and should be repaired
200126 4:04:33 [Warning] Checking table: './admin_test/phpbb_topics'
200126 4:04:34 [ERROR] mysqld: Table './admin_test/phpbb_attachments' is marked as crashed and should be repaired
200126 4:04:34 [ERROR] mysqld: Table './admin_test/phpbb_attachments' is marked as crashed and should be repaired
200126 4:04:34 [Warning] Checking table: './admin_test/phpbb_attachments'
200126 4:04:34 [ERROR] mysqld: Table './admin_test/phpbb_tracker_cron' is marked as crashed and should be repaired
200126 4:04:34 [Warning] Checking table: './admin_test/phpbb_tracker_cron'
200126 4:04:35 [ERROR] mysqld: Table './admin_test/phpbb_user_group' is marked as crashed and should be repaired
200126 4:04:35 [ERROR] mysqld: Table './admin_test/phpbb_user_group' is marked as crashed and should be repaired
200126 4:04:35 [Warning] Checking table: './admin_test/phpbb_user_group'
200126 04:04:39 mysqld_safe Number of processes running now: 0
200126 04:04:39 mysqld_safe mysqld restarted
200126 4:04:39 [Note] /usr/libexec/mysqld (mysqld 5.5.64-MariaDB) starting as process 4515 ...
200126 4:04:39 InnoDB: The InnoDB memory heap is disabled
200126 4:04:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
200126 4:04:39 InnoDB: Compressed tables use zlib 1.2.7
200126 4:04:39 InnoDB: Using Linux native AIO
200126 4:04:39 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137756672 bytes) failed; errno 12
200126 4:04:39 InnoDB: Completed initialization of buffer pool
200126 4:04:39 InnoDB: Fatal error: cannot allocate memory for the buffer pool
200126 4:04:39 [ERROR] Plugin 'InnoDB' init function returned error.
200126 4:04:39 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
200126 4:04:39 [Note] Plugin 'FEEDBACK' is disabled.
200126 4:04:39 [ERROR] Unknown/unsupported storage engine: InnoDB
200126 4:04:39 [ERROR] Aborting

200126 4:04:39 [Note] /usr/libexec/mysqld: Shutdown complete

200126 04:04:39 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
200126 08:19:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
200126 8:19:55 [Note] /usr/libexec/mysqld (mysqld 5.5.64-MariaDB) starting as process 16095 ...
200126 8:19:55 InnoDB: The InnoDB memory heap is disabled
200126 8:19:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins
200126 8:19:55 InnoDB: Compressed tables use zlib 1.2.7
200126 8:19:55 InnoDB: Using Linux native AIO
200126 8:19:55 InnoDB: Initializing buffer pool, size = 128.0M
200126 8:19:55 InnoDB: Completed initialization of buffer pool
200126 8:19:55 InnoDB: highest supported file format is Barracuda.
200126 8:19:55 InnoDB: Starting crash recovery from checkpoint LSN=3183431771
InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
200126 8:19:55 InnoDB: Waiting for the background threads to start
200126 8:19:56 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 3183431791
200126 8:19:56 [Note] Plugin 'FEEDBACK' is disabled.
200126 8:19:56 [Note] Server socket created on IP: '0.0.0.0'.
200126 8:19:56 [Note] Event Scheduler: Loaded 0 events
200126 8:19:56 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.64-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
200126 8:20:00 [ERROR] mysqld: Table './admin_test/phpbb_topics' is marked as crashed and should be repaired
200126 8:20:00 [Warning] Checking table: './admin_test/phpbb_topics'
200126 8:31:44 [Warning] IP address '193.238.46.18' could not be resolved: Name or service not known

[rxu]

innodb_buffer_pool_size в настройках не видно, он есть? Чему равен?

[aleksndr]

/etc/my.cnf - больше не чего нет

Код: Выделить всё

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0

skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 16M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

#innodb_use_native_aio = 0
innodb_file_per_table

max_connections=70
max_user_connections=30
wait_timeout=100
interactive_timeout=50
long_query_time=5

#slow_query_log=1
#slow_query_log_file=/var/log/mysql-slow-queries.log



[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

[rxu]

perl mysqltuner.pl --user root --pass rootpassword - No such file or directory

Так может, установить и попробовать?

[aleksndr]

ТП сервера все настройки по оптимизации сервера выполнили и утверждают, что установка и настройка по mysqltuner, к положительным результатам не приведет.Сейчас занимаются обновлением mariadb.

[rxu]

ТП сервера все настройки по оптимизации сервера выполнили и утверждают, что установка и настройка по mysqltuner, к положительным результатам не приведет.

Они ничего другого и не скажут, их главная задача - переключить клиента на более дорогой тариф. Если сами оптимизировать не будете - то просто переключайтесь.

[aleksndr]

Да хз.Я им и так за пол года весь мозг вынес с разными установками php, кеширования и тд. Всё делают.

[jd8615]

2 СPU/2 GB RAM/30 GB SSD

Что за хостер? Может у них оверселлинг?

[Olej]

Да хз.Я им и так за пол года весь мозг вынес с разными установками php, кеширования и тд. Всё делают.

Конфиг VDS : (2 СPU/2 GB RAM/30 GB SSD)

Если у вас VDS (автономный виртуальный сервер), то зачем вам ТП - устанавливайте и конфигурируйте всё сами, по SSH.
Какая у вас там ОС?
У меня phpBB 3.2.8 (http://linux-ru.ru/index.php) благополучно работает (>10 лет) на 512Mb RAM (в 4 раза меньше, получается!) ... правда при интенсивности доступов в несколько раз меньше.

[Webliberty]

Обновился пару недель назад, с 3.1 до 3.2.9 (php 7.4)

phpBB 3.2.9 разве совместим с php 7.4?

[Siava]

aleksndr, mysqltuner вам в помощь.
Можно из репо, либо с mysqltuner.pl скачать.