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! Best Regards / Cordialement ----- Placide NJAMI | HEAD OF IT DEPARTMENT GOLDEN EXOTICS LTD - GHANA P.O. Box K.I.A. 16105 - ACCRA Email: p.njami@gelgh.commailto:p.njami@gelgh.com
Hello, Have a look at this article (worked for me): http://dba.stackexchange.com/questions/1261/how-to-safely-change-mysql-innod... Regards, Rick From: otrs [mailto:otrs-bounces@otrs.org] On Behalf Of Placide Lysias NJAMI Sent: Mittwoch, 22. Juni 2016 13:35 To: otrs@otrs.org Subject: [otrs] Innodb warning Importance: High [cid:image001.gif@01D1CC8E.AF312170] 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! Best Regards / Cordialement ----- Placide NJAMI | HEAD OF IT DEPARTMENT GOLDEN EXOTICS LTD - GHANA P.O. Box K.I.A. 16105 - ACCRA Email: p.njami@gelgh.commailto:p.njami@gelgh.com
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 e.g. snippet from /etc/my.cnf (Debian Jessie) |[mysqld]innodb_log_file_size =256M| Check http://dev.mysql.com/doc/refman/5.6/en/innodb-data-log-reconfiguration.html first(?) For more detailed instructions please post information about your server.
Best Regards / Cordialement -----
Placide NJAMI | HEAD OF IT DEPARTMENT GOLDEN EXOTICS LTD - GHANA P.O. Box K.I.A. 16105 - ACCRA Email: p.njami@gelgh.commailto:p.njami@gelgh.com
Kind regards
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.
participants (4)
-
Placide Lysias NJAMI -
Rick Heisterhagen -
Scott Ferguson -
Ugo Bellavance