How can I change the logfile size, max size in MySQL

[Deleted user]

Your innodb_log_file_size of 50,331,648 is too small. You should increase innodb_log_file_size to 256M.

First, is it a real problem? What could be the consequences? 

How do I fix this? I tried to fix it via Atalssian documentationbut its not working.

I added in the My.ini file: 

[mysqld]

character-set-server=utf8
collation-server=utf8_bin

default-storage-engine=INNODB

max_allowed_packet=512M

innodb_log_file_size=2GB

transaction-isolation=READ-COMMITTED

binlog_format=row 

But the warning still pops-up.

[AnnWorley · Accepted solution]

I am not sure why your MySQL instance is not picking up the log size change. Please make sure Confluence and MySQL were both restarted after the my.ini file was edited.

Here is an example of an issue that can be caused by an incorrectly sized innodb_log_file_size: Unable to install plugins due to innodb_log_file_size using MySQL

[Deleted user]

thank you. I found the issue. now its working 

[Hans-Jörg Teich]

Can you tell me what was your issue?

I have the same problems