1105/usr/地方/mysql
2。
105/etc/my . cnf中所做3。mkdir/数据/mysql/日志}{数据,tmp、binlog - p
4。
,
rpm qa mysql
百胜删除mysql - 5.1.73 - 8. - el6_8.x86_64
/etc/my.cnf.bak /etc/my . cnf中所做;
yum安装libaio *
useradd mysql mkdir/数据/mysql/日志}{数据,tmp、binlog - p
乔恩- r mysql。mysql/数据/mysql
tar xf/tmp/mysql-5.6.20-linux-glibc2.5-x86_64.tar。广州- c/usr/local/cd/usr/local/
mv mysql-5.6.20-linux-glibc2.5-x86_64 mysql
乔恩- r mysql。mysql/usr/local/mysql cd/usr/local/mysql/scripts
。/mysql_install_db——datadir=/数据/mysql/数据——basedir=/usr/地方/mysql——用户=mysql explicit_defaults_for_timestamp
回声“/usr/地方/mysql/lib”在/etc/ld.so.conf.d/mysql。相依,,ldconfig - v
ln - s/usr/local/mysql/include/usr/include/mysql
cp/usr/local/mysql/support-files/mysql.server/etc/init。d/mysqld
在
chkconfig mysqld回声”exportPATH=$路径:/usr/地方/mysql/bin”比;/etc/profile.d/mysql.sh源/etc/profile
/etc/init。d/mysqld重启
p ef | grep mysql
mysqladmin -uroot密码' Z ' s,/数据/mysql/mysqld。袜子
mysql -uroot - p - s/数据/mysql/mysqld。mysql袜子
删除数据库测试;降低用户root@:: 1,减少用户“@ localhost,降低用户”@“localhost.localdomain”;把用户“根”@“localhost.localdomain”;选择用户,从mysql.user主机;冲洗特权;
以及添加天兔天兔座监控mysql
格兰特插入、更新、删除、创建、选择、超级,过程中,重载,showdatabases,复制客户端*。* 'lepus_monitor“@”被“LepUs@zy@MoniTOR”;冲洗特权;
配mysql5.6.20 my . cnf中所做置文件
服务器环境为dellr710服务器,内存:60 g, cpu是超线程
(mysqld)
back_log=2000
basedir=/usr/local/mysql
binlog-format=混合
character_set_server=utf8
datadir=/数据/mysql/
event_scheduler=在
expire_logs_days=1
innodb_autoinc_lock_mode=1通过innodb_buffer_pool_size=1073741824
innodb_data_file_path=ibdata1:500M: autoextend
innodb_data_home_dir=/数据/mysql/
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=2
innodb_flush_method=O_DIRECT
innodb_io_capacity=2000
innodb_log_buffer_size=8388608
innodb_log_files_in_group=3
innodb_log_group_home_dir=/数据/mysql/
innodb_max_dirty_pages_pct=50
innodb_open_files=1024
innodb_read_io_threads=8
innodb_thread_concurrency=20
innodb_write_io_threads=8
innodb_lock_wait_timeout=10
innodb_buffer_pool_load_at_startup=1
innodb_buffer_pool_dump_at_shutdown=1
key_buffer_size=3221225472
innodb_log_file_size=1 g
local_infile=1
log-bin=/数据/mysql/binlog/mysql-bin。日志
log_bin_trust_function_creators=1
log_output=文件long_query_time=1
日志错误=/数据/mysql/日志/错误。日志
max_allowed_packet=33554432
max_connect_errors=1000000
max_connections=2000
myisam_sort_buffer_size=33554432
myisam_recover=1
join_buffer_size=8388608
tmp_table_size=33554432
net_buffer_length=8192
performance_schema=1
performance_schema_max_table_instances=200
pid文件=/数据/mysql/mysqld。pid
=3306港
query_cache_size=0
query_cache_type=0
read_buffer_size=20971520
read_rnd_buffer_size=16 m
max_heap_table_size=33554432
bulk_insert_buffer_size=134217728
# relay-log=/数据/mysql/日志/mysql-relay。日志
secure-file-priv=/数据/mysql/tmp
服务器id=1131053306
skip-slave-start
skip_name_resolve
slave-load-tmpdir=/数据/mysql/tmp
slow-query-log-file=/数据/mysql/日志/mysql-slow。日志
slow_query_log=1
套接字=/数据/mysql/mysqld。袜子
sort_buffer_size=2097152
sync_binlog=1
table_open_cache=128
thread_cache_size=50
tmpdir=/数据/mysql/tmp mysql用户=
wait_timeout=120
transaction_isolation=读取提交
long_query_time=1
sync_binlog=0
innodb_flush_log_at_trx_commit=0
(mysqld_safe)日志错误=/数据/mysql/日志/错误。日志
pid文件=/数据/mysql/mysqld。pid