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
- Try number of CPU's*2 for thread_concurrency
- 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
- 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
- innodb_data_file_path = ibdata1:1024M:autoextend
- innodb_data_file_path = ibdata1:2048M;ibdata2:2048M:autoextend innodb_buffer_pool_size = 70G innodb_additional_mem_pool_size = 512M
- 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
- Remove the next comment character if you are not familiar with SQL
- safe-updates
[myisamchk] key_buffer_size = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M
[mysqlhotcopy] interactive-timeout
- 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...
Open Questions
-
InnoDB Error
아래와 같이 MARIADB상에서 에러가 발생되었습니다. MariaDB는 5.5 버전에서 10.1 버전으로 마이그레이션되어 있는 상태 입... -
Logcollector Access denied At Localhost
제너럴로그에 아래와 같은 로그가 매시간 33분에 찍히고 있습니다. logcollector이 로그수집을 위해 로컬로 붙는거 같으나 해당 ... -
트리거에서 order clause is ambiguous 오류 발생
MariaDB 10.0 버전에서는 정상적으로 동작했었는데 10.3 버전으로 올린 후에 아래와 같이 트리거에서 에러가 발생합니다. (Co...
Answered Questions
-
how to tune the huge memory system?
Hi experts, I have a one question. Recently, I am migrated Database from Or... -
Windows Server Migration
Our customers use Maria DB (10.2.9.0) in Windows Server 2008. The customer ...