major/MySQLTuner-perl
View on GitHub ↗ ★ 9,475 Perl
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.
10 mentions on Hacker News by 9 people: 2 stories, 8 comments · first 2013-12-13 · latest 2024-04-13
20082026
-
…I have successfully tuned a couple of mysql/mariadb servers in the past with the help of Mysqltuner https://github.com/major/MySQLTuner-perl
comment by nightshift1 · 2024-04-13 · in MySQL-Manage Memory Usage Efficiently -
…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
comment by LinuxBender · 2022-01-12 · in In MySQL, use “utf8mb4” instead of “utf8” (2016) -
…tools like MySQLTuner [1]. [0] https://ottertune.com/blog/benchmark-using-machine-learning-... [1] https://github.com/major/MySQLTuner-perl
comment by SerCe · 2021-10-02 · in You Are Overpaying Jeff Bezos for Your Databases -
…tools are not perfect, but may be informative. [1] - https://github.com/jfcoz/postgresqltuner [2] - https://github.com/major/MySQLTuner-perl
comment by LinuxBender · 2021-03-10 · in Ask HN: What is the future for Oracle DBAs? -
…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…
comment by Twirrim · 2019-03-18 · in Simple script to analyse your PostgreSQL database config, give tuning advice -
To set these variables appropriate for your system, I recommend the MySQL tuner script: https://github.com/major/MySQLTuner-perl
comment by wvenable · 2017-10-16 · in Efficient pagination of a SQL table with 100M records -
I assume you are referring to this project [1]. 1. https://github.com/major/MySQLTuner-perl
comment by danieltillett · 2017-06-03 · in Tuning Your DBMS Automatically with Machine Learning -
…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...
comment by elbac · 2013-12-13 · in How MySQL memory table saved the day