• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Always get error

#1
"An unexpected database error occurred. Please try again later xenforo"


file my.cnf

Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Settings user and group are ignored when systemd is used (fedora >= 15).
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mysqld according to the
# instructions in http://fedoraproject.org/wiki/Systemd
user=mysql

# Semisynchronous Replication
# http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html
# uncomment next line on MASTER
;plugin-load=rpl_semi_sync_master=semisync_master.so
# uncomment next line on SLAVE
;plugin-load=rpl_semi_sync_slave=semisync_slave.so

# Others options for Semisynchronous Replication
;rpl_semi_sync_master_enabled=1
;rpl_semi_sync_master_timeout=10
;rpl_semi_sync_slave_enabled=1

# http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html
;performance_schema


[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
key_buffer = 500M
table_cache = 4000
sort_buffer_size = 3M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
max_connections = 400
query_cache_type = 1
query_cache_limit = 5M
query_cache_size = 500M
tmp_table_size=20M
max_heap_table_size=20M
thread_cache_size = 64
wait_timeout = 600
connect_timeout = 120
max_allowed_packet = 14MB
innodb_buffer_pool_size=64M
Please help me.

Thank you
 
Last edited:

Brogan

XenForo moderator
Staff member
#2
Your site is loading fine for me.

However, I note the XenForo copyright is missing - please restore it as soon as possible.
 
#3
Now, it works but sometimes get error "An unexpected database error occurred. Please try again later xenforo",

One days have 5 or 10 times that error or more.
 

Brogan

XenForo moderator
Staff member
#4
Contact your host and ask them to check the server error log.

Intermittent problems of that nature would suggest it is server related.