I am trying to reindex product flat data(about 85K products) with the following command and I am doing it at night when nobody is using the website and nothing else is going on the server.
nohup php -f indexer.php -- -reindex catalog_product_flat &
Then I was wondering if we can use the website or work in the backend when reindexing and I could not find any information about that online. So when I was reindexing, I was unable to use website or save product at all. The pages keep loading or show internal server error after a long time. Sometimes it rarely loaded with few pages successfully.
Is it possible to reindex and use our Magento website same time? Do we just need a higher configuration server in order to keep doing both?
Currently the site is hosted on 8GB RAM and 4 Cores VPS.