Ubuntu 18.04 with MySQL 5.7

"Walker Process"

• Installation

~# sudo apt install mysql-server mysql-client

• Modify or add in the/etc/mysql/mysql.conf.d/mysqld.cnf file

# Modify Bindings ipbind-address = 0.0.0.0# Set max memory Innodb_buffer_pool_size = 20G

• To see if the modification was successful (the unit of value is Bytes)
  

# enter MySQL after mysql> show variables like ' innodb_buffer_pool_size '; +-------------------------+-------------+| variable_name | Value |+-------------------------+-------------+| Innodb_buffer_pool_size | 21474836480 |+-------------------------+-------------+1 row in Set (0.00 sec)

"Related reading"

• The performance options to be adjusted immediately after MySQL 5.7 installation is complete
  

Walker * * *

Ubuntu 18.04 with MySQL 5.7