3 ms·
To set these variables appropriate for your system, I recommend the MySQL tuner script: https://github.com/major/MySQLTuner-perl https://github.com/major/MySQL
by wvenable 9y ago
To set these variables appropriate for your system, I recommend the MySQL tuner script:
https://github.com/major/MySQLTuner-perl https://github.com/major/MySQLTuner-perl
- a012 9y agoIs there similar tuning script for Postgres?
- danielsamuels 9y agoYes, pg_tune
- tkyjonathan 9y agoIs there a similar script for Redshift?
- Twirrim 9y agoIt's a great tool, but don't just apply advice blindly. It's guidance, not "this is the right thing to do", and some of the advice can harm as much much as help, because no one has size fits all (though I will found it to provide a excellent suggestions in general). Use it, look at the suggestions, and use that as an excellent springboard for reading up on what and why, and see how it could apply to your database.
- deleted 9y ago[deleted]