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.
0 kommentar(er)
