![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql基础
文章平均质量分 80
oracle_liuchao
这个作者很懒,什么都没留下…
展开
-
mysql5.6.20编译安装
1,调整最大文件数限制ulimit -n1024 #这个是默认值echo ulimit -n 65535 >>/etc/profile source /etc/profile #加载修改后的profile ulimit -n #显示65535,修改完毕! 2,修改IO调度器设置[root@mysql原创 2014-09-11 15:13:36 · 430 阅读 · 0 评论 -
mysql组复制单主模式
[client]user = rootpassword = QWdslcfjz^0$[mysql]prompt = [\\u@\\h][\\d]>\\_[mysqld]# basic settings #user = mysqlsql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_原创 2017-10-30 06:07:10 · 677 阅读 · 0 评论 -
mysql centos操作系统优化
CentOS系统参数优化众所周知,Mysql能安装在各大操作系统上,特别是对于很多个人开发者,都喜欢把开发放在windows上面,但是实际上线的项目都是需要部署到服务器上。虽然说Windows也能作服务器,但实际应用中比较少,而更多的是使用基于Linux的CentOS系统,原因自然是稳定安全性高,并且CentOS也是免费的操作系统。所以这里是针对MySQL的性能进行的CentOS系统参数的转载 2017-10-28 09:17:09 · 420 阅读 · 0 评论 -
mysql 5.7主从同步简单配置
grant replication slave on *.* to 'rpl'@'%' identified by 'asdfasdf';mysqldump --single-transaction --master-data=1 -A > a.sqlCHANGE MASTER TOMASTER_HOST='192.168.1.128',MASTER原创 2017-09-22 14:19:03 · 287 阅读 · 0 评论 -
mysql_config_editor实现mysql无密码登录
mysql_config_editor set -G mysql2 -uroot -p -S /opt/mysql/data2/mysql.sock3307mysql --login-path=mysql2mysql_config_editor printmysql_config_editor set -G mysql2 -uroot -p -S /opt/my原创 2017-09-22 13:59:52 · 354 阅读 · 0 评论 -
mysql 5.7多实例安装
[client]user = rootpassword = xxxx 这里是为了在mysql登录的时候直接-S,不需要输入密码[mysql]prompt = [\\u@\\h][\\d]>\\_[mysqld]# basic settings #user = mysqlsql_mode = "STRICT_TRANS_TABLES,NO_EN原创 2017-09-22 13:53:45 · 294 阅读 · 0 评论 -
mysql 5.6 5.7 my.cnf配置文件
# author: jiangchengyao@gmail.comThis 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转载 2017-09-12 09:40:51 · 2206 阅读 · 0 评论 -
mysql5.7官方文档翻译之:Installing MySQL on Unix/Linux Using Generic Binaries
2.2 Installing MySQL on Unix/Linux Using Generic BinariesOracle provides a set of binary distributions of MySQL. These include generic binary distributions in the form of compressed tar files翻译 2017-09-11 15:23:28 · 312 阅读 · 0 评论 -
percona mysql5.7.14安装tokudb引擎
[root@python data3306]# mysql -u root -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 7Server version: 5.7.14-7-log Percona Server (GPL),原创 2016-08-25 13:42:35 · 2062 阅读 · 0 评论 -
percona server的安装启动配置
1,调整最大文件数限制ulimit -n1024 #这个是默认值echo ulimit -n 65535 >>/etc/profile source /etc/profile #加载修改后的profile ulimit -n #显示65535,修改完毕! 2,修改IO调度器设置[root@mysql support-files]# cat /原创 2014-09-13 16:01:55 · 2655 阅读 · 0 评论 -
mysql多实例的配置
初始化数据库/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原创 2014-09-12 13:54:17 · 372 阅读 · 0 评论 -
mysql多实例组复制配置
[client]user = rootpassword = QWdslcfjz^0$[mysql]prompt = [\\u@\\h][\\d]>\\_[mysqld]# basic settings #user = mysqlsql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_原创 2017-10-26 11:35:34 · 408 阅读 · 0 评论