lovedigit
👽 Chevereto Freak
I don't know if it was always like this, or some recent change is the culprit.
Images inside large albums loads without any issues. No slow query log too.
But when I open an image from these albums, it takes 4-5 seconds to get the first byte. After that it loads within a second.
Can anyone else on latest beta test it out at their end?
Here is the example of such image - https://lensdump.com/i/8ukVfe
Please help me figure it out. It doesn't makes sense that website is slow only on image viewer page when said image belongs to a large album.
Here is the mysql slow query log. There is no error in the backend.
[CODE lang="apacheconf" title="Mysql slow query log"]# Time: 210501 6:57:55
# User@Host: chevereto[chevereto] @ localhost []
# Thread_id: 4184 Schema: chevereto QC_hit: No
# Query_time: 6.626535 Lock_time: 0.000153 Rows_sent: 6 Rows_examined: 712873
# Rows_affected: 0 Bytes_sent: 18569
SET timestamp=1619852275;
SELECT * , NULL as image_original_exifdata FROM (SELECT * FROM chv_images
WHERE chv_images.image_album_id=2 AND chv_images.image_id <= 316993 AND chv_images.image_is_approved = 1 AND image_size > 0
ORDER BY chv_images.image_date_gmt DESC, chv_images.image_id DESC
LIMIT 6) chv_images
LEFT JOIN chv_storages ON chv_images.image_storage_id = chv_storages.storage_id
LEFT JOIN chv_users ON chv_images.image_user_id = chv_users.user_id
LEFT JOIN chv_albums ON chv_images.image_album_id = chv_albums.album_id
LEFT JOIN chv_categories ON chv_images.image_category_id = chv_categories.category_id
LEFT JOIN chv_likes ON chv_likes.like_content_type = "image" AND chv_likes.like_content_id = chv_images.image_id AND chv_likes.like_user_id = 1
ORDER BY chv_images.image_date_gmt DESC, chv_images.image_id DESC;
[/CODE]
Images inside large albums loads without any issues. No slow query log too.
But when I open an image from these albums, it takes 4-5 seconds to get the first byte. After that it loads within a second.
Can anyone else on latest beta test it out at their end?
Here is the example of such image - https://lensdump.com/i/8ukVfe
Please help me figure it out. It doesn't makes sense that website is slow only on image viewer page when said image belongs to a large album.
Here is the mysql slow query log. There is no error in the backend.
[CODE lang="apacheconf" title="Mysql slow query log"]# Time: 210501 6:57:55
# User@Host: chevereto[chevereto] @ localhost []
# Thread_id: 4184 Schema: chevereto QC_hit: No
# Query_time: 6.626535 Lock_time: 0.000153 Rows_sent: 6 Rows_examined: 712873
# Rows_affected: 0 Bytes_sent: 18569
SET timestamp=1619852275;
SELECT * , NULL as image_original_exifdata FROM (SELECT * FROM chv_images
WHERE chv_images.image_album_id=2 AND chv_images.image_id <= 316993 AND chv_images.image_is_approved = 1 AND image_size > 0
ORDER BY chv_images.image_date_gmt DESC, chv_images.image_id DESC
LIMIT 6) chv_images
LEFT JOIN chv_storages ON chv_images.image_storage_id = chv_storages.storage_id
LEFT JOIN chv_users ON chv_images.image_user_id = chv_users.user_id
LEFT JOIN chv_albums ON chv_images.image_album_id = chv_albums.album_id
LEFT JOIN chv_categories ON chv_images.image_category_id = chv_categories.category_id
LEFT JOIN chv_likes ON chv_likes.like_content_type = "image" AND chv_likes.like_content_id = chv_images.image_id AND chv_likes.like_user_id = 1
ORDER BY chv_images.image_date_gmt DESC, chv_images.image_id DESC;
[/CODE]
Last edited: