Thanks Rick,
It works for me too. Below the steps exactly used :
1. mysql -u root -p
SET GLOBAL innodb_fast_shutdown = 0
2. sudo service mysql stop
3. sudo su
4. mv /var/lib/mysql/ib_logfile* /tmp
5. vim /etc/mysql/my.cnf
Change lines like below :
innodb_buffer_pool_size = 1024M
innodb_log_file_size = 256M
Save the file
6. sudo service mysql start
PLOBLEM SOLVED !!!
Cdt,
Placide
-----Message d'origine-----
De : otrs [mailto:otrs-boun...@otrs.org] De la part de otrs-requ...@otrs.org
Envoyé : mercredi 22 juin 2016 12:02
À : otrs@otrs.org
Objet : otrs Digest, Vol 93, Issue 9
Send otrs mailing list submissions to
otrs@otrs.org
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.otrs.org/cgi-bin/listinfo/otrs
or, via email, send a message with subject or body 'help' to
otrs-requ...@otrs.org
You can reach the person managing the list at
otrs-ow...@otrs.org
When replying, please edit your Subject line so it is more specific than
"Re: Contents of otrs digest..."
Today's Topics:
1. Innodb warning (Placide Lysias NJAMI)
2. Re: Innodb warning (Rick Heisterhagen)
----------------------------------------------------------------------
Message: 1
Date: Wed, 22 Jun 2016 11:34:40 +0000
From: Placide Lysias NJAMI <p.nj...@gelgh.com>
To: <otrs@otrs.org>
Subject: [otrs] Innodb warning
Message-ID: <004e01d1cc7a$11f94400$35ebcc00$@gelgh.com>
Content-Type: text/plain; charset="us-ascii"
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.nj...@gelgh.com<mailto:p.nj...@gelgh.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.otrs.org/pipermail/otrs/attachments/20160622/9be33359/attachme
nt-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 2051 bytes
Desc: not available
URL:
<http://lists.otrs.org/pipermail/otrs/attachments/20160622/9be33359/attachme
nt-0001.gif>
------------------------------
Message: 2
Date: Wed, 22 Jun 2016 12:02:19 +0000
From: Rick Heisterhagen <rick.heisterha...@thinprint.com>
To: User questions and discussions about OTRS. <otrs@otrs.org>
Subject: Re: [otrs] Innodb warning
Message-ID: <8ADCB49BC628C7478022BEAD5DC6B0E232D4C697@ctd-exchange02>
Content-Type: text/plain; charset="us-ascii"
Hello,
Have a look at this article (worked for me):
http://dba.stackexchange.com/questions/1261/how-to-safely-change-mysql-innod
b-variable-innodb-log-file-size
Regards,
Rick
From: otrs [mailto:otrs-boun...@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.nj...@gelgh.com<mailto:p.nj...@gelgh.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.otrs.org/pipermail/otrs/attachments/20160622/7c8cef10/attachme
nt.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 2051 bytes
Desc: image001.gif
URL:
<http://lists.otrs.org/pipermail/otrs/attachments/20160622/7c8cef10/attachme
nt.gif>
------------------------------
Subject: Digest Footer
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
------------------------------
End of otrs Digest, Vol 93, Issue 9
***********************************
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
