Memory size exhausted

  • Resolved keengamer

    (@keengamer)


    1 year, 9 months ago

    Hello, we have a problem. We have over 15k posts. The table inverted_index has over 1.3 GB. If someone searches for “after us” then we get an error.

    Got error ‘PHP message: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 16777224 bytes) in /home/xxx/public_html/wp-includes/class-wpdb.php on line 3130’

    If you search for After use, it’s fine. Searching just “after” does not work either.

    Memory limit is 512MB.

    In your plugin minimum word length to index is 2. If we enable Throttle searches to 500 per term then it works. BUT it doesn’t find all the relevant and correct results. I don’t know, maybe to limit it to 1000 per term? Or to make more requests per 500 but to go through the whole index??

    For example when throttling and searching for “hogwarts legacy review” then we get the result only for PS5 review but not Xbox review. But using just “hogwarts legacy” finds it. The titles of the posts are: Hogwarts Legacy Review: Magic Or Muggle? (Xbox Series X) and Hogwarts Legacy Review: A Spellbinding Experience (PS5).

    Thanks,

    Karel

    • This topic was modified 1 year, 9 months ago by keengamer.
    • This topic was modified 1 year, 9 months ago by keengamer.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Vinod Dalvi

    (@vinod-dalvi)

    Sorry to hear about the problem you are having.

    Do you only get the probelm with “Inverted Index Search Engine” and not “Default WordPress Search Engine”?

    Please try increasing the allowed memory size as described below.

    https://kinsta.com/knowledgebase/wordpress-memory-limit/

    Also, please optimize the index by not indexing unwanted content that you can configure in the index settings.

    Best regards,

    Thread Starter keengamer

    (@keengamer)

    Hello, we run our own server and as I said, we already have 512 memory limit which I believe should be enough.

    Also, we index only posts, only categories and tags, no custom fields, indexing title, post content, category/tag title, author display name. Nothing else.

    However, switching to the default index and throttle to 500 seems fine. In this case, I believe that we can delete the inverted index table from our database, am I right? The default index does not create any database table…?

    However, why the inverted index does not work well? It’s faster so it would be better to use…

    Best,

    Karel

    • This reply was modified 1 year, 9 months ago by keengamer.
    • This reply was modified 1 year, 9 months ago by keengamer.
    Plugin Author Vinod Dalvi

    (@vinod-dalvi)

    However, switching to the default index and throttle to 500 seems fine.

    It is not default inde but the Default WordPress Search Engine.

    In this case, I believe that we can delete the inverted index table from our database, am I right?

    Yes, you can delete the index from Index settings.

    The default index does not create any database table…?

    The Default WordPress Search Engine does not create any database table.

    However, why the inverted index does not work well? It’s faster so it would be better to use…

    Yes, it should work fine.

    For further troublehsooting, could you please contact us on https://ivorysearch.com/contact/

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Memory size exhausted’ is closed to new replies.