centos6.8 mysql-5.6.21源码搭建笔记

# groupadd mysql 
# useradd mysql -g mysql -M -s /sbin/nologin 
#增加一个名为 mysql的用户。
-g：指定新用户所属的用户组(group)
-M：不建立根目录
-s：定义其使用的shell，/sbin/nologin代表用户不能登录系统。


需要创建
mkdir /data/mydata
mkdir /opt/mysql-5.6.21




[root@edu-mysql-01 mysql-5.6.21]# cmake \
-DCMAKE_INSTALL_PREFIX=/opt/mysql-5.6.21 \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/data/mydata \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306 \
-DENABLE_DOWNLOADS=1


注意事项：
重新编译时，需要清除旧的对象文件和缓存信息。
# make clean
# rm -f CMakeCache.txt
# rm -rf /etc/my.cnf




4.改变数据存储目录所有者为mysql




chown -R mysql.mysql /usr/local/mysql
chown -R mysql.mysql /data/mydata








## 初始化数据库


当前安装目录下执行以下
./scripts/mysql_install_db --user=mysql --basedir=/opt/mysql-5.6.21/ --datadir=/data/mydata --pid-file=/opt/mysql-5.6.21/mysql.pid  --tmpdir=/tmp


6.注册服务
cp support-files/mysql.server /etc/rc.d/init.d/mysqld
#使用默认配置文件
cp support-files/my-medium.cnf /etc/my.cnf  
（5.6之前的版本是此操作，读者也可在此时自己进入support-files文件夹下面，看是配置文件的真正名称，那个存在，就拷贝那个。。）---可自行创建my.cnf


#让chkconfig管理mysql服务
chkconfig --add mysqld




#开机启动
chkconfig mysqld on


#查看/opt/mysql-5.6.21 下重新生成的my.cnf 更改属组
ls -lah
[root@localhost mysql-5.6.21]# chown mysql.mysql my.cnf 


新建my.cnf
编辑/etc/my.cnf
# vi /etc/my.cnf
[client]
port = 3306
socket = /opt/mysql-5.6.21/mysql.sock
 
[mysqld]
character-set-server = utf8
collation-server = utf8_general_ci
 
skip-external-locking
skip-name-resolve
 
user = mysql
port = 3306
basedir = /opt/mysql-5.6.21
datadir = /opt/mysql-5.6.21/data
tmpdir = /opt/mysql-5.6.21/temp
# server_id = .....
socket = /opt/mysql-5.6.21/mysql.sock
log-error = /opt/mysql-5.6.21/mysql_error.log
pid-file = /opt/mysql-5.6.21/mysql.pid
 
open_files_limit = 10240
 
back_log = 600
max_connections=500
max_connect_errors = 6000
wait_timeout=605800
 
#open_tables = 600
#table_cache = 650
#opened_tables = 630
 
max_allowed_packet = 32M
 
sort_buffer_size = 4M
join_buffer_size = 4M
thread_cache_size = 300
query_cache_type = 1
query_cache_size = 256M
query_cache_limit = 2M
query_cache_min_res_unit = 16k
 
tmp_table_size = 256M
max_heap_table_size = 256M
 
key_buffer_size = 256M
read_buffer_size = 1M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 64M
 
lower_case_table_names=1
 
default-storage-engine = INNODB
 
innodb_buffer_pool_size = 2G
innodb_log_buffer_size = 32M
innodb_log_file_size = 128M
innodb_flush_method = O_DIRECT
 
#####################
thread_concurrency = 32
long_query_time= 2
slow-query-log = on
slow-query-log-file = /opt/mysql-5.6.21/mysql-slow.log 
 
[mysqldump]
quick
max_allowed_packet = 32M
 
[mysqld_safe]
log-error=/opt/mysql-5.6.21/log/mysqld.log
pid-file=/opt/mysql-5.6.21/mysqld.pid