Recommended Settings for 6 CPUs 10 GB RAM

[rifatspir96]

My website have 5000 products with lots of variations. I’m using siteground cloud plan 6 CPUs, 10 GB RAM only for my website. I saw major spikes in ram and cpu sometimes after started using this plugin. is there any recommended settings for this plugin to use less memory? Any suggestion?

[Ernest Marcinko]

Hi,

Sure, I strongly recommend using the index table engine. That will greatly improve the performance, as the search queries will be executed on an indexed table.
You can also enable caching, which will gradually build and decrease the load on repetitive queries.
You can still expect some load of course, if your users are actively using the search – as it needs to perform the queries.

[rifatspir96]

yes i’m already using index table and also caching enabled (Caching method: File)

Here is last few days Performance statistics. is that normal?

Search queries tracked: 6736
Average request runtime: 0.182 s
Average request peak memory usage: 1.91 MB
Last request runtime: 0.267 s
Last request peak memory usage: 6 MB

[Ernest Marcinko]

Maybe try changing the caching method from file to database – in your case it might be better, as you have a lot of cores and RAM available.

Those numbers look fine to me. If you want to be sure, you can run a table defragmentation: https://i.imgur.com/fuHMO7J.png

If you want, you can also check this documentation for other suggestions to maximize the performance.

[rifatspir96]

I set the Caching method to database. After 1 day when i cleared the cache it show me this.

Cache successfully cleared! 0 record(s) deleted at 10/12/2021 @ 13:18:16

Looks like caching not working in my site.

[Ernest Marcinko]

It is fine for sure, the clear only counts the files, not the database records. (due to performance issues – on high amount of rows the count query on mySQL/mariaDB is extremely slow, and the clear command would hang)

[Author]

Posts