• Hi again, how you doing?

    I’m almost at the point of migrating the site to my client’s server so, before updating a few plugins, I installed Query Monitor and… well, it throws a lot of Slow Queries in your direction…
    (mind you, I’m running your 2.0.7 version)
    Mostly, one of those for each image in a page (sometimes 17 of those!) and they’re all marked SLOW:

    QUERY:
    INSERT INTO wp_options (option_name, option_value, autoload)
    VALUES (‘_transient_mwl_exif_13211_XX’, ‘a:6:{s:7:\”success\”;b:1;s:4:\”file\”;s:108:\”h–ps://domainddresshere.zzz/wp-content/uploads/2020/01/Capela_do_Morumbi_05-e1580308468544-scaled.jpg\”;s:11:\”file_srcset\”;s:1062:\”h–ps://domainddresshere.zzz/wp-content/uploads/2020/01/Capela_do_Morumbi_05-e1580308468544-scaled.jpg 2560w, h–ps://domainddresshere.zzz/wp-content/uploads/2020/01/Capela_do_Morumbi_05-e1580308468544-scaled-600×405.jpg 600w, h–ps://domainddresshere.zzz/wp-content/uploads/2020/01/Capela_do_Morumbi_05-e1580308468544-300×203.jpg 300w, h–ps://domainddresshere.zzz/wp-content/uploads/2020/01/Capela_do_Morumbi_05-e1580308468544-1024×691.jpg 1024w, h–ps://domainddresshere.zzz/wp-content/uploads/2020/01/Capela_do_Morumbi_05-e1580308468544-768×519.jpg 768w, h–ps://domainddresshere.zzz/wp-content/uploads/2020/01/Capela_do_Morumbi_05-e1580308468544-1536×1037.jpg 1536w, h–ps://domainddresshere.zzz/wp-content/uploads/2020/01/Capela_do_Morumbi_05-e1580308468544-2048×1383.jpg 2048w, h–ps://domainddresshere.zzz/wp-content/uploads/2020/01/Capela_do_Morumbi_05-e1580308468544-1200×810.jpg 1200w, h–ps://domainddresshere.zzz/wp-content/uploads/2020/01/Capela_do_Morumbi_05-e1580308468544-1980×1337.jpg 1980w\”;s:10:\”file_sizes\”;s:83:\”(min-width: 1220px) 380px, (min-width: 700px) calc(50vw – 56px), calc(100vw – 40px)\”;s:9:\”dimension\”;a:2:{s:5:\”width\”;i:2560;s:6:\”height\”;i:1728;}s:4:\”data\”;a:13:{s:2:\”id\”;i:13211;s:5:\”title\”;s:20:\”Capela_do_Morumbi_05\”;s:7:\”caption\”;s:0:\”\”;s:11:\”description\”;s:0:\”\”;s:3:\”gps\”;s:3:\”N/A\”;s:9:\”copyright\”;s:3:\”N/A\”;s:6:\”camera\”;s:3:\”N/A\”;s:4:\”date\”;s:18:\”01/01/1970 – 00:00\”;s:4:\”lens\”;s:3:\”N/A\”;s:8:\”aperture\”;s:3:\”N/A\”;s:12:\”focal_length\”;s:3:\”N/A\”;s:3:\”iso\”;s:3:\”N/A\”;s:13:\”shutter_speed\”;s:3:\”N/A\”;}}’, ‘no’)
    ON DUPLICATE KEY
    UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    CALLER:
    add_option

    CALLER (expanded) :
    add_option
    set_transient
    Meow_Lightbox_Core->get_exif_info
    Meow_Lightbox_Core->write_mwl_data
    Meow_Lightbox_Core->wp_footer
    WP_Hook->apply_filters
    WP_Hook->do_action
    do_action(‘wp_footer’)
    wp_footer
    require_once(‘/themes/twentyaqa/footer.php’)
    load_template
    locate_template
    get_footer
    include(‘/themes/twentyaqa/index.php’)
    require_once(‘wp-includes/template-loader.php’)
    require(‘wp-blog-header.php’)

    Any ideas on what I might be doing wrong?

    Thanks in advance!
    PS: I changed my domain addres, and also all “https” so the system accepts the post

    • This topic was modified 4 years, 6 months ago by wagedu.
Viewing 1 replies (of 1 total)
  • Thread Starter wagedu

    (@wagedu)

    Something more came up:
    I noticed that, after browsing my media files in the admin, lots of new entries (and I mean LOTS) of _transients appeared in my wp_options table:
    A new row for: _transient_timeout_mwl_exif_9516_XX
    and then another row for: _transient_mwl_exif_9516_XX
    Times every thumbnail scrolled in the media browser!

    That generated over 1Mb increase in a 35Mb database… only by scrolling.

    Is this by design or some error?

    Thanks in advance

    PS: this time I have the updated plugin 3.0.0

    • This reply was modified 4 years, 5 months ago by wagedu.
Viewing 1 replies (of 1 total)
  • The topic ‘Slow queries’ is closed to new replies.