BrnDmp

MySQL tuning and maintenance

Analyzing MySQL instances on Moodle servers with tuning scripts:

• mysqltuner.pl
• tuning-primer.sh
• mysqlreport

Damn, can’t seem to set mysql variables at runtime. Should be able with mysql –variable_name=value or, when in mysql, with set global variable_name = value or, when changing the running session: set @@variable_name=value;

Does not work for open_files_limit but it does work for set @@long_query_time =5 ; .

Optimized all tables with ‘mysqlcheck -o -A’ (-o = optimize and -A is all tables).