• Resolved Lirkun

    (@lirkun)


    Hi,
    After updating to new version 4.0.12 (not sure may be started earlier from v 4+)
    Have unlimited amount of repeating queries in Mysql slow query log.
    The process is constant and endless, seriously damaging my db performance. Just a log itself growing like 10mb+ per 1h. I think as a result this two guys: “Handler read rnd” and “Handler read rnd next” are growing super fast in number reaching 60+M at the end of the day.

    Tried to disable all other plugins (I belive the list is in config file at the bottom), didn’t help, as well as reinstall or clearing some db table ect.

    Right now had to downgrade to 3.7.1 because had db crashes once a day for sure.

    Looks like this:

    
    *
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    	<code>notification_name</code> = 'description-format'
    /* 1 = 1 */;
    # Time: 2021-01-28T22:12:11.508750Z
    # User@Host: example_db[example_db] @ localhost []  Id:   344
    # Query_time: 0.000147  Lock_time: 0.000067 Rows_sent: 0  Rows_examined: 0
    SET timestamp=1611871931;
    SELECT 
    	*
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    	<code>notification_name</code> = 'woo-upsell'
    /* 1 = 1 */;
    # Time: 2021-01-28T22:12:11.540258Z
    # User@Host: example_db[example_db] @ localhost []  Id:   344
    # Query_time: 0.000144  Lock_time: 0.000070 Rows_sent: 0  Rows_examined: 0
    SET timestamp=1611871931;
    SELECT 
    	*
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    	<code>notification_name</code> = 'deprecated-filters'
    /* 1 = 1 */;
    # Time: 2021-01-28T22:12:11.540575Z
    # User@Host: example_db[example_db] @ localhost []  Id:   344
    # Query_time: 0.000105  Lock_time: 0.000053 Rows_sent: 0  Rows_examined: 0
    SET timestamp=1611871931;
    SELECT 
    	*
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    	<code>notification_name</code> = 'deprecated-filters-v2'
    /* 1 = 1 */;
    # Time: 2021-01-28T22:12:11.837276Z
    # User@Host: example_db[example_db] @ localhost []  Id:   345
    # Query_time: 0.000121  Lock_time: 0.000060 Rows_sent: 0  Rows_examined: 0
    SET timestamp=1611871931;
    SELECT 
    	*
    FROM wp_aioseo_notifications
    WHERE 1 = 1 AND
    	<code>notification_name</code> = 'blog-visibility'
    /* 1 = 1 */;
    # Time: 2021-01-28T22:12:11.838699Z
    # User@Host: example_db[example_db] @ localhost []  Id:   345
    # Query_time: 0.000113  Lock_time: 0.000055 Rows_sent: 0  Rows_examined: 0
    SET timestamp=1611871931;
    SELECT 
    	*
    

    My config (exported from aioseo):
    aioseo-system-status

    Hope it will help to figure out the issue.

    Thanks.

Viewing 1 replies (of 1 total)
  • Plugin Author arnaudbroes

    (@arnaudbroes)

    Hey @lirkun,

    Would you mind reaching out to us so we can troubleshoot this for you – https://aioseo.com/contact/. You can click the “Submit a Form” button on that page and paste the URL of this thread in your message.

    We haven’t had anyone else report something like this so we’d love to take a look.

    – Arnaud

Viewing 1 replies (of 1 total)
  • The topic ‘Deprecated-filters and other in mysql slow queries’ is closed to new replies.