[walker 过程]
安装
~# sudo apt install mysql-server mysql-client
在 /etc/mysql/mysql.conf.d/mysqld.cnf 文件里面修改或添加
- # 修改绑定 ip
- bind-address = 0.0.0.0
- # 设置最大内存
- innodb_buffer_pool_size = 20G
查看是否修改成功 (数值的单位是 Bytes)
- # 进入 mysql 后
- mysql> show variables like 'innodb_buffer_pool_size';
- +-------------------------+-------------+
- | Variable_name | Value |
- +-------------------------+-------------+
- | innodb_buffer_pool_size | 21474836480 |
- +-------------------------+-------------+
- 1 row in set (0.00 sec)
来源: http://www.bubuko.com/infodetail-2593850.html