mariaDB 10.1原始碼安裝
[root@localhost yum.repos.d]# yum -y install gcc*
[root@localhost yum.repos.d]# yum -y install ncurses-devel
[root@localhost yum.repos.d]# yum install bison bison-devel ncurses libxml2 libxml2-devel cmake #cmake 要求版本2.8以上
[root@localhost ~]# useradd mysql
[root@localhost ~]# mkdir /mariaDB/{data,logs,socket} -p
[root@localhost ~]# chown mysql:mysql /mariaDB/ -R
[root@localhost ~]# chmod 777 /mariaDB/socket/
[root@localhost ~]# tar -xzvf mariadb-10.1.22.tar.gz
[root@localhost ~]# cd mariadb-10.1.22
cmake \
-DCMAKE_INSTALL_PREFIX=/mariaDB \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_XTRADB_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATEDX_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
-DCOMPILATION_COMMENT='MariaDB 10.1 production environment' \
-DWITH_READLINE=ON \
-DSYSCONFDIR=/mariaDB/data \
-DMYSQL_UNIX_ADDR=/mariaDB/socket/socket \
-DMYSQL_DATADIR=/mariaDB/data
[root@localhost ~]# make
[root@localhost ~]# make install
[root@localhost ~]# vi /mariaDB/my.cnf
[client]
port = 3306
socket = /mariaDB/data/mysql.sock
[mysql]
no-auto-rehash
[mysqld]
server-id = 1
user = mysql
port = 3306
socket = /mariaDB/socket/mysql.sock
basedir = /mariaDB
datadir = /mariaDB/data
default-storage-engine = InnoDB
external-locking = FALSE
skip-name-resolve
#connect options
back_log = 600 #
max_connections = 1000
max_connect_errors = 10 #number which allow to connect server for error password
connect_timeout=20 #The number of seconds that the mysqld server waits for a connect packet
max_allowed_packet = 32M
### Table Cache Settings
table_open_cache = 800 ## Range: 64~ 524288
open_files_limit = 5000
tmp_table_size = 2G #recommend same size as tmp_table_size
max_heap_table_size = 2G #recommend 256 min
### Thread Cache
thread_cache_size = 64
#thread_stack = 192K
### Query Cache
query_cache_size = 64M
query_cache_limit = 4M
### Per-Thread Buffers
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 64M
join_buffer_size = 2M
thread_stack = 512k
##transaction infomation
transaction_isolation = READ-COMMITTED
#slog log
slow_query_log_file=/mariaDB/logs/slow-log.log
slow_query_log=1
long_query_time=4 #set time when executing is more this time,the sql be writen in slow log
log_queries_not_using_indexes=1 #when executing sql,the table have not index for the sql, the sql will be writen in slow log
##bin log
log-bin = /mariaDB/logs/ray-bin.log
binlog_cache_size = 10M
max_binlog_cache_size = 8M
max_binlog_size = 128M
expire_logs_days = 7
binlog_format = ROW
binlog_stmt_cache_size = 10M
key_buffer_size = 256MB
lower_case_table_names = 1
###innodb options
innodb_buffer_pool_instances=8
innodb_file_per_table = on
innodb_thread_concurrency = 8
innodb_read_io_threads = 16 ##2*cpu個數*cpu核數,個人建議與cpu核數相等或2倍
innodb_write_io_threads = 16
##innodb memery
innodb_buffer_pool_size = 512M
innodb_max_dirty_pages_pct = 70
innodb_lock_wait_timeout = 120
##redo log
innodb_log_buffer_size = 16M
innodb_log_file_size = 128M
innodb_log_files_in_group = 3
innodb_flush_log_at_trx_commit = 1
autocommit=0
#set independent undo
innodb_undo_directory=/mariaDB/data
innodb_undo_logs=128
innodb_undo_tablespaces=4
[mysqldump]
quick
max_allowed_packet = 32M
[mysqld_safe]
log-error=/mariaDB/logs/mysql_ray.err
pid-file=/mariaDB/data/ray.pid
|
/mariaDB/scripts/mysql_install_db --user=mysql --basedir=/mariaDB --datadir=/mariaDB/data --innodb_undo_tablespaces=4 --defaults-file=/mariaDB/my.cnf
/mariaDB/bin/mysqld_safe --defaults-file=/mariaDB/my.cnf 2>&1 > /dev/null &
vi /mariaDB/mysqld
#!/bin/bash
mysql_port=3306
mysql_username="root"
mysql_password="123456"
function_start_mysql()
{
printf "Starting MySQL...\n"
/bin/sh /mariaDB/bin/mysqld_safe --defaults-file=/mariaDB/my.cnf 2>&1 > /dev/null &
}
function_stop_mysql()
{
printf "Stoping MySQL...\n"
/mariaDB/bin/mysqladmin -u ${mysql_username} -p${mysql_password} -S /mariaDB/socket/mysql.sock shutdown
}
function_restart_mysql()
{
printf "Restarting MySQL...\n"
function_stop_mysql
function_start_mysql
}
function_kill_mysql()
{
kill -9 $(ps -ef | grep 'bin/mysqld_safe' | grep ${mysql_port} | awk '{printf $2}')
kill -9 $(ps -ef | grep 'libexec/mysqld' | grep ${mysql_port} | awk '{printf $2}')
}
case $1 in
start)
function_start_mysql;;
stop)
function_stop_mysql;;
kill)
function_kill_mysql;;
restart)
function_stop_mysql
function_start_mysql;;
*)
echo "Usage: /mariaDB/mysqld {start|stop|restart|kill}";;
esac
|
修改root密碼
[root@MariaDB ~]# mysqladmin -uroot password '123456'
[root@MariaDB ~]# mysql -uroot -p'123456' -S /mariaDB/socket/mysql.sock
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28572479/viewspace-2137012/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MariaDB 10.1原始碼安裝流程(CentOS 6.5)原始碼CentOS
- MariaDB 10.1原始碼安裝執行mysql_install_db報錯"system tables failed"原始碼MySqlAI
- MariaDB 10.1原始碼安裝報錯"Unknown CMake command "CHECK_CXX_SYMBOL_EXISTS""原始碼Symbol
- centos7.4原始碼安裝php,swoole,nginx,redis,mariadbCentOS原始碼PHPNginxRedis
- MariaDB安裝
- 原始碼編譯安裝 httpd2.4+MariaDB5.5+php5.4(LAMP)原始碼編譯httpdPHPLAMP
- MariaDB 安裝配置
- MariaDB原始碼除錯原始碼除錯
- 35_安裝mariadb
- LAMP原始碼安裝+wordpress安裝LAMP原始碼
- 在Ubuntu上安裝MariaDBUbuntu
- Centos下安裝mariaDB方法CentOS
- MariaDB的安裝與配置
- centos7 安裝 mariadbCentOS
- nginx原始碼安裝Nginx原始碼
- 原始碼安裝postgresql原始碼SQL
- 原始碼安裝openresty原始碼REST
- 原始碼安裝GO原始碼Go
- Nginx 原始碼安裝Nginx原始碼
- mysql原始碼安裝MySql原始碼
- zabbix原始碼安裝原始碼
- 原始碼安裝lamp原始碼LAMP
- 原始碼安裝MySQL原始碼MySql
- 原始碼安裝Nginx原始碼Nginx
- 【推薦 - 原始碼安裝】nginx - 安裝原始碼Nginx
- centos7 yum 安裝mariadbCentOS
- OS X編譯安裝Mariadb編譯
- MariaDB 10.1 每秒可處理一百萬查詢
- yum安裝與原始碼安裝比較原始碼
- MySQL 5.7.28 原始碼安裝MySql原始碼
- docker原始碼安裝NginxDocker原始碼Nginx
- macbook 原始碼安裝 redisMac原始碼Redis
- macbook 原始碼安裝 nginxMac原始碼Nginx
- Centos原始碼安裝NginxCentOS原始碼Nginx
- Redis 4.0原始碼安裝Redis原始碼
- mysql 5.1原始碼安裝MySql原始碼
- mysql-原始碼安裝MySql原始碼
- 原始碼安裝python原始碼Python