Make old topic static but still searchable

[RedFoxy]

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]

What do you mean by make them 'static'?

[Mark.B]

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]

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 (https://vborg.vbsupport.ru/archive/index.php/t-324787.html)" 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]

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

[Lynne]

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]

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]

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]

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]

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 1490380849 at 1490380849 ---------------

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

[Paul M]

mysql.ini ?

Are you running windows ?

[RedFoxy]

mysql.ini ?

Are you running windows ?

FreeBSD 11, next server debian 8, and it was a typo my.cnf :D

BTW, what web server are you using?

[final kaoss]

You're only going to be running around in circles asking here. You will want to make a server optimization request here.
https://www.vbulletin.com/forum/forum/general/server-configuration

[RedFoxy]

You're only going to be running around in circles asking here. You will want to make a server optimization request here.
https://www.vbulletin.com/forum/forum/general/server-configuration

already done some times ago but no solve :|

[final kaoss]

Ok, I have no idea about debian but I'll leave you with these links.
http://qref.sourceforge.net/Debian/reference/ch-tune.en.html

https://www.google.com/search?q=debian+8+optimization&rlz=1C1CHBF_enUS728US728&oq=debian+8+optimization&aqs=chrome..69i57.471j0j9&sourceid=chrome&ie=UTF-8

[Paul M]

BTW, what web server are you using?
Centos 6.8 & Apache.

As to server optimization requests, I dont think George has done them for over two years now.

[final kaoss]

There's a bit of work to be done. Look here to see what I mean.
https://gtmetrix.com/reports/www.softairmania.it/gtbmDGcQ

Working on fixing that up would be a start.
Try to localize any third party resources if possible. (host it yourself & call from that)
Fix up the redirect issues listed.
Try to keep third party scripts/resources to a minimum.
And the big one that's listed. Do a better job of caching... 3 minutes is pitiful.

[RedFoxy]

There's a bit of work to be done. Look here to see what I mean.
https://gtmetrix.com/reports/www.softairmania.it/gtbmDGcQ

Working on fixing that up would be a start.
Try to localize any third party resources if possible. (host it yourself & call from that)
Fix up the redirect issues listed.
Try to keep third party scripts/resources to a minimum.
And the big one that's listed. Do a better job of caching... 3 minutes is pitiful.

thank you, I works hard to reach that result about speed test, but the trobules is on the DB speed and PHP stability, now I'm tring to convert all o apache 2.4 and php7 with vbulletin 4.2.4 beta, php 7 is faster than older php