MySQLTuner-perl

I am not a dba but I have successfully tuned a couple of mysql/mariadb servers in the past with the help of Mysqltuner https://github.com/major/MySQLTuner-perl

Would the DBA's on this thread consider committing code to the MySQL [1] and Postgres [2] tuner scripts that give new DBA's all your learned advise and battle hardening experience? This thread appears to be such an example. [1] - https://github.com/major/MySQLTuner-perl [2] - https://github.com/jfcoz/postgresqltuner

Something interesting that wasn't mentioned in this article, but was mentioned in the other Ottertune blog article [0] is that significant performance improvements can be achieved with the help of open-source tools like MySQLTuner [1]. [0] https://ottertune.com/blog/benchmark-using-machine-learning-... [1] https://github.com/major/MySQLTuner-perl

I am not a DBA but I work with many of them. Most of the DBA's I currently work with have/had Oracle experience, but they are currently supporting MySQL. Some of them also know Postgres. There will always be a need for database engineers and architects. Even knowing how to optimize queries can be quite valuable to a company. Already being an Oracle DBA it should be rather easy for her to pick up the open source databases and widen her career opportunities. IIRC there are even blogs where former Oracle DBA's wrote how-to's that summarize command equivalents for Oracle -> MySQL and Oracle -> Postgres so that if you already know one, you can see the equivalent commands in the corresponding technologies. As a side note, there are also some git repos that have optimizing scripts for MySQL and Postgres that may also help her learn some of

So does Oracle DB as well. In the mysql world, mysqltuner has been kicking around for more than a decade now that spits out suggested configuration changes. I haven't had a need to use it in several years though https://github.com/major/MySQLTuner-perl There was an interesting project around applying blackbox optimisation to MySQL, called OtterTune on which a paper was published a couple of years ago, https://blog.acolyer.org/2017/08/11/automatic-database-manag.... They got some good results out of it. Haven't attempted to use it myself: https://github.com/cmu-db/ottertune There are just so many dials and switches that can be changed that can modify the performance of the database, it really has to be moving far beyond anything any one individual could possibly grok.

To set these variables appropriate for your system, I recommend the MySQL tuner script: https://github.com/major/MySQLTuner-perl

I assume you are referring to this project [1]. 1. https://github.com/major/MySQLTuner-perl

A better solution, is just to increase your innodb buffer size, you will get virtually same performance as the 'memory' table once all the data is in memory. Plus all the data will be persisted. This is an old, but still very useful script for helping to suggest what settings to tweak: https://github.com/major/MySQLTuner-perl http://dev.mysql.com/doc/refman/5.5/en/innodb-buffer-pool.ht...