vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   my.cnf file for LOTS of connections (https://vborg.vbsupport.ru/showthread.php?t=279274)

z0diac 02-28-2012 12:43 PM
my.cnf file for LOTS of connections
 
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:

Code:
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 02-28-2012 08:12 PM
try using xcache to cache

z0diac 02-28-2012 09:27 PM
Quote:
Originally Posted by prandah (Post 2304381)
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 02-28-2012 10:46 PM
Why don't you post this over in the Server Configuration forum and get George's advise.

z0diac 02-29-2012 02:28 AM
Quote:
Originally Posted by Lynne (Post 2304441)
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 02-29-2012 04:32 PM
<a href="https://www.vbulletin.com/forum/forumdisplay.php/14-Server-Configuration" target="_blank">https://www.vbulletin.com/forum/foru...-Configuration</a>

z0diac 02-29-2012 04:56 PM
Quote:
Originally Posted by Lynne (Post 2304722)
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.


All times are GMT. The time now is 07:03 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01040 seconds
  • Memory Usage 1,726KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete