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...

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.