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’ FROMwp_ngg_pictures
LEFT OUTER JOINwp_options
ON
wp_options
.option_name = CONCAT(‘wp_ngg_pictures_’, wp_ngg_pictures.pid)
LEFT OUTER JOINwp_postmeta
ONwp_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’ FROMwp_ngg_pictures
LEFT OUTER JOINwp_options
ON
wp_options
.option_name = CONCAT(‘wp_ngg_pictures_’, wp_ngg_pictures.pid)
LEFT OUTER JOINwp_postmeta
ONwp_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
- The topic ‘Upload slows database and results in time out’ is closed to new replies.