Reply to thread

Message: <blockquote data-quote="andargor" data-source="post: 2116014" data-attributes="member: 7231">VBulletin and MySQL configI did a little research on the VBulletin boards and Usenet, and it seems that these settings are optimal for performance.VBulletinIn the Admin CP:Use Forum Jump MenuIf you have a lot of forums you may want to disable the Forum Jump menu, although it makes only a marginal performance hit, it can generate a large amount of HTML.NoEnable Access MasksAccess masks are a simple way to manage forum permissions for individual users. If you don't use any access masks, turn this option off.NoAdd Template Name in HTML CommentsAdd the template name at the beginning and end of every template rendered. This is useful for debugging and analyzing the HTML code, but turn it off to save bandwidth when running in a production environment.NoGZIP HTML OutputSelecting yes will enable vBulletin to GZIP compress the HTML output of pages, thus reducing bandwidth requirements. This will be only used on clients that support it, and are HTTP 1.1 compliant. There will be a small performance overhead.This feature the ZLIB library.If you are already using mod_gzip on your server, do not enable this option.YesAdd Standard HTTP HeadersThis option does not work with some combinations of web server, so is off by default. However, some IIS setups may need it turned on.It will send the 200 OK HTTP headers if turned on.NoAdd No-Cache HTTP HeadersSelecting yes will cause vBulletin to add no-cache HTTP headers. These are very effective, so adding them may cause server load to increase due to an increase in page requests.NoRemove Redirection Message PagesEnabling this option will remove the update pages that are displayed after a user makes a post, starts a search, etc. These pages provide assurance to the user that their information has been processed by the forum. Disabling these pages will save you bandwidth and may lessen the load of the forum on your server.Note: Some pages will still use the redirection page when cookies are involved to prevent some potential problems.YesCached Posts LifespanNumber of days to maintain a cached copy of a post. This makes threads faster to display, but means that each post takes approximately twice the storage space.10Update Thread Views ImmediatelyOption to update thread views immediately, or once an hour. If you have a large board, you will probably want to disable immediate updates, since they are quite server intensive.NoUpdate Attachment Views ImmediatelyOption to update attachment views immediately, or once an hour. If you have a large number of inline graphic attachments, you will probably want to disable immediate updates, since they are quite server intensive.NoCheck Thread RatingIf enabled, this option will check if a user voted on a thread and show their vote if they have. Otherwise, they will see the voting options even if they aren't able to vote again. This can have an effect on performance.NoMySQLThese are the recommended MySQL settings (my.cnf/my.ini):[code] [mysqld]basedir = D:/mysqldatadir = D:/mysql/dataskip-innodbmax_connections = 650key_buffer = 64Mmyisam_sort_buffer_size = 64Mjoin_buffer_size = 1Mread_buffer_size = 1Msort_buffer_size = 2Mtable_cache = 1500thread_cache_size = 64wait_timeout = 3600connect_timeout = 10tmp_table_size = 128Mread_rnd_buffer_size = 524288bulk_insert_buffer_size = 8Mmax_allowed_packet = 16Mmax_connect_errors = 10query_cache_limit = 2Mquery_cache_size = 64Mquery_cache_type = 1[mysqld_safe]open_files_limit = 8192[mysqldump]quickmax_allowed_packet = 16M[myisamchk]key_buffer = 64Msort_buffer = 64Mread_buffer = 16Mwrite_buffer = 16M[/code]HTH,Andargor</blockquote>

Verification