Hello I think i have in my sql/server a limit in connections for my sql database as when i search from my forum (5.000 topics) all moved topics i got a ips driver error that means that the connection lost/stop. I think i have some server/limits for conneections. Can you help me to adjust all limits to higher numbers as i have a very powerfull server and not many users online at a time (300)? Total members about 65.000 and total posts 700.000. My server: # 2x Intel Xeon Quad 5405 # 12GB Ram # 4 SAS Disks in Raid 10 # 1.000 Mbit port Unshared my.cnf (i was use mysqltuner and sql primer scripts to adjust it): [mysqld] skip-innodb skip-networking skip-locking max_connections = 200 table_cache = 1024 thread_cache_size = 4 key_buffer_size = 512M query_cache_size = 128M thread_cache_size = 32 join_buffer_size = 128K Also recomend me any settings to allow more connections and users in my forum in general. Thank you
First of all I would recommend posting on your forums support bored if they have one or contacting their support to see what help they can provide. The only thing I would be able to recommend at this time is increasing the max_connections to something to like 20,000 and see how that goes.
Ok i diid it but i need also in general a few settings for high traffic forums settings for Apache and raise all limits in the server.