MariaDB - Korean

use the xtrabackup

my.cnf client] port = 3306 socket = /tmp/mysql.sock

[mysqld] port = 3306 socket = /tmp/mysql.sock skip-external-locking key_buffer_size = 512M bulk_insert_buffer_size = 128M max_allowed_packet = 512M table_open_cache = 512 sort_buffer_size = 128M read_buffer_size = 128M read_rnd_buffer_size = 128M myisam_sort_buffer_size = 256M thread_cache_size = 500 query_cache_size = 128M

1. Try number of CPU's*2 for thread_concurrency
2. thread_concurrency = 32 innodb_force_recovery=1 skip-name-resolve skip-host-cache

lower_case_table_names = 1

slave-skip-errors=1062,1032,1594

log-bin=mysql-bin server-id = 5 binlog_format=mixed

slave_parallel_threads = 32

max_connections = 6000 wait_timeout= 240 connect_timeout = 240 interactive_timeout = 240 default_storage_engine = InnoDB

1. innodb_data_file_path = ibdata1:1024M;ibdata2:1024M;ibdata3:1024M;ibdata4:1024M;ibdata5:10M:autoextend innodb_data_file_path = ibdata1:2024M;ibdata2:2024M;ibdata3:2024M;ibdata4:2024M;ibdata5:1024M:autoextend
2. innodb_data_file_path = ibdata1:1024M:autoextend
3. innodb_data_file_path = ibdata1:2048M;ibdata2:2048M:autoextend innodb_buffer_pool_size = 70G innodb_additional_mem_pool_size = 512M
4. Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 10G innodb_log_buffer_size = 8G innodb_flush_log_at_trx_commit = 2 table_definition_cache = 2048

[mysqldump] quick max_allowed_packet = 512M

[mysql] no-auto-rehash

1. Remove the next comment character if you are not familiar with SQL
2. safe-updates

[myisamchk] key_buffer_size = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M

[mysqlhotcopy] interactive-timeout

1. error

230810 15:25:10 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 2023-08-10 15:25:11 140388023613568 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.34-MariaDB) starting as process 14620 ... 2023-08-10 15:25:11 7faea2473880 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2023-08-10 15:25:11 140388023613568 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2023-08-10 15:25:11 140388023613568 [Note] InnoDB: The InnoDB memory heap is disabled 2023-08-10 15:25:11 140388023613568 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2023-08-10 15:25:11 140388023613568 [Note] InnoDB: GCC builtin atomic_thread_fence() is used for memory barrier 2023-08-10 15:25:11 140388023613568 [Note] InnoDB: Compressed tables use zlib 1.2.7 2023-08-10 15:25:11 140388023613568 [Note] InnoDB: Using SSE crc32 instructions 2023-08-10 15:25:11 140388023613568 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2023-08-10 15:25:13 140388023613568 [Note] InnoDB: Completed initialization of buffer pool 2023-08-10 15:25:16 140388023613568 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2023-08-10 15:25:16 140388023613568 [Note] InnoDB: Setting file ./ibdata1 size to 2024 MB 2023-08-10 15:25:21 140388023613568 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created 2023-08-10 15:25:21 140388023613568 [Note] InnoDB: Setting file ./ibdata2 size to 2024 MB 2023-08-10 15:25:26 140388023613568 [Note] InnoDB: Data file ./ibdata3 did not exist: new to be created 2023-08-10 15:25:26 140388023613568 [Note] InnoDB: Setting file ./ibdata3 size to 2024 MB 2023-08-10 15:25:31 140388023613568 [Note] InnoDB: Data file ./ibdata4 did not exist: new to be created 2023-08-10 15:25:31 140388023613568 [Note] InnoDB: Setting file ./ibdata4 size to 2024 MB 2023-08-10 15:25:36 140388023613568 [Note] InnoDB: Data file ./ibdata5 did not exist: new to be created 2023-08-10 15:25:36 140388023613568 [Note] InnoDB: Setting file ./ibdata5 size to 1024 MB 2023-08-10 15:25:39 140388023613568 [Note] InnoDB: Setting log file ./ib_logfile101 size to 10240 MB 2023-08-10 15:26:04 140388023613568 [Note] InnoDB: Setting log file ./ib_logfile1 size to 10240 MB 2023-08-10 15:26:31 140388023613568 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2023-08-10 15:26:31 140388023613568 [Warning] InnoDB: New log files created, LSN=45782 2023-08-10 15:26:31 140388023613568 [Note] InnoDB: Doublewrite buffer not found: creating new 2023-08-10 15:26:31 140388023613568 [Note] InnoDB: Doublewrite buffer created 2023-08-10 15:26:31 140388023613568 [Note] InnoDB: 1 rollback segment(s) are active. 2023-08-10 15:26:31 140388023613568 [ERROR] InnoDB: Database creation was aborted at /usr/local/src/mariadb-10.1.34/storage/xtradb/srv/srv0start.cc [2969] with error Generic error. You may need to delete the ibdata1 file before trying to start up again. 2023-08-10 15:26:31 140388023613568 [ERROR] Plugin 'InnoDB' init function returned error. 2023-08-10 15:26:31 140388023613568 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-08-10 15:26:31 140388023613568 [Note] Plugin 'FEEDBACK' is disabled. 2023-08-10 15:26:31 140388023613568 [ERROR] Unknown/unsupported storage engine: InnoDB 2023-08-10 15:26:31 140388023613568 [ERROR] Aborting

why can't start mariadb pls...