Slow Queries in Database

[Rhonda]

I was having problems with my website and one of the things siteground has discovered is that Events Calander Pro is causing at least 1,300 cases of slow queries in the past 24 hours and they advised that I reach out to you for help. Here is part of what they sent me.

also found the following slow queries in the databases hosted under this account:
Code:
=== TOP 10 of 1330 (total) Slow Queries for the past 24 hours ==========
1. Executed 8m 17s ago for 13.357306 sec on Database –> chatha90_chat
Date: 2017-11-03 10:54:52 Query_time: 13.357306 Rows_examined: 17593: Rows_sent 17593 Lock_time: 0.000000
# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM wp_7jqkcqbv9v_options;
———————————————————————————————————
2. Executed 21h 30m 52s ago for 8.086035 sec on Database –> chatha90_chat
Date: 2017-11-02 13:32:17 Query_time: 8.086035 Rows_examined: 17297: Rows_sent 1340 Lock_time: 0.004299
# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
——————————————————————————————————-
3. Executed 21h 30m 46s ago for 6.936295 sec on Database –> chatha90_chat
Date: 2017-11-02 13:32:23 Query_time: 6.936295 Rows_examined: 17297: Rows_sent 1340 Lock_time: 0.000262
# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
——————————————————————————————————-
4. Executed 10h 28m 3s ago for 6.79388 sec on Database –> chatha90_chat
Date: 2017-11-03 00:35:06 Query_time: 6.793880 Rows_examined: 17579: Rows_sent 1176 Lock_time: 0.000116
# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
——————————————————————————————————-
5. Executed 13h 47m 6s ago for 6.543383 sec on Database –> Unknown (NOT FOUND / DELETED)
Date: 2017-11-02 21:16:03 Query_time: 6.543383 Rows_examined: 17436: Rows_sent 1172 Lock_time: 0.000166
# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
——————————————————————————————————-
6. Executed 13h 47m 6s ago for 6.54152 sec on Database –> Unknown (NOT FOUND / DELETED)
Date: 2017-11-02 21:16:03 Query_time: 6.541520 Rows_examined: 17436: Rows_sent 1172 Lock_time: 0.000196
# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
——————————————————————————————————-
7. Executed 15h 15m 11s ago for 6.155182 sec on Database –> chatha90_chat
Date: 2017-11-02 19:47:58 Query_time: 6.155182 Rows_examined: 17352: Rows_sent 1158 Lock_time: 0.023026
# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
——————————————————————————————————-
8. Executed 14h 2m 52s ago for 5.886644 sec on Database –> chatha90_chat
Date: 2017-11-02 21:00:17 Query_time: 5.886644 Rows_examined: 17421: Rows_sent 1171 Lock_time: 0.050135
# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
——————————————————————————————————-
9. Executed 16h 20m 59s ago for 5.749731 sec on Database –> chatha90_chat
Date: 2017-11-02 18:42:10 Query_time: 5.749731 Rows_examined: 17267: Rows_sent 1155 Lock_time: 0.000063
# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
——————————————————————————————————-
10. Executed 21h 58m 3s ago for 5.746756 sec on Database –> Unknown (NOT FOUND / DELETED)
Date: 2017-11-02 13:05:06 Query_time: 5.746756 Rows_examined: 17297: Rows_sent 1340 Lock_time: 0.000118
# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
——————————————————————————————————-

[Brendan]

Hi Rhonda,

Sorry you are experience performance issues.

You might want to ask your host about setting up object caching (memcached or similar) and query caching; we cannot advise how to set such things up.

Another idea is to remove (i.e. “clean up”) expired/unneeded event posts (including revisions if you have those enabled).

We also have a Performance Considerations KB article that may offer some guidance.

Hope that helps.

Thanks,

Brendan

[Rhonda]

Thank you for your assistance, I’ll see what else can be done. I don’t want to remove old links because that will end up giving me a bunch of 404 errors. What exactly are the above codes referencing?

[Brendan]

Hi Rhonda,

Those are common queries that need to be run to gather your info, however they are taking a while, more than usual. In regards to the 404 errors, you may want to look into a redirection plugin to handle any pages that are no longer on your site.

Let me know if you have any other questions.

Thanks,

Brendan

[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