qq_33996921的博客

1、修改my.cnf在my.cnf中添加skip-grant-tables;[root@VM_0_9_centos ~]# vim /etc/my.cnf[mysqld]bind-address=0.0.0.0port=3306user=mysqlbasedir=/usr/local/mysqldatadir=/usr/local/mysql/datasocket=/tmp/mysql.sock#添加此句话skip-grant-tables pid-file=/tmp/mys

为了方便记录一下MySQL的安装过程，特意写此文进行记录；1、安装环境[root@VM_0_9_centos ~]# lsb_release -aLSB Version: :core-4.1-amd64:core-4.1-noarch:cxx-4.1-amd64:cxx-4.1-noarch:desktop-4.1-amd64:desktop-4.1-noarch:languages-4.1...

MySQL的InnoDB存储引擎中，缓冲池中和系统表空间中都存在Changer Buffer，那它们之间的关系是怎样的呢？先来一张InnoDB存储引擎的架构图：翻阅了MySQL官网发现如下：1、https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html这里面有一句话： In memory, the change buffer occupies part of the buffer pool. On disk, the chan