Hello
My server hosts have notified me of the following issue:
As you can see below, there are multiple concurrent queries for the same query parameters (same 'user_id' search), and each query takes over 2 seconds. I want to understand why this happening (there should only be 1 query, not multiple queries with the same parameters),
Time: 2019-03-04T04:52:02.323104Z
User@Host: wp_nrlsctalk[wp_nrlsctalk] @ localhost [] Id: 5903
Query_time: 2.102812 Lock_time: 0.000050 Rows_sent: 0 Rows_examined: 142515
SET timestamp=1551675122;
SELECT comment_ID
FROM wp_comments
WHERE comment_type
= 'private' AND comment_parent
= 0 AND user_id
= 46057;
Time: 2019-03-04T04:52:02.384026Z
User@Host: wp_nrlsctalk[wp_nrlsctalk] @ localhost [] Id: 5907
Query_time: 2.205697 Lock_time: 0.000049 Rows_sent: 0 Rows_examined: 142515
SET timestamp=1551675122;
SELECT comment_ID
FROM wp_comments
WHERE comment_type
= 'private' AND comment_parent
= 0 AND user_id
= 46057;
Time: 2019-03-04T04:52:02.455034Z
User@Host: wp_nrlsctalk[wp_nrlsctalk] @ localhost [] Id: 5905
Query_time: 2.196140 Lock_time: 0.000056 Rows_sent: 0 Rows_examined: 142515
SET timestamp=1551675122;
SELECT comment_ID
FROM wp_comments
WHERE comment_type
= 'private' AND comment_parent
= 0 AND user_id
= 46057;
Time: 2019-03-04T04:52:02.457939Z
User@Host: wp_nrlsctalk[wp_nrlsctalk] @ localhost [] Id: 5904
Query_time: 2.419714 Lock_time: 0.000049 Rows_sent: 0 Rows_examined: 142515
SET timestamp=1551675122;
SELECT comment_ID
FROM wp_comments
WHERE comment_type
= 'private' AND comment_parent
= 0 AND user_id
= 46057;