Posted on

MySQL server kills Relevanssi indexing

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.

Leave a Reply

Are you a Relevanssi Premium customer looking for support? Please use the Premium support form.

Your email address will not be published.