my.cnf file for LOTS of connections

[z0diac]

Can someone give me an example of their my.cnf file for a forum that can handle a lot of simultaneous connections?

I'm getting a lot of "cannot connect to mysql" errors.

My forum has a LOT of attached images: a typical post has 30-50, and there's 5 posts shown per page by default. So that's up to 250 thumbnails being generated per page view. This all worked fine when I ran the galleries as HTML, but since I've moved them all into the forum, I think it's displaying all these thumbnails that are creating a lot of connections to mysql.

My typical online count of users (last 15mins) is 200-300.

max connections right now = 500

My server (dedicated) has 4GB ram.

The top part of my current my.cnf is this:


max_connections=500

set-variable=local-infile=0
datadir=/var/lib/mysql

old_passwords=1

port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 1025
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8


I'm planning on moving a lot more of my former HTML site onto the forum so that will mean more connections needed, and just the current traffic is growing from month to month.

Does anyone know which of these settings I can safely boost?

ps. there are 2 other forums run on my server, but both are much lower in # of visitors (only ~50 online average for each one)

[prandah]

try using xcache to cache

[z0diac]

try using xcache to cache

I didn't think caches would really work with forums? Well, maybe a forum like this where most users are reading only the new content. ARen't they only good if there's a lot of the same content being served? With hundreds of thousands of threads, and different ones being sent at any given time (much of the forum is search-based), would a cache system really work?

ie: would a cache work if almost every thread being viewed was different from one day to the next.

[Lynne]

Why don't you post this over in the Server Configuration forum and get George's advise.

[z0diac]

Why don't you post this over in the Server Configuration forum and get George's advise.

Is this "Server Management" forum not the right forum?

I just opened a new tab and went to the forum listings, did a search for "configuration", but that text isn't found. Maybe I don't have access? :confused:

[Lynne]

<a href="https://www.vbulletin.com/forum/forumdisplay.php/14-Server-Configuration" target="_blank">https://www.vbulletin.com/forum/foru...-Configuration</a>

[z0diac]

https://www.vbulletin.com/forum/forumdisplay.php/14-Server-Configuration

OOOohhh on vbulletin.com :) When you said "Why don't you post this over in the Server Configuration forum and get George's advise." I thought you meant on here.

(I thought the .com site was just for vB specific help so I'd be out of luck looking for less vb-specific help)

Ok, I'll try there, thanks.