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...
-
About the Knowledge Base
MariaDB Knowledge Base의 목적과 조직에 대한 설명 -
MariaDB Server 문서
MariaDB 사용을 위한 문서 -
MariaDB Server Releases
MariaDB 릴리스와 정책 및 절차에 대한 정보 -
Training & Tutorials
MariaDB와 관련된 소프트웨어를 위한 학습 자료들과 튜토리얼 문서 -
Video Presentations & Screencasts
컨퍼런스, 웨비나 및 스크린 캐스트의 프레젠테이션 비디오. -
Frequently Asked Questions
MariaDB Foundation, Corporation, 커뮤니티 및 소프트웨어에 대해 자주 묻는 질문입니다. ... -
Bug Tracking
커뮤니티에서 버그를 제보하고 기능 요청을 제출하는 방법과 위치, 그리고 벅그 리포트가 커뮤니티 사용자들을 위해 어떻게 처리되는지에 대해... -
Server & Client Software
MariaDB 서버와 클라이언트, 그리고 관련된 소프트웨어를 다운로드 받으세요 ... -
The Community
MariaDB 커뮤니티: 뉴스, 정보 및 참여 방법 -
Whitepapers
MariaDB 제품 백서 -
MariaDB Success Stories
MariaDB가 실제 문제를 풀기 위해 어떻게 사용되고 있는지 보여주는 사례 연구, 뉴스 기사 및 사용 사례 ... -
MariaDB 와 MySQL - 기능
See also MariaDB vs MySQL - Compatibility 더 많은 스토리지 엔진 표준화된 -
MariaDB와 MySQL - 호환성
MariaDB v.s MySQL 백서를 다운로드할 수 있습니다. [[mariadb-vs-mysql-fe -
MySQL에서 MariaDB로 업그레이드 하기!
MariaDB 와 MySQL 비교를 살펴보고, MySQL를 업그레이드 하려한다면 MariaDB도 고려해보자. 윈도우즈를 사용하고 있다면...