Thread: Major Additions - Links and Downloads Manager
View Single Post
  #2605  
Old 11-02-2007, 05:32 AM
AndrewD AndrewD is offline
 
Join Date: Jul 2002
Location: Scotland
Posts: 3,486
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Nam View Post
I already asked this but I guess you missed it, is it possible to enable both link protection on some categories and no protections on some file/categories?

The second question is that does LDM keep sleeping mySQL connections? My host says sometimes the server on a high load because of that reason. I'm not sure what's that mean but I wonder if it's necessary to keep those connections.

32k hits in 3 days
1) Yes.

As background, you can find out which settings/permissions can be set per-category as follows: a) Go to any of your categories, do edit/category, and look at the control settings and permissions tabs. If the setting/permission is listed on these pages, then the value for that category will override the global value in that category and in any child categories that do not set their own value. b) Alternatively, from version 2.2.8-post 1, look at the admin/settings and admin/permissions pages. If the setting/permission is colour coded yellow, then it is configurable per-category.

*force_redirect* is one such setting, so the answer to your first question is 'yes'.

2) LDM does nothing special with database connections. As far as I know, I'm using standard vbulletin procedures, including when LDM shuts down. However, I don't know what your site is using LDM to deliver - if you are supplying large video files, then there is likely to be be a long delay between starting to deliver the video and eventually closing down (and ? releasing the database connection). Consequently, if lots of people are using the site at once, then the number of simultaneous connections may be equally large.

As I've mentioned, I'm not an expert on MySQL, but I also wonder if your problem is related to the way your site is configured to handle so-called 'persistent connections'. This is a particular method for using the database. It is configured in (at least) two places - in the php.ini file and in the vbulletin config.php file - it's not something that LDM knows about or tries to do anything with. I suggest that you ask for help on the subject on vb.com or in the main vb.org programming/mysql forum.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02122 seconds
  • Memory Usage 1,767KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete