vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Make old topic static but still searchable (https://vborg.vbsupport.ru/showthread.php?t=324787)

RedFoxy 03-22-2017 02:21 PM

Make old topic static but still searchable
 
Hi!
I've a big forum, it's 12 years old, now it loose a lot of traffic for Facebook and I'm tring to make it smaller without deleting its posts because it's a really big and important database, than I'm thinking to make old post/topic static but I want that my user can still search information in it andd google's links still goes.

How can I do?

Lynne 03-22-2017 06:47 PM

What do you mean by make them 'static'?

Mark.B 03-22-2017 10:53 PM

I think it refers to converting old posts to html.

It's not possible, certainly not in any feasible way. Just move them to a forum without posting permissions.

final kaoss 03-22-2017 11:33 PM

I think I see what he means.

What would do the trick would be to force a forum and it's thread to use "archive mode" only & by default. That would require a plugin to be made.

Otherwise he can try to do what this guy did and turn the threads literally to html... Some guy tried it not too long ago, with not really impressive results.
http://www.vgchat.com/archive/Forums.shtml

RedFoxy 03-23-2017 09:35 AM

in html or in static way (like precached and not editable) just to make the board less expansive

Lynne 03-23-2017 06:55 PM

What are you trying to make smaller - the database or the 'active' posts number? If the posts remain in the database, which will make them searchable, then your database will not get smaller. If you move a bunch of threads/posts to an "archive" forum (one where users cannot post), then you will have less 'active' posts (posts that will get new posts).

RedFoxy 03-24-2017 10:53 AM

After I deleted about 1,5 milions of posts, my database is 6Gb big, I'm tring to find a way to make whole board light and less resouce eater, I had changed the web server from Apache 2 to Nginx with cache+php-fpm, I use sphinx search engine (an old vbulletin.com post), moved pictures from DB to physical files, but the board becomes always slower, now it runs on a dual Intel Xeon E5506 at 2.13GHz with 16Gb of ram, my knwoledge are limited, I'm tring to make faster webserver and mysql server (v5.6.35), now for $$$ question I must change server with a one less powerfull, I got a new and cheaper server, it's a Intel Xeon X3440 Quad Core with 16Gb of ram, and I must fit my board here :P

Paul M 03-24-2017 03:49 PM

If you cannot run a fast forum on a server of that spec you are doing something wrong.

My forum (over 2 million posts) runs fast & happily on a set of 1GB VPS servers ($5 a month per VPS)..

Lynne 03-24-2017 05:00 PM

After you deleted the posts and moved the attachments to the file system, did you make sure to run optimize/repair on the tables so that they get smaller?

RedFoxy 03-24-2017 05:25 PM

Quote:

Originally Posted by Lynne (Post 2584288)
After you deleted the posts and moved the attachments to the file system, did you make sure to run optimize/repair on the tables so that they get smaller?

yes!

--------------- Added [DATE]1490380849[/DATE] at [TIME]1490380849[/TIME] ---------------

Quote:

Originally Posted by Paul M (Post 2584287)
If you cannot run a fast forum on a server of that spec you are doing something wrong.

My forum (over 2 million posts) runs fast & happily on a set of 1GB VPS servers ($5 a month per VPS)..

Any help is welcome!

That are my configurations:

Mysql:
mysql.ini: http://pastebin.com/zy9SLHdG

Nginx webserver configurations:
nginx.conf: http://pastebin.com/nD4M1wmq
fastcgi_params: http://pastebin.com/yKp6PbjA
php.conf: http://pastebin.com/XqH01EXH
domain: http://pastebin.com/jQQQu5e6

php and php-fpm configurations:
php.ini: http://pastebin.com/uESdrkPd
extensions.ini: http://pastebin.com/F9HE9tbS
apc.ini: http://pastebin.com/f6tfi9Gn

php-fpm.conf: http://pastebin.com/EmyARsLi
fpm-pool.d/php0.conf: http://pastebin.com/fXL5LQVG (all same just change id)

My main problem is on mysql, i think, and with php-fm because sometimes it stops all connection than restarts all child with gateway error


All times are GMT. The time now is 04:25 AM.

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.03268 seconds
  • Memory Usage 1,735KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (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