advagg_get_files_from_hashes() function queries the database to get all the files that belong to the aggregate. Unfortunately this query regularly shows up in slow query log. Fixing this query seems like a no-brainer. I will upload a patch soon.

CommentFileSizeAuthor
#4 advagg-2294477-2-optimize_mysql_query.patch2.38 KBmikeytown2
#1 advagg-optimize_mysql_query-2294477-1.patch1.96 KBneeravbm

Comments

neeravbm’s picture

neeravbm commented
StatusFileSize
new advagg-optimize_mysql_query-2294477-1.patch1.96 KB
neeravbm’s picture

neeravbm commented
Status: Patch (to be ported) » Needs review

  • mikeytown2 committed 551f78c on 7.x-2.x authored by neeravbm 
    Issue #2294477 by neeravbm, mikeytown2: Optimize MySQL query to get...
mikeytown2’s picture

mikeytown2 commented
Status: Needs review » Fixed
StatusFileSize
new advagg-2294477-2-optimize_mysql_query.patch2.38 KB

Thanks! I committed a slightly modified version of your patch.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.