[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