A Relevanssi user reported a mystical database problem. After about two minutes of indexing, the server shuts down the indexing. This leaves MySQL queries hanging on the server, causing the site to crash. The only way to get the site back live was to reboot the whole MySQL server.
Eventually, they were able to figure out the problem. It was caused by a server misconfiguration. The innodb_buffer_pool_size
was restricted to an absurdly low number and both query_cache
and OPcode cache were missing. Once these problems were fixed, Relevanssi indexing started working without problems.