Проблема с БД

Товары тут при том, что ты про них пишешь. А понимаю я только то, что пишешь ты не поделу.

Это ты не читаешь. А я спрашиваю про настройки.

Понятен уровень, то есть эта строчка в логах тебе ничего не сказала:

2024-01-30  7:45:53 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

Нет смысла далее дискутировать.

Сессии от ocStore 3.0.3.2  в БД распухли, почистил кое-что вместо 922 мБ стало 712 мБ, а при сохранении БД всего лишь 22 мБ (при сохранении на комп сессии не сохраняются).

Затем установил ocStore 3.0.3.7   со старыми логинами и паролями, движок стал новый), залил старую БД, которая 22 мБ. В итоге новый движок и БД мало весит.

И все, не стало проблем на хостинге. Еще пишут, что в 3.0.3.7 сессии стираются.

Ну распухнет БД, и снова проблемы появятся. Может быть, всё же надо что-то поменять в настройках?

Базы не распухли, сутки продержалось, снова БД упали, что можно сделать?

Version: '10.3.27-MariaDB-0+deb10u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 10
2024-01-31 15:45:39 0 [Note] InnoDB: Buffer pool(s) load completed at 240131 15:45:39
2024-01-31 15:45:44 70 [ERROR] mysqld: Table './lgpd@002df/phpbb_qa_confirm' is marked as crashed and should be repaired
2024-01-31 15:45:44 70 [Warning] Checking table:   './lgpd@002df/phpbb_qa_confirm'
2024-01-31 15:45:50 77 [ERROR] mysqld: Table './lgpd@002df/phpbb_topics' is marked as crashed and should be repaired
2024-01-31 15:45:50 77 [Warning] Checking table:   './lgpd@002df/phpbb_topics'
2024-01-31 15:45:50 80 [ERROR] mysqld: Table './lgpd@002df/phpbb_search_results' is marked as crashed and should be repaired
2024-01-31 15:45:50 80 [Warning] Checking table:   './lgpd@002df/phpbb_search_results'
2024-01-31 15:46:01 0 [ERROR] mysqld: Out of memory (Needed 128663552 bytes)
2024-01-31 15:46:01 0 [ERROR] mysqld: Out of memory (Needed 96485376 bytes)
2024-01-31 15:46:01 0 [Note] InnoDB: Using Linux native AIO
2024-01-31 15:46:01 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-01-31 15:46:01 0 [Note] InnoDB: Uses event mutexes
2024-01-31 15:46:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-01-31 15:46:01 0 [Note] InnoDB: Number of pools: 1
2024-01-31 15:46:01 0 [Note] InnoDB: Using generic crc32 instructions
2024-01-31 15:46:01 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2024-01-31 15:46:01 0 [ERROR] InnoDB: mmap(137035776 bytes) failed; errno 12
2024-01-31 15:46:01 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2024-01-31 15:46:01 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-01-31 15:46:01 0 [Note] InnoDB: Starting shutdown...
double free or corruption (out)
240131 15:46:02 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.

