innodb_log_file_size
innodb_log_file_size
Hello,
I'm trying to install a support panel on my website, and I keep getting the following error:
Thanks!
Juston :)
I'm trying to install a support panel on my website, and I keep getting the following error:
every edit I've done to my.cnf breaks mysql. Anyone have any suggestions??Error: Please set the value for innodb_log_file_size on your database to at least 256 MB (current: 5 MB, recommended: 512 MB)
Thanks!
Juston :)
-
- Collaborator
- Posts: 783
- Joined: Mon May 11, 2015 8:43 am
- Contact:
- Os: CentOS 6x
- Web: apache + nginx
Re: innodb_log_file_size
Can you show us your my.cnf?
Re: innodb_log_file_size
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
Pretty standart settings, jgriggs ;-)
And how much RAM/CPU do you have on server?
And how much RAM/CPU do you have on server?