Wassup hangs

Hello, i have issue wuth wordpress plugin wassup.

I visited page WassUp – Visitor Details. If i will open 3 or 4 page, then it hangs.

It usual hangs if i set filter – ‘No Spider’ and page 3 or 4.

I’ve found quries to database:

CREATE TEMPORARY TABLE IF NOT EXISTS _wassup_Pavel1743091987 AS (
    SELECT
        wassup_id,
        max(timestamp) as max_timestamp,
        min(timestamp) as min_timestamp,
        count(wassup_id) as page_hits,
        GROUP_CONCAT(DISTINCT username ORDER BY username SEPARATOR '| ') AS login_name,
        max(spam) AS malware_type,
        max(screen_res) as resolution
    FROM
        product_wassup
    WHERE timestamp>='1549278900' AND spider=''
		GROUP BY wassup_id
		ORDER BY max_timestamp DESC
	LIMIT 200,100
);

SELECT
    a1.*,
    b1.id,
    b1.timestamp,
    b1.ip,
    b1.hostname,
    b1.referrer,
    b1.comment_author,
    b1.agent,
    b1.browser,
    b1.os,
    b1.spider,
    b1.feed,
    b1.language,
    b1.search,
    b1.searchengine,
    b1.searchpage,
    c1.urlrequested,
    c1.url_wpid
FROM
    _wassup_Pavel1743091987 a1,
    product_wassup b1,
    product_wassup c1
WHERE b1.wassup_id = a1.wassup_id AND b1.timestamp = (
    SELECT 
        MIN(b2.timestamp)
    FROM product_wassup b2 WHERE b2.wassup_id = b1.wassup_id
) AND c1.wassup_id = a1.wassup_id AND c1.timestamp = (
    SELECT MAX(c2.timestamp) FROM product_wassup c2 WHERE c2.wassup_id = c1.wassup_id
);

Creating table has duration 200 ms. But “select” durates more 600000 ms.

Table “product_wassup” had 1500000 records one month ago. I thought issue with huge table. I’ve reduced to 200000 records. But it dont resolve issue.

• This topic was modified 5 years, 9 months ago by gothicprince.