Server version: 11.3.27-MariaDB-0+deb10u1
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=0
max_threads=153
thread_count=0
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467424 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x49000
2024-01-31 16:10:27 0 [Note] InnoDB: Using Linux native AIO
2024-01-31 16:10:27 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-01-31 16:10:27 0 [Note] InnoDB: Uses event mutexes
2024-01-31 16:10:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-01-31 16:10:27 0 [Note] InnoDB: Number of pools: 1
2024-01-31 16:10:27 0 [Note] InnoDB: Using generic crc32 instructions
2024-01-31 16:10:27 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2024-01-31 16:10:27 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-31 16:10:27 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-01-31 16:10:27 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=117248317002
2024-01-31 16:10:27 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-31 16:10:27 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-01-31 16:10:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-31 16:10:27 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-31 16:10:27 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-01-31 16:10:27 0 [Note] InnoDB: Waiting for purge to start
2024-01-31 16:10:28 0 [Note] InnoDB: 10.3.27 started; log sequence number 117248317011; transaction id 136097272
2024-01-31 16:10:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-31 16:10:28 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-01-31 16:10:28 0 [Note] Recovering after a crash using tc.log
2024-01-31 16:10:28 0 [Note] Starting crash recovery...
2024-01-31 16:10:28 0 [Note] Crash recovery finished.
2024-01-31 16:10:28 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-01-31 16:10:28 0 [Note] Reading of all Master_info entries succeeded
2024-01-31 16:10:28 0 [Note] Added new Master_info '' to hash table
2024-01-31 16:10:28 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.3.27-MariaDB-0+deb10u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 10
2024-01-31 16:10:30 0 [Note] InnoDB: Buffer pool(s) load completed at 240131 16:10:30
2024-01-31 16:10:32 75 [ERROR] mysqld: Table './lgpd@002df/phpbb_login_attempts' is marked as crashed and should be repaired
2024-01-31 16:10:32 75 [Warning] Checking table:   './lgpd@002df/phpbb_login_attempts'
2024-01-31 16:10:34 90 [ERROR] mysqld: Table './lgpd@002df/phpbb_sessions' is marked as crashed and should be repaired
2024-01-31 16:10:34 90 [Warning] Checking table:   './lgpd@002df/phpbb_sessions'

В случае MariaDB можно попробовать переехать с InnoDB на Aria или что там еще бывает.

Еще заметил по логу, вначале словно предупреждает, много строк такого типа:

2024-01-30 23:23:51 72497 [Warning] Aborted connection 72497 to db: 'usertt' user: 'usertt' host: 'localhost' (Got an error reading communication packets)
2024-01-30 23:46:45 74936 [Warning] Aborted connection 74936 to db: 'wood' user: 'wood' host: 'localhost' (Got an error reading communication packets)

СУБД слушает только localhost / 127.0.0.1?

Или торчит в интернет?

Только localhost / 127.0.0.1

В файле конфигурации такое (лишнее сократил), может что-то поменять?

# These groups are read by MariaDB server.
# * Basic Settings
user                    = mysql
pid-file                = /run/mysqld/mysqld.pid
socket                  = /run/mysqld/mysqld.sock
#port                   = 3306
basedir                 = /usr
datadir                 = /var/lib/mysql
tmpdir                  = /tmp
lc-messages-dir         = /usr/share/mysql
#skip-external-locking
# * Fine Tuning
#key_buffer_size        = 16M
#max_allowed_packet     = 16M
#thread_stack           = 192K
#thread_cache_size      = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
#myisam_recover_options = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10

# * Query Cache Configuration
#query_cache_limit      = 1M
query_cache_size        = 16M
#long_query_time        = 10
#log_slow_rate_limit    = 1000
#log_slow_verbosity     = query_plan
expire_logs_days        = 10
#max_binlog_size        = 100M
#binlog_do_db           = include_database_name
#binlog_ignore_db       = exclude_database_name
# * Security Features
# Read the manual, too, if you want chroot!
#chroot = /var/lib/mysql/
# For generating SSL certificates you can use for example the GUI tool "tinyca".
#ssl-ca = /etc/mysql/cacert.pem
#ssl-cert = /etc/mysql/server-cert.pem
#ssl-key = /etc/mysql/server-key.pem
# ..when MariaDB is compiled with OpenSSL:
#ssl-cipher = TLSv1.2
# ..when MariaDB is compiled with YaSSL (default in Debian):
#ssl = on
# * Character sets
# MySQL/MariaDB default is Latin1, but in Debian we rather default to the full
# utf8 4-byte character set. See also client.cnf
#
character-set-server  = utf8mb4
collation-server      = utf8mb4_general_ci
# use this group for options that older servers don't understand
[mariadb-10.3]

Лишнее - это  то, что закомментировано. Но оно не сокращено.