Prestashop 9.01 - MariaDB Stuck Queries - Faceted Search

[webbrent]

Good Day,

I am experiencing something strange.

Prestsahop - 9.01
PHP - 8.4
Theme - Hummingbird (stock)
MariaDB - 10.6.22

I installed a vanilla setup of Prestashop 9 for testing purposes - However I noticed after installation that my server processing was a bit on the congested side. After much analysis I found the new test site to be the cause. I found stale sql queries hogging server processing If I killed the stale SQL queries the server stabilised but then they would just start up again. If I put the store into maintenance mode and then killed the stale SQL queries they would not occur again and the server stabilised. So something was querying the instance when it was accessible.

So further down the rabbit hole we went of root cause analysis. After many hours spent we finally isolated the problem to Faceted Search. We disabled Faceted Search, killed the stale queries and made the site live and the problem no longer persists.

Is this a known issue with Faceted Search? Or has anyone  got a work around? I know Prestashop 9 is newish however we have many clients running on Prestashop and have to continue keep them up to date. So for now PS9 is a no go until we figure this gremlin out.

[El Patron]

Most PrestaShop users don’t realize that their MySQL database configuration is often tuned—if at all—for small blogs, not ecommerce stores.

Over time, I’ve had far better results improving both my own and clients’ store performance by tuning MySQL directly rather than relying solely on performance modules. While there are a few “magic” modules out there (and I’ve built several myself), it’s often much safer—and faster—to properly tune your database for an immediate performance boost.

I recently wrote a detailed guide explaining the process step-by-step:
👉 Tune MySQL for Ecommerce: The 2025 Performance Playbook

Hope this helps anyone looking to squeeze more speed out of their PrestaShop store.

— PrestaHeroes

 

 

[webbrent]

We have multiple clients on said host and all the others are running optimally - It has been found that one store running PS9.01 on PHP 8.4 is causing the server strife.

[El Patron]

1 hour ago, webbrent said:

We have multiple clients on said host and all the others are running optimally - It has been found that one store running PS9.01 on PHP 8.4 is causing the server strife.

Perfectly understand, then they would all run even better if the mysql was tuned.  For years admin's have tried a lot of tricks, modules for performance in front office I offer this a better option.  As for 9.0.1, I know they are looking at it but while waiting you have other option to  try.