[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 wait_timeout = 604800 interactive_timeout = 604800 max_connection=1000 transaction-isolation=READ-COMMITTED #added by joe for noting internal network. #bind-address = 10.41.41.26 #skip-networking innodb_buffer_pool_size=2000M innodb_buffer_pool_instances=4 innodb_log_file_size=48M innodb_autoextend_increment=50 # jaa 06072016 had to recover #innodb_force_recovery = 1 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid