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" 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]

Originally Posted by 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?

yes!

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

Originally Posted by 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)..

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