Events Calendar Pro is slow queries effects my sites performance

[Angela McFarland]

Hi, I am using The Events Calendar Pro version.
I am facing slow database queries and they even take my server down when a few persons trying to submit an event.
Is there anyone who faced the same issue? What’s the fix for this problem?

[Patricia]

Hey Angela,

Thank you for reaching out to us!

I’m sorry to hear that you are experiencing performance issues with The Events Calendar.

To get started, could you please inform me:

– Approximately how many events do you have? How many (if any) are recurring?
– Did the performance suddenly get worse (if so, when did it start?), or has it been a gradual progression?
– Do you have any relevant errors in your server logs that might help us to understand why your site is experiencing downtimes when trying to submit new events? I would recommend you to temporarily enable WP_DEBUG and WP_DEBUG_LOG via FTP and share with us any messages you see while trying to submit new events and accessing existing events. All WP_DEBUG messages will be stored in a debug.log file in /wp-content/debug.log.

Thanks!

Patricia

[Angela McFarland]

Patricia,

No idea how many events, alot. We are a media company and have used this
plugin for a few years.

The performance issues are hard to determine separate and apart from so
many other things we are doing. I can say for sure, it’s been an issue for
a few weeks…but we’ve also had major traffic spikes causing issues, too
so again, not really sure how to answer that.

My developer needs to answer your third question. Below is a recent
communication from a separate issue we were handling during a traffic spike
that may or may not be helpful.

I took a look at the MySQL logs and found the following:

2017-09-18 19:19:35 30682 [ERROR] InnoDB: Cannot allocate memory for the
buffer pool
2017-09-18 19:24:40 31631 [ERROR] InnoDB: Cannot allocate memory for the
buffer pool
2017-09-18 19:29:19 32501 [ERROR] InnoDB: Cannot allocate memory for the
buffer pool
2017-09-18 19:51:46 2708 [ERROR] InnoDB: Cannot allocate memory for the
buffer pool
2017-09-18 20:32:18 6502 [ERROR] InnoDB: Cannot allocate memory for the
buffer pool
2017-09-19 12:22:26 16394 [ERROR] InnoDB: Cannot allocate memory for the
buffer pool
2017-09-19 21:06:40 29994 [ERROR] InnoDB: Cannot allocate memory for the
buffer pool
2017-09-21 14:27:42 16625 [ERROR] InnoDB: Cannot allocate memory for the
buffer pool
2017-09-21 16:51:15 30552 [ERROR] InnoDB: Cannot allocate memory for the
buffer pool
2017-09-21 16:55:15 31478 [ERROR] InnoDB: Cannot allocate memory for the
buffer pool

These are just a few lines of this specific error, but it appears as far
back as 4-28-17 in the logs. MySQL is crashing due to high memory usage
which is why you get that database connection error. As pointed out by one
of my colleagues in a previous email, it is best to insure the health of
the CMS WordPress rather than trying to manipulate MySQL’s configuration.
Increasing limits in the configuration can sometimes be a legitimate
approach for some situations, but if there is an underlying issue, then
increasing the limits would not address this. It’s like putting a band-aid
on a wound. It might feel better for a bit, but it doesn’t really heal the
wound. If you’ve already addressed the caching and robots.txt
recommendations, then you will need to optimize your site as it’s possible
that a plugin or maybe even your theme can be responsible for the high
memory usage.

[Angela McFarland]

This reply is private.

[Patricia]

Hi Angela,

Thanks for sharing this info! The InnoDB buffer pool keeps frequently accessed data in memory: In your specific case, increasing the innodb_buffer_pool_size in your server would help to avoid downtimes while you figure out the available options to decrease the number of queries: If the buffer pool is small and you have sufficient memory, making the buffer pool larger can improve performance by reducing the amount of disk I/O needed as queries access InnoDB tables. You will find further information about the InnoDB Buffer Pool here.

Did you check our article regarding performance? It has some useful tips to improve performance like reducing the number of events to show per page and caching your month view calendar to reduce the number of queries hitting your server:

https://theeventscalendar.com/knowledgebase/performance-considerations/

I hope this helps you to improve performance! If the issue persists even after following these steps, please send me a copy of your database via private reply so we can further investigate your case.

Thanks!

Patricia

[Angela McFarland]

This reply is private.

[Patricia]

This reply is private.

[Patricia]

This reply is private.

[Patricia]

This reply is private.

[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

[Author]

Posts