Page 1 of 1

innodb_log_file_size

Posted: Sun Oct 04, 2015 1:28 pm
by jgriggs
Hello,

I'm trying to install a support panel on my website, and I keep getting the following error:
Error: Please set the value for innodb_log_file_size on your database to at least 256 MB (current: 5 MB, recommended: 512 MB)
every edit I've done to my.cnf breaks mysql. Anyone have any suggestions??

Thanks!
Juston :)

Re: innodb_log_file_size

Posted: Sun Oct 04, 2015 10:07 pm
by tjebbeke
Can you show us your my.cnf?

Re: innodb_log_file_size

Posted: Tue Oct 06, 2015 6:57 pm
by jgriggs
Here ya go

Code: Select all

[client]
port=3306
socket=/var/run/mysqld/mysqld.sock

[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock

[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
max_connections=200
max_user_connections=30
wait_timeout=30
interactive_timeout=50
long_query_time=5
innodb_file_per_table

!includedir /etc/mysql/conf.d/


Re: innodb_log_file_size

Posted: Wed Oct 07, 2015 1:52 pm
by skurudo
Pretty standart settings, jgriggs ;-)

And how much RAM/CPU do you have on server?