MySQL tuning with my.cnf settings optimisation
-
@marcusquinn Bookmarked this as a resource, thanks for collecting all of this!
-
@Lonk Interesting isn't it. Often I get "received wisdom" saying defaults are usually best - but in this case, you might be scaling your VPS to 32 cores and still only using 1 without knowing it if you didn't sanity-check those defaults.
Web Design https://www.evergreen.je
Development https://brandlight.org
Life https://marcusquinn.com -
@marcusquinn don't forget the good old http://mysqltuner.pl/
-
About a decade ago, there was an idea for a project to do this app wide.
As in have a profiler be able to tune any App (via config files and runtime params) it was aware of dynamically during various user loads.
Initially meant for cluster Apps, but easily applies to single apps too.
Feedback loops handle all the parameters automagically.
-
@robi said in MySQL tuning with my.cnf settings optimisation:
About a decade ago, there was an idea for a project to do this app wide.
As in have a profiler be able to tune any App (via config files and runtime params) it was aware of dynamically during various user loads.
Initially meant for cluster Apps, but easily applies to single apps too.
Feedback loops handle all the parameters automagically.
Did anything come of it?
-
@fbartels said in MySQL tuning with my.cnf settings optimisation:
@marcusquinn don't forget the good old http://mysqltuner.pl/
Never saw this before, when do we run / apply it? Anytime or only during installation?
-
@marcusquinn In the cloudron context, where does my.cnf goes to be taken into account ?
-
@fbartels said in MySQL tuning with my.cnf settings optimisation:
@lonk said in MySQL tuning with my.cnf settings optimisation:
when do we run / apply it?
Mysql tuning is best applied after a few days of database usage. Applications usually have different load patterns.
Gotcha, thanks for the tip!
️
