#PERCONA OPTIMAGE MYSQL 5.7 MANUAL#

As per these tips, add this to the config file under the section: innodb_buffer_pool_size = 1G # (adjust value here, 50%-70% of total RAM)

#PERCONA OPTIMAGE MYSQL 5.7 MANUAL#

The following manual tweaks should be made out of the box.

Note: modify the above path to match the config fileвЂ™s real location вЂ“ itвЂ™s possible that itвЂ™s actually in /etc/mysql//mysqld.cnf Manual Tweaks

Otherwise, use a simple text editor like vim by executing sudo vim /etc/mysql/my.cnf. If youвЂ™re editing locally on a Vagrant box, you can copy the file out into the main filesystem by copying it into the shared folder with cp /etc/mysql/my.cnf /home/vagrant/Code and editing it with a regular text editor, then copying it back into place when done. Even if you havenвЂ™t been exposed to it yet, now is as good a time as any. YouвЂ™ll need to be comfortable with using the command line. ItвЂ™s possible that your installation will actually load a secondary configuration file into that configuration file, so look into that вЂ“ if the my.cnf file doesnвЂ™t have much content, the file /etc/mysql//mysqld.cnf might. WeвЂ™ll assume youвЂ™re using a Linux-based host or a good Vagrant box like our Homestead Improved so your configuration file will be in /etc/mysql/my.cnf. 5.7 (the current version) has much better defaults than its predecessors, but itвЂ™s still easy to make improvements on top of those. The first вЂ“ and most skipped! вЂ“ performance upgrade every user of MySQL should do is tweak the configuration.

Percona optimage mysql 5.7