New to the community? Start here

Hummingbird is killing my sites response time

So I’ve been working through response times and 502 errors on local****dia.com. I’ve disabled a dozen plugins and when I tried to disable hummingbird but the site came back with a 502 error.

See this page: https://www.loca***.com/pay/

I then clicked on Humming bird see page non-minified:

https://www.loca**.com/pay/?avoid-minify=true

and the response time was drastically better.

The site is hosted in WP Engine and debug.log shows:

KILLED QUERY (30437 characters long generated in /wp-content/plugins/wp-hummingbird/core/modules/minify/class-minify-group.php:199

Wed, 29 Nov 2017 22:09:36
More Hummingbird Pro discussions
Hummingbird Pro
  • Anton Vanyukov
    • Ex Staff

    Hi Erik,

    This means that you minification couldn’t clean up old files. We need to remove them and the associated meta data. This will clear out the database and fix the issue. But before we modify the database directly, I want to try one more thing that, if not fix the issue, will definitely improve performance on your website. Could you ask your host if it’s possible to enable query_cache_size for MySQL? Also, please run the query again, I want to check if HB is able to clear out part of the data before the 502 error.

    Best regards,

    Anton

  • Anton Vanyukov
    • Ex Staff

    Hi Erik,

    You can try now. Minification is able to complete a scan and you can open up pages without getting any errors. I am seeing that pages with minification do load slower than those without it. I think the reason is because you don’t have query_cache_size defined for you database and Hummingbird is taking some time doing all those long queries. I would first ask your host about enabling query_cache_size. Setting it to 16M will be a good starting point.

    Best regards,

    Anton

  • Erik
    • Site Builder, Child of Zeus

    Thanks. Any idea what caused this condition. I concerns me about my other sites running hummingbird and I’m kind of happy this didn’t happen on one of my clients sites.

    I host at wpengine.com and I doubt that they’ll modify query_cache_size for me on a shared environment… but i’ll ask.

    Also, I just ran the query again and the results are:

    COUNT(‘ID’:wink:

    38

    So, there appear to still be some hummingbird entries… is this a concern? I’ll try to disable hummingbird again and I’ll let you know the outcome.

  • Anton Vanyukov
    • Ex Staff

    Erik,

    It’s hard to say. I’m not familiar with hosting setting on wpengine.com, but I personally use Hummingbird on a $5 DigitalOcean droplet with more than a 100 assets and have never had a problem.

    Let’s see what your host says about query_cache_size and we can continue on optimizing from there.

    Regarding the query and the count number. There were some issues with clearing out old data when disabling minification. It will be resolved in the upcoming release which we are testing at the moment.

    Best regards,

    Anton