Alt-Linux-server-10.2 + mariadb-server-10.6.19

[leksstav]

Всех приветствую !

Подскажите куда копать в плане устранения ошибки.

Имеем на борту:

1) Alt-Linux-server-10.2
2) mariadb-server-10.6.19

При пустом файле my.cnf mysql запускается с таким логом:

 

2024-10-28 12:22:16 0 [Note] Starting MariaDB 10.6.19-MariaDB-alt1 source revision  server_uid Zv4jGM3BmfGDe4+uFbWEwRNyfm0= as process 4957
2024-10-28 12:22:16 0 [Note] Plugin 'InnoDB' is disabled.
2024-10-28 12:22:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-10-28 12:22:16 0 [Note] Starting MariaDB 10.6.19-MariaDB-alt1 source revision  server_uid Zv4jGM3BmfGDe4+uFbWEwRNyfm0= as process 5426
2024-10-28 12:22:16 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
2024-10-28 12:22:16 0 [Note] InnoDB: Number of pools: 1
2024-10-28 12:22:16 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-10-28 12:22:16 0 [Note] InnoDB: Using Linux native AIO
2024-10-28 12:22:16 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2024-10-28 12:22:16 0 [Note] InnoDB: Completed initialization of buffer pool
2024-10-28 12:22:16 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=13571,13571
2024-10-28 12:22:16 0 [Note] InnoDB: To recover: 3 pages
2024-10-28 12:22:16 0 [Note] InnoDB: 128 rollback segments are active.
2024-10-28 12:22:16 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-10-28 12:22:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-10-28 12:22:16 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-10-28 12:22:16 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-10-28 12:22:16 0 [Note] InnoDB: 10.6.19 started; log sequence number 33097; transaction id 4
2024-10-28 12:22:16 0 [Note] InnoDB: Loading buffer pool(s) from /db/ib_buffer_pool
2024-10-28 12:22:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-10-28 12:22:16 0 [Note] InnoDB: Cannot open '/db/ib_buffer_pool' for reading: No such file or directory
2024-10-28 12:22:16 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.19-MariaDB-alt1'  socket: '/mysql.sock'  port: 0  (ALT p10)
2024-10-28 12:23:29 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2024-10-28 12:23:29 0 [Note] InnoDB: FTS optimize thread exiting.
2024-10-28 12:23:29 0 [Note] InnoDB: Starting shutdown...
2024-10-28 12:23:29 0 [Note] InnoDB: Dumping buffer pool(s) to /db/ib_buffer_pool
2024-10-28 12:23:29 0 [Note] InnoDB: Buffer pool(s) dump completed at 241028 12:23:29
2024-10-28 12:23:30 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-10-28 12:23:30 0 [Note] InnoDB: Shutdown completed; log sequence number 33109; transaction id 4
2024-10-28 12:23:30 0 [Note] /usr/sbin/mysqld: Shutdown complete 

 

Со страницы https://support.kaspersky.ru/ksc-linux/15/210277 беру новое содержимое для my.cnf

 

sort_buffer_size=10M
join_buffer_size=100M
join_buffer_space_limit=300M
join_cache_level=8
tmp_table_size=512M
max_heap_table_size=512M
key_buffer_size=200M
innodb_buffer_pool_size=100
innodb_thread_concurrency=20
innodb_flush_log_at_trx_commit=0
innodb_lock_wait_timeout=300
max_allowed_packet=32M
max_connections=151
max_prepared_stmt_count=12800
table_open_cache=60000
table_open_cache_instances=4
table_definition_cache=60000
optimizer_prune_level=0
optimizer_search_depth=8

 

И далее получаю следующий лог mysql

 

2024-10-28 12:23:30 0 [Note] Starting MariaDB 10.6.19-MariaDB-alt1 source revision  server_uid Zv4jGM3BmfGDe4+uFbWEwRNyfm0= as process 5539
2024-10-28 12:23:30 0 [Note] Plugin 'InnoDB' is disabled.
2024-10-28 12:23:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-10-28 12:23:30 0 [Warning] 'innodb-thread-concurrency' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2024-10-28 12:23:30 0 [Note] Starting MariaDB 10.6.19-MariaDB-alt1 source revision  server_uid Zv4jGM3BmfGDe4+uFbWEwRNyfm0= as process 6008
2024-10-28 12:23:30 0 [Warning] option 'innodb-buffer-pool-size': unsigned value 512 adjusted to 2097152
2024-10-28 12:23:30 0 [ERROR] InnoDB: innodb_page_size=16384 requires innodb_buffer_pool_size >= 5MiB current 2MiB
2024-10-28 12:23:30 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-10-28 12:23:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-10-28 12:23:30 0 [Warning] 'innodb-thread-concurrency' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2024-10-28 12:23:30 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-10-28 12:23:30 0 [ERROR] Aborting 

 

[mike 1]

Здравствуйте, а это выполнялось?

 

По умолчанию надстройки оптимизатора join_cache_incremental, join_cache_hashed, join_cache_bka включены. Если эти надстройки не включены, их необходимо включить.

[leksstav]

2 часа назад, mike 1 сказал:

Здравствуйте, а это выполнялось?

 

По умолчанию надстройки оптимизатора join_cache_incremental, join_cache_hashed, join_cache_bka включены. Если эти надстройки не включены, их необходимо включить.

 

Проблема заключалась в том что я забыл прописать букву M после цифры 100  innodb_buffer_pool_size=100

Посоветуйте на счет значения innodb_buffer_pool_size=реальное значение должно быть не менее 80% от ожидаемого размера базы данных KAV. Даже затрудняюсь так сказать понять какой будет размер базы. Пользователей будет около 5 тыс. Какой оптимальный размер должен быть примерно для такого объема ?

Изменено 28 октября, 2024 пользователем leksstav

[mike 1]

Здравствуйте, предлагаю продолжить здесь https://forum.kaspersky.com/topic/alt-linux-server-102-mariadb-server-10619-51834/