Support » Plugin: WordPress Gallery Plugin - NextGEN Gallery » Upload slows database and results in time out

  • I’m using the latest version of WordPress and Nextgen Gallery (2.0.40)

    When i try to upload photos from Lightroom via the Nextgen Gallery plugin for lightroom (by Alloyphoto), before anything actually uploads, I get a message that the connection has timed out. Concurrently, my website slows to a crawl, and sometimes is completely non-responsive for several minutes after.

    My web host support has helped me trace the problem, and said there were some slow_log entries for the database that occurred at the time I tried to upload. I was sent a couple of them, which I have copied below:

    # Time: 131215 18:20:09
    # Query_time: 32.511420 Lock_time: 0.000093 Rows_sent: 1 Rows_examined:
    2346985
    SET timestamp=1387149609;
    SELECT DISTINCT COUNT(*) as counter , wp_options.option_value AS
    ‘custom_post_id’, GROUP_CONCAT(CONCAT_WS(‘@@’, meta_key, meta_value)) AS
    ‘extras’ FROM wp_ngg_pictures LEFT OUTER JOIN wp_options ON
    wp_options.option_name = CONCAT(‘wp_ngg_pictures_’, wp_ngg_pictures.pid)
    LEFT OUTER JOIN wp_postmeta ON wp_postmeta.post_id =
    wp_options.option_value WHERE (galleryid = 13) GROUP BY
    wp_ngg_pictures.pid;

    # Time: 131215 18:20:10
    # Query_time: 32.304843 Lock_time: 0.000153 Rows_sent: 1 Rows_examined:
    2346985
    SET timestamp=1387149610;
    SELECT DISTINCT COUNT(*) as counter , wp_options.option_value AS
    ‘custom_post_id’, GROUP_CONCAT(CONCAT_WS(‘@@’, meta_key, meta_value)) AS
    ‘extras’ FROM wp_ngg_pictures LEFT OUTER JOIN wp_options ON
    wp_options.option_name = CONCAT(‘wp_ngg_pictures_’, wp_ngg_pictures.pid)
    LEFT OUTER JOIN wp_postmeta ON wp_postmeta.post_id =
    wp_options.option_value WHERE (galleryid = 13) GROUP BY
    wp_ngg_pictures.pid;

    The support told me these may have backlogged and caused enough delay for PHP to time out. I was told that perhaps throttling uploads or optimizing the query could fix the problem.

    In case it matters, I do have 9400+ photos in 900+ galleries and 30+ albums. –

    I’m not sure what I can do from here and would appreciate any help.

    Thanks

    http://wordpress.org/plugins/nextgen-gallery/

Viewing 1 replies (of 1 total)
  • yes, when I call “Other Options” this query kills my database. Downgrading to 2.33 fixes this problem.

Viewing 1 replies (of 1 total)
  • The topic ‘Upload slows database and results in time out’ is closed to new replies.