YASR causing excessive disk i/o

  • Resolved kenmcmahon

    (@kenmcmahon)


    6 years, 6 months ago

    Hi,
    Lately, possibly since the 1.6.2 update, we’ve been getting spikes in CPU and disc i/o on our server, which we’ve tracked down to YASR sql activity (see below). Any ideas why this is happening and what we can do to stop it?
    Thanks
    Ken

    mysql> show processlist;
    +——-+———–+———–+———–+———+——+———-+——————————————————————————————————+
    | Id | User | Host | db | Command | Time | State | Info |
    +——-+———–+———–+———–+———+——+———-+——————————————————————————————————+
    | 86639 | wordpress | localhost | wordpress | Query | 1 | updating | DELETE FROM wp_options
    WHERE option_name LIKE ‘_transient_yasr_get_multi_set_values_and_field_%’
    |
    +——-+———–+———–+———–+———+——+———-+——————————————————————————————————+

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor dudo

    (@dudo)

    Hi Ken, thank you for using Yasr!

    That is a simply delete of a WordPress transient.

    It should run only when an user click on “Multi Sets” tab in the YAsr settings…SHOULD, because it’s running always in the WordPress Dashboard indeed.

    Will be fixed on Yasr 1.6.3.

    Thank you for sharing this!

    • This reply was modified 6 years, 6 months ago by dudo.
    Plugin Contributor dudo

    (@dudo)

    Fixed with version 1.6.3

    Thread Starter kenmcmahon

    (@kenmcmahon)

    Thanks Dudo. Will update and let you know how it goes. Still not sure why all the disk i/o in the first place as we just use the plugin to assign a star rating to reviews in the back-end. That’s it.
    Anyway, thanks for your help.

    Ken

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘YASR causing excessive disk i/o’ is closed to new replies.

Tags