MySQL源码安置
发布时间：2022-03-30 01:03:16 所属栏目：编程 来源：互联网
导读：MySQL源码安置： 1，下载源码安装包 5.5后版本需用cmake编译 mysql-5.7 需要 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/data/boost_1_59_0 yum install -y gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-dev
 MySQL源码安置： 1，下载源码安装包 5.5后版本需用cmake编译 mysql-5.7 需要 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/data/boost_1_59_0 yum install -y gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* CentOS7 磁盘扩容文件系统为xfs 最后LV扩容后重新识别使用xfs_growfs 2，解压安装.tar.gz tar zxvf cmake-3.4.1.tar.gz cd cmake-3.4.1 ./configure make make install tar –xvfz mysql-5.6.28.tar.gz cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 -DWITH_PARITION_STORAGE_ENGINE=1 -DWITH_READLINE=ON -DEXTRA_CHARSETS=all -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/data/3306 -DMYSQL_UNIX_ADDR=/data/3306/mysql.sock -DENABLED_LOCAL_INFILE=1 make && make install 3，建用户和目录 groupadd mysql useradd -r -g mysql mysql mkdir -p /usr/local/mysql chown -R mysql:mysql /usr/local/mysql mkdir -p /usr/local/mysql/data mkdir -p /data/{3306/{data,tmp,binlog},backup,scripts} chown -R mysql:mysql /data 4，设置用户系统资源限制 vi /etc/security/limits.conf mysql soft nproc 2047 mysql hard nproc 16384 mysql soft nofile 1024 mysql hard nofile 65536 5，初始化参数文件 vi /data/3306/my.cnf [client] port = 3306 socket = /data/3306/mysql.sock #The MYSQL SERVER [mysqld] port = 3306 user = mysql server-id = 111111 socket = /data/3306/mysql.sock pid-file = /data/3306/mysql.pid basedir = /usr/local/mysql datadir = /data/3306/data tmpdir = /data/3306/tmp open_files_limit = 10240 explicit_defaults_for_timestamp sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES #BUFFER max_allowed_packet = 256M max_heap_table_size = 256M net_buffer_length = 8K sort_buffer_size = 2M join_buffer_size = 4M read_buffer_size = 2M read_rnd_buffer_size = 16M #log log-bin = /data/3306/binlog/mysql-bin binlog_cache_size = 32m max_binlog_cache_size = 512m max_binlog_size = 512m binlog_format = mixed log_output = FILE log-error = ../mysql-error.log slow_query_log = 1 slow_query_log_file = ../slow_query.log general_log = 0 general_log_file = ../general_query.log expire-logs-days = 14 #InnoDB innodb_data_file_path = ibdata1:2048M:autoextend innodb_log_file_size = 256M innodb_log_files_in_group = 3 innodb_buffer_pool_size = 1024M [mysql] no-auto-rehash prompt = (u@h)[d]_ default-character-set = utf8 6，初始化MYSQL数据库 /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/3306/data 7，启动数据库服务 cp support-files/mysql.server /etc/init.d/mysql service mysql start #若启动不成功,查看是哪个my.cnf启动的 ./mysqld_safe --defaults-file=/data/3306/my.cnf （编辑：核心网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
