Host reporting Slow Queries

[Wendy]

Hi Modern Tribe,
My host has sent me this and has threatened to suspend our account:

http://www.nhwnc.net/wp-content/uploads/2017/05/slowqueries2017-0516.pdf
This log shows that the slowest MySQL queries are associated with “The Events Calendar” plugin part of your WordPress installation. You could provide this log to the plugin developers and check with them how they can be improved. Alternatively, you could consider disabling that plugin completely, and look for a different one that would over better performance.

Can you please tell his how to improve performance? And maybe we have a conflict.

Thank you

[Andras]

Hello Wendy,

Thanks for using our plugins and welcome to the forums!

I’m sorry that you are being threatened by your provider seemingly because of our plugin. That’s unusual, never heard about any provider threatening to close down an account.

The details of the issue are a bit beyond be, so I’m going to ask a colleague of mine to take a look at this issue and see what can be done about it.

Meanwhile what would be helpful for us is if you could send us some details about your hosting environment. Which provider is it and what package do you have? Are you on shared hosting or dedicated server? What are the server parameters?

This would help us see in what environments our plugin is under-performing so we can improve on that front.

What might help you as well is using a caching plugin like W3 Total Cache that should ease the load on the server. Also there is a setting to cache the month view, it can be found under Events > Settings > Display tab > Enable the Month View Cache

Thanks and we’ll be in touch soon. Hang in there.

Cheers,
Andras

[Wendy]

Hi Andras,

I would definitely appreciate whatever recommendations you have
regarding how to configure the plug in to eliminate this problem as soon
as possible.

The hosting company is https://www.icdsoft.com/

Shared hosting, business plan. We are allocated 20 MySQL minutes a day,
and most days we exceed that.

What does the file we sent show?

Thank you,

Wendy Moore

[Andras]

Hello Wendy,

I have logged an internal bug ticket, so our developers will take a look at it. Unfortunately at the moment I cannot say when that will happen.

Looking at your hosting providers offers and terms, plus the mysql limitation you mentioned, in my humble opinion, this type of hosting arrangement is far from optimal. Nowadays I very rarely see limitations of any kind in any hosting plans, especially business ones.

SiteGround is very much liked by a lot of team members here, might be worth a try while we try to get that bug sorted.

Cheers,
Andras

[Wendy]

Hi, I can switch hosting right now and am still awaiting a response as to what the file shows so we can address this problem. Thanks in advance for your quick reply.

[Andras]

Hi Wendy,

I checked again the file you sent, but not quite sure what to tell you.

I don’t quite understand the statistics in the attached file and how they are related to our plugins. If your host could explain what all the numbers in the tables mean, and specifically how they are related to the queries, then I might be able to get closer to the source of the issue.

As for the queries, it would be great to know on which pages or when they are generated. I believe these are queries that are running on anybody’s site who uses The Events Calendar.

Slow queries can be the result of different things. The server and the database might be receiving a lot of requests at the same time and there are not enough resources to handle the need, or to handle it quickly enough. Or yes, it can be our plugin as well, but since so far we rarely received any complaints from users or hosting providers that the queries are too slow, that’s a good indication that the plugin is working fine.

Another dimension is the number of events, posts and pages, potentially other custom post types, as these are all stored in the same database table. If there is a lot of these, then that can affect the speed. Most of the data is saved in 2 tables in the database: wp_posts and wp_postmeta. Each post usually contains 10+ postmeta. So if you have 300 events (or posts etc.) that is 3000 lines in wp_postmeta at least. That is a lot to go through. Unfortunately this is a feature of WordPress which we have to take as it is at the moment as our pluigns are using these tables as well.

I hope this gives a bit of an explanation, if not yet a solution. If you manage to get some more details from the provider then I can try to help you further with this issue.

Cheers,
Andras

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Victor]

Hi Wendy!

Just wanted to share with you that a new maintenance release (for the Week of 2 October 2017) is out, including a tweak in Filter Bar that improves performance by swapping out LEFT JOINs for INNER JOINs in SQL queries.

Find out more about this release → https://theeventscalendar.com/maintenance-release-week-2-october-2017/

In addition to this improvement, we are also planning to support setting a limit on the number of filters that can be applied concurrently.

For the moment, we’d appreciate if you could update the plugins and see if the tweak works for your site. Don’t hesitate to open a new topic if anything comes up.

Best,
Victor

[Author]

Posts