8 Jul
2016
8 Jul
'16
2:16 a.m.
On 16-06-22 08:10 AM, Scott Ferguson wrote:
On 22/06/16 21:34, Placide Lysias NJAMI wrote:
Dear,
How to correct the warning message we have on our OTRS system registration? (See below)
InnoDB Log File Size (5 MB): The setting innodb_log_file_size must be at least 256 MB.
Thanks in advance!
1. stop mysql 2. edit my.cnf and change innodb_log_file_size *and make sure innodb_fast_shutdown is set to 0 or 1* 3. restart mysql
By the way, there is usually a way to set this variable at runtime (without restarting MySQL) if you can't afford downtime right away. Make sure you do restart it with your edited my.cnf in a maintenance windows to make sure the variable is OK.