vb.org Archive
Page 218 of 307 « First 118168208216217 218 219220228268 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - Links and Downloads Manager (https://vborg.vbsupport.ru/showthread.php?t=119041)

obmob 08-07-2007 01:46 PM
Hmm... well, finally installed the new script... how do i enable the filmstrip to show the upcoming download link?

You know, that thing I asked for some months ago? That looks similar as vbgallery :eek:

Thanks :p

AndrewD 08-07-2007 03:23 PM
Quote:
Originally Posted by obmob (Post 1311883)
Hmm... well, finally installed the new script... how do i enable the filmstrip to show the upcoming download link?

You know, that thing I asked for some months ago? That looks similar as vbgallery :eek:

Thanks :p
It's provided in the 'extras' directory - have you installed it and read the 'readme' file?

hydn 08-07-2007 09:02 PM
We avg 50,000 downloads per month and the table... local_links_downloads eventually grew to over 700,000 rows. Which cause huge CPU spikes on our MYSQL server.

After truncating the local_links_downloads table. The CPU spike were gone (after 3 month of trying to find this worsening problem).

So my question, is there anyway to set an auto cut off for the stats to stop incrementing?

Or this means every few months we have to manually truncate the table. Can Links and Downloads Manager be set to only keep say the last 30 days of download stats?

Thanks very much for any support you can provide.

obmob 08-07-2007 10:23 PM
Quote:
Originally Posted by AndrewD (Post 1311959)
It's provided in the 'extras' directory - have you installed it and read the 'readme' file?
mwahaha! no... thought it was embedded in the templates, so, i was searching all over there. :eek:

Will test tonight, thanks Andrew. :D

AndrewD 08-08-2007 04:07 AM
Quote:
Originally Posted by hydn (Post 1312203)
We avg 50,000 downloads per month and the table... local_links_downloads eventually grew to over 700,000 rows. Which cause huge CPU spikes on our MYSQL server.

After truncating the local_links_downloads table. The CPU spike were gone (after 3 month of trying to find this worsening problem).

So my question, is there anyway to set an auto cut off for the stats to stop incrementing?

Or this means every few months we have to manually truncate the table. Can Links and Downloads Manager be set to only keep say the last 30 days of download stats?

Thanks very much for any support you can provide.
Go to LDM/admin/settings and set prune_downloadtable to the number of days you want to keep, e.g. 30. Note that detailed usage statistics are only available for those days where the downloads table is populated, but the overall statistics (total hits on entries) are retained when the table is pruned. Hope this helps.

Alfa1 08-08-2007 09:14 AM
How can I see the number of downloads per month?

AndrewD 08-08-2007 09:32 AM
Quote:
Originally Posted by Alfa1 (Post 1312540)
How can I see the number of downloads per month?
It does not get tabulated by month, but if you go to ldm/admin/hits you can do an analysis for any range of dates for which you still have information in your downloads table.

Rouzbeh1 08-08-2007 03:40 PM
hi Andrew,
just wanted to thank you and report that BW usage is working fine now ;)

btw. i have read that you are implementing a server load management for mirror sites. is that correct? :D

hydn 08-08-2007 04:58 PM
Quote:
Originally Posted by AndrewD (Post 1312403)
Go to LDM/admin/settings and set prune_downloadtable to the number of days you want to keep, e.g. 30. Note that detailed usage statistics are only available for those days where the downloads table is populated, but the overall statistics (total hits on entries) are retained when the table is pruned. Hope this helps.
THanks. That does help. However, I logged in / clicked administer / then clicked settings / ...

But can't find that prune_downloadtable.

I'm on version 2.1.0

Is this an option I can set with a Mysql query maybe? Or other solution(s)?

Thanks much.

BuRaCh 08-08-2007 05:03 PM
thank you good hack;)


All times are GMT. The time now is 01:11 AM.
Page 218 of 307 « First 118168208216217 218 219220228268 Last »
Show 40 post(s) from this thread on one page

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.03474 seconds
  • Memory Usage 1,745KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete