Про # знаю) В этом файле нет innodb_buffer_pool_size
Внизу только:
## * InnoDB## InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.# Read the manual for more InnoDB related options. There are many!
Только localhost / 127.0.0.1
В файле конфигурации такое (лишнее сократил), может что-то поменять?
# These groups are read by MariaDB server.# * Basic Settingsuser = mysqlpid-file = /run/mysqld/mysqld.pidsocket = /run/mysqld/mysqld.sock#port = 3306basedir = /usrdatadir = /var/lib/mysqltmpdir = /tmplc-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 = 1Mquery_cache_size = 16M#long_query_time = 10#log_slow_rate_limit = 1000#log_slow_verbosity = query_planexpire_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 = utf8mb4collation-server = utf8mb4_general_ci# use this group for options that older servers don't understand[mariadb-10.3]
Еще заметил по логу, вначале словно предупреждает, много строк такого типа:
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)
Базы не распухли, сутки продержалось, снова БД упали, что можно сделать?
Version: '10.3.27-MariaDB-0+deb10u1' socket: '/run/mysqld/mysqld.sock' port: 3306 Debian 102024-01-31 15:45:39 0 [Note] InnoDB: Buffer pool(s) load completed at 240131 15:45:392024-01-31 15:45:44 70 [ERROR] mysqld: Table './lgpd@002df/phpbb_qa_confirm' is marked as crashed and should be repaired2024-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 repaired2024-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 repaired2024-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 AIO2024-01-31 15:46:01 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2024-01-31 15:46:01 0 [Note] InnoDB: Uses event mutexes2024-01-31 15:46:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.112024-01-31 15:46:01 0 [Note] InnoDB: Number of pools: 12024-01-31 15:46:01 0 [Note] InnoDB: Using generic crc32 instructions2024-01-31 15:46:01 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2024-01-31 15:46:01 0 [ERROR] InnoDB: mmap(137035776 bytes) failed; errno 122024-01-31 15:46:01 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool2024-01-31 15:46:01 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error2024-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 binaryor 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-bugsWe will try our best to scrape up some info that will hopefully helpdiagnose the problem, but since we have already crashed, something is definitely wrong and this may fail.Server version: 11.3.27-MariaDB-0+deb10u1key_buffer_size=134217728read_buffer_size=131072max_used_connections=0max_threads=153thread_count=0It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467424 K bytes of memoryHope that's ok; if not, decrease some variables in the equation.Thread pointer: 0x0Attempting backtrace. You can use the following information to find outwhere mysqld died. If you see no messages after this, something wentterribly wrong...stack_bottom = 0x0 thread_stack 0x490002024-01-31 16:10:27 0 [Note] InnoDB: Using Linux native AIO2024-01-31 16:10:27 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2024-01-31 16:10:27 0 [Note] InnoDB: Uses event mutexes2024-01-31 16:10:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.112024-01-31 16:10:27 0 [Note] InnoDB: Number of pools: 12024-01-31 16:10:27 0 [Note] InnoDB: Using generic crc32 instructions2024-01-31 16:10:27 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2024-01-31 16:10:27 0 [Note] InnoDB: Completed initialization of buffer pool2024-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=1172483170022024-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 tables2024-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 start2024-01-31 16:10:28 0 [Note] InnoDB: 10.3.27 started; log sequence number 117248317011; transaction id 1360972722024-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_pool2024-01-31 16:10:28 0 [Note] Recovering after a crash using tc.log2024-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 succeeded2024-01-31 16:10:28 0 [Note] Added new Master_info '' to hash table2024-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 102024-01-31 16:10:30 0 [Note] InnoDB: Buffer pool(s) load completed at 240131 16:10:302024-01-31 16:10:32 75 [ERROR] mysqld: Table './lgpd@002df/phpbb_login_attempts' is marked as crashed and should be repaired2024-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 repaired2024-01-31 16:10:34 90 [Warning] Checking table: './lgpd@002df/phpbb_sessions'
Сессии от ocStore 3.0.3.2 в БД распухли, почистил кое-что вместо 922 мБ стало 712 мБ, а при сохранении БД всего лишь 22 мБ (при сохранении на комп сессии не сохраняются).
Затем установил ocStore 3.0.3.7 со старыми логинами и паролями, движок стал новый), залил старую БД, которая 22 мБ. В итоге новый движок и БД мало весит.
И все, не стало проблем на хостинге. Еще пишут, что в 3.0.3.7 сессии стираются.
Все как-то странно, почистил эти БД от сессии они уменьшились в размерах, пока перестали падать БД.
То есть визуально все админки работали, не видно было, чтоб БД повреждены, много лет работают, не было проблем.
У меня
Порекомендуете корректный плагин Содержания страницы для Wordpress. Стоит "Easy Table of Contents" в вебмастере предупреждение "Якорь, на который указывает ссылка, отсутствует или указан у неподдерживаемого элемента"
Да, повысить версию нужно. Не обязательно одной командой, мне бы знать какие команды вводить...
--------
Установил только, чтоб SVG появилось в imagick info.php :
sudo apt update sudo apt install libmagickcore-6.q16-dev
Перегрузил сервер
Появилось SVG, но результат прежний " При обрезке изображения произошла ошибка. "
Написало:
Unable to locate paskage php8.0-imagick Couldn't find any package by glob 'php8.0-imagick'Couldn't find any package by regex 'php8.0-imagick'
ТП ответила нет ограничений.
В Debian 10 может ограничение есть по умолчанию, хотя маловероятно...
В firefox не дает, получилось в Chrome
