mariadb 安装过程
发布时间：2022-03-30 11:21:06 所属栏目：搜索优化 来源：互联网
导读：## [client] port = 3306 socket = /data/mysql/data/mysql.sock slow_query_log = 1 slow_query_log_file = /data/mysql/data/slow.log log-error = /data/mysql/data/error.log long_query_time = 0.5 log_queries_not_using_indexes =1 log_throttle_quer
|
## [client] port = 3306 socket = /data/mysql/data/mysql.sock slow_query_log = 1 slow_query_log_file = /data/mysql/data/slow.log log-error = /data/mysql/data/error.log long_query_time = 0.5 log_queries_not_using_indexes =1 log_throttle_queries_not_using_indexes = 60 transaction_isolation = REPEATABLE-READ innodb_buffer_pool_size =50M innodb_buffer_pool_instances = 1 innodb_buffer_pool_load_at_startup = 1 innodb_buffer_pool_dump_at_shutdown = 1 #innodb_data_file_path = ibdata1:50M:autoextend innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 32M innodb_log_file_size = 50M innodb_log_files_in_group = 2 innodb_max_undo_log_size = 200M ## 源码安装 安装包mariadb-10.2.10.tar 软件目录 /opt/mysql 数据目录 /data/mysql/data yum install -y ncurses-devel openssl-devel openssl gcc-c++ cmake groupadd mysql useradd -g mysql mysql [mysqld] datadir=/data/mariadb/data socket=/data/mariadb/data/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/data/mariadb/data/mysqld.pid export PATH=$PATH:/usr/local/mysql chown -R mysql /data/mariadb 启动mysql mysqld_safe --defaults-file=/usr/local/mysql/my.cnf & 登陆mysql mysql -uroot -p --socket=/data/mariadb/data/mysql.sock （编辑：晋中站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
