北风之神

1,调整最大文件数限制 ulimit -n 1024          #这个是默认值 echo ulimit -n 65535 >>/etc/profile  source /etc/profile    #加载修改后的profile  ulimit -n     #显示65535，修改完毕！  2,修改IO调度器设置 [root@mysql

[client] user = root password = QWdslcfjz^0$ [mysql] prompt = [\\u@\\h][\\d]>\\_ [mysqld] # basic settings # user = mysql sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_

CentOS系统参数优化 众所周知，Mysql能安装在各大操作系统上，特别是对于很多个人开发者，都喜欢把开发放在windows上面，但是实际上线的项目都是需要部署到服务器上。虽然说Windows也能作服务器，但实际应用中比较少，而更多的是使用基于Linux的CentOS系统，原因自然是稳定安全性高，并且CentOS也是免费的操作系统。 所以这里是针对MySQL的性能进行的CentOS系统参数的

grant replication slave on *.* to 'rpl'@'%' identified by 'asdfasdf'; mysqldump --single-transaction --master-data=1 -A > a.sql CHANGE MASTER TO MASTER_HOST='192.168.1.128', MASTER

mysql_config_editor set -G mysql2 -uroot -p -S /opt/mysql/data2/mysql.sock3307 mysql --login-path=mysql2 mysql_config_editor print mysql_config_editor set -G mysql2 -uroot -p -S /opt/my

[client] user = root password = xxxx  这里是为了在mysql登录的时候直接-S，不需要输入密码 [mysql] prompt = [\\u@\\h][\\d]>\\_ [mysqld] # basic settings # user = mysql sql_mode = "STRICT_TRANS_TABLES,NO_EN

# author: jiangchengyao@gmail.com This configration file opts for MySQL 5.6 and 5.7. If you have any problem, dont hesitate to concact me.  Let us make an optimal MySQL configuration file templa

2.2 Installing MySQL on Unix/Linux Using Generic Binaries Oracle provides a set of binary distributions of MySQL.  These include generic binary distributions in the form of compressed tar files

[root@python data3306]# mysql -u root -p Enter password:  Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.7.14-7-log Percona Server (GPL),

1,调整最大文件数限制 ulimit -n 1024 #这个是默认值 echo ulimit -n 65535 >>/etc/profile source /etc/profile #加载修改后的profile ulimit -n #显示65535，修改完毕！ 2,修改IO调度器设置 [root@mysql support-files]# cat /

初始化数据库 /opt/mysql/scripts/mysql_install_db --basedir=/opt/mysql --datadir=/opt/mysql/data3306 --user=mysql /opt/mysql/scripts/mysql_install_db --basedir=/opt/mysql --datadir=/opt/mysql/data3307 --us

[client] user = root password = QWdslcfjz^0$ [mysql] prompt = [\\u@\\h][\\d]>\\_ [mysqld] # basic settings # user = mysql sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_