I run a mybb forum and my users get the following mySQL errors during peak hours: SQL Error: 1041 - Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space SQL Error: 1203 - User neochi_mybb3 already has more than 'max_user_connections' active connections Hosting I'm currently on dedicated hosting (hostgator standard plan) Site stats 213,323 posts in 30,033 threads 4,400 members usually has around 200-300 members on at anytime. mySQL config file skip-external-locking key_buffer_size = 384M max_allowed_packet = 1M table_open_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 ulimit -a stats core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 30277 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 10240 cpu time (seconds, -t) unlimited max user processes (-u) 1024 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited htop stats 19934 mysql 20 0 2036M 289M 4532 S 192. 7.6 290h /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var 20233 root 20 0 110M 2140 1224 R 1.3 0.1 0:01.01 htop 20581 neochi 20 0 160M 19852 8056 S 0.0 0.5 0:00.04 /usr/bin/php /home/neochi/public_html/private.php 20586 neochi 20 0 160M 19844 8056 S 0.0 0.5 0:00.04 /usr/bin/php /home/neochi/public_htm Please help! I shouldn't have any issues based on my forum stats and my current hosting...It's got to be a bad setting somewhere that's causing this.
Well if it's a hosting plan there is not much you can do about it. If it is a vps or a dedicated server however there are some things you should do. mysqld suggests either fedora, centos, scientific linux or rhel. you might want to check Check /etc/security/limits.conf and /etc/my.cnf
This is a question you should ask on the MyBB forums. If there's a way to prevent the problem on a forum that gets hit heavily, the developers can modify the next version. (Or you may have to wait for 2, which may be out before Obama's second term ends - jk, guys.) Or if it's a problem that someone already came up with a fix for on his own forum, you'll get a definitive answer.
You need to talk to your host via this error. 'max_user_connections' <- you need to increase the max connections on the server no need to ask anywhere else