hi, i using aapanel 6.8.32
MySQL 10.7.3-MariaDB
by default i have:
i make changes:
I have this changes after selection:
after i click Save and Restart mysqld service, make confirm.. okey
when I go to mysql manager and Optimization tab, I have old data:
server configuration:
in version older: MySQL 10.6 MariaDB - all is great
after server restart i very often get this situation:
configuration tab:
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
[mysqld]
binlog_cache_size = 256K
thread_stack = 512K
join_buffer_size = 8192K
query_cache_type = 1
max_heap_table_size = 2048M
port = 3306
socket = /tmp/mysql.sock
datadir = /www/server/data
default_storage_engine = InnoDB
performance_schema_max_table_instances = 400
table_definition_cache = 400
skip-external-locking
key_buffer_size = 1024M
max_allowed_packet = 100G
table_open_cache = 2048
sort_buffer_size = 4096K
net_buffer_length = 4K
read_buffer_size = 4096K
read_rnd_buffer_size = 2048K
myisam_sort_buffer_size = 256M
thread_cache_size = 256
query_cache_size = 384M
tmp_table_size = 2048M
sql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
#skip-name-resolve
max_connections = 500
max_connect_errors = 100
open_files_limit = 65535
log-bin=mysql-bin
binlog_format=mixed
server-id = 1
expire_logs_days = 10
slow_query_log=1
slow-query-log-file=/www/server/data/mysql-slow.log
long_query_time=3
#log_queries_not_using_indexes=on
innodb_data_home_dir = /www/server/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /www/server/data
innodb_buffer_pool_size = 4096M
innodb_log_file_size = 2048M
innodb_log_buffer_size = 512M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_max_dirty_pages_pct = 90
innodb_read_io_threads = 56
innodb_write_io_threads = 56
[mysqldump]
quick
max_allowed_packet = 500M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 1024M
sort_buffer_size = 16M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
in logs
231211 06:36:36 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-12-11 6:36:36 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-12-11 6:36:36 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 10920 ...
2023-12-11 6:36:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2023-12-11 6:36:36 0 [Note] InnoDB: Number of transaction pools: 1
2023-12-11 6:36:36 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-12-11 6:36:36 0 [Note] InnoDB: Using Linux native AIO
2023-12-11 6:36:36 0 [Note] InnoDB: Initializing buffer pool, total size = 4294967296, chunk size = 134217728
2023-12-11 6:36:36 0 [Note] InnoDB: Completed initialization of buffer pool
2023-12-11 6:36:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=42389,42389
2023-12-11 6:36:36 0 [ERROR] InnoDB: Corrupted page identifier at 42389; set innodb_force_recovery=1 to ignore the record.
2023-12-11 6:36:36 0 [Note] InnoDB: Dump from the start of the mini-transaction (LSN=42389) to 100 bytes after the record:
len 101; hex ffffffff000034002d31000039002e32ffffffff0000b700ffffffff000034002e31000039002f32ffffffff0000b700ffffffff000034002f31000039003032ffffffff0000b700ffffffff000034003031000039003132ffffffff0000b700ffffffff00; asc 4 -1 9 .2 4 .1 9 /2 4 /1 9 02 4 01 9 12 ;
2023-12-11 6:36:36 0 [Warning] InnoDB: Log scan aborted at LSN 92672
2023-12-11 6:36:36 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2023-12-11 6:36:36 0 [Note] InnoDB: Starting shutdown...
2023-12-11 6:36:36 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-12-11 6:36:36 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-12-11 6:36:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-12-11 6:36:36 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2023-12-11 6:36:36 0 [ERROR] Aborting
231211 06:36:36 mysqld_safe mysqld from pid file /www/server/data/localhost.localdomain.pid ended
more logs:
after
cp -p /www/server/data/mysql-bin.index /www/backup
cat /dev/null > /www/server/data/mysql-bin.index
/etc/init.d/mysqld start
same problem, not starting
new logs info:
231211 06:46:28 mysqld_safe mysqld from pid file /www/server/data/localhost.localdomain.pid ended
231211 06:46:59 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-12-11 6:46:59 0 [Warning] option 'max_allowed_packet': unsigned value 10737418240 adjusted to 1073741824
2023-12-11 6:46:59 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 19981 ...
2023-12-11 6:46:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2023-12-11 6:46:59 0 [Note] InnoDB: Number of transaction pools: 1
2023-12-11 6:46:59 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-12-11 6:46:59 0 [Note] InnoDB: Using Linux native AIO
2023-12-11 6:46:59 0 [Note] InnoDB: Initializing buffer pool, total size = 4294967296, chunk size = 134217728
2023-12-11 6:46:59 0 [Note] InnoDB: Completed initialization of buffer pool
2023-12-11 6:46:59 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=42389,42389
2023-12-11 6:46:59 0 [ERROR] InnoDB: Corrupted page identifier at 42389; set innodb_force_recovery=1 to ignore the record.
2023-12-11 6:46:59 0 [Note] InnoDB: Dump from the start of the mini-transaction (LSN=42389) to 100 bytes after the record:
len 101; hex ffffffff000034002d31000039002e32ffffffff0000b700ffffffff000034002e31000039002f32ffffffff0000b700ffffffff000034002f31000039003032ffffffff0000b700ffffffff000034003031000039003132ffffffff0000b700ffffffff00; asc 4 -1 9 .2 4 .1 9 /2 4 /1 9 02 4 01 9 12 ;
2023-12-11 6:46:59 0 [Warning] InnoDB: Log scan aborted at LSN 92672
2023-12-11 6:46:59 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2023-12-11 6:46:59 0 [Note] InnoDB: Starting shutdown...
2023-12-11 6:46:59 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-12-11 6:46:59 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-12-11 6:46:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-12-11 6:46:59 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2023-12-11 6:46:59 0 [ERROR] Aborting
231211 06:46:59 mysqld_safe mysqld from pid file /www/server/data/localhost.localdomain.pid ended
[root@localhost ~]#
after
innodb_force_recovery=1
max_allowed_packet = 1G
new messages:
231211 06:51:18 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-12-11 6:51:18 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 23771 ...
2023-12-11 6:51:18 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
2023-12-11 6:51:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2023-12-11 6:51:18 0 [Note] InnoDB: Number of transaction pools: 1
2023-12-11 6:51:18 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-12-11 6:51:18 0 [Note] InnoDB: Using Linux native AIO
2023-12-11 6:51:18 0 [Note] InnoDB: Initializing buffer pool, total size = 4294967296, chunk size = 134217728
2023-12-11 6:51:18 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 42437
2023-12-11 6:51:18 0 [Warning] InnoDB: Ignoring malformed log record at LSN 42437
2023-12-11 6:51:18 0 [Warning] InnoDB: Ignoring malformed log record at LSN 42437
2023-12-11 6:51:18 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 42437
2023-12-11 6:51:18 0 [Warning] InnoDB: Ignoring unknown log record at LSN 42574
2023-12-11 6:51:18 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 42574
2023-12-11 6:51:18 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 42574
2023-12-11 6:51:18 0 [Warning] InnoDB: Ignoring malformed log record at LSN 42574
2023-12-11 6:51:18 0 [Warning] InnoDB: Ignoring malformed log record at LSN 42574
2023-12-11 6:51:18 0 [Warning] InnoDB: Ignoring malformed log record at LSN 42574
2023-12-11 6:51:19 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 42389 between the checkpoint 42389 and the end 525846992.
2023-12-11 6:51:19 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2023-12-11 6:51:19 0 [Note] InnoDB: Starting shutdown...
2023-12-11 6:51:19 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-12-11 6:51:19 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-12-11 6:51:19 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-12-11 6:51:19 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2023-12-11 6:51:19 0 [ERROR] Aborting
231211 06:51:19 mysqld_safe mysqld from pid file /www/server/data/localhost.localdomain.pid ended
and all, what will help - reinstall to 10.6 ver