Skip to main content

Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

    •  
      request #13408 Display of a tracker table report can be slow due to a confusion of the MySQL optimizer
    Actions
    Infos
    #13408
    Thomas Gerbet (tgerbet)
    2019-05-24 14:22
    2019-05-24 13:36
    14532
    Details
    Display of a tracker table report can be slow due to a confusion of the MySQL optimizer
    The SQL query that is built to retrieve the artifacts to display gives both the artifact IDs and the corresponding last changeset IDs as a parameter of the query.
    Besides being not useful (an changeset matching only one artifact) it seems that in some cases, it confuses the MySQL query optimizer resulting in very slow queries and it prevents the report to be displayed because the timeout limits are reached.
    Trackers
    All
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Thomas Gerbet (tgerbet)
    Closed
    2019-05-24
    Attachments
    Artifact links

    Releases

    Fixed in

    Artifact ID Project Tracker Summary Status Last Update Date Submitted By Assigned to
    rel #13072 Tuleap Releases 11.2 Delivered 2019-05-29 16:32 Manuel Vacelet (vaceletm)
    Empty
    References
    Referencing request #13408

    Git commit

    tuleap/tuleap/stable

    Merge commit 'refs/changes/48/15048/1' of ssh://gerrit.tuleap.net:29418/tuleap into HEAD ac4ddb787b
    User avatar Yannis ROSSETTO (rossettoy) , 2019-05-24 14:20
    request #13408: Display of a tracker table report can be slow due to a confusion of the MySQL optimizer 103d5a541f
    User avatar Thomas Gerbet (tgerbet) , 2019-05-24 13:36
    Referenced by request #13408

    Artifact Tracker v5

    rel #13072 11.2

    Other

    gerrit #15048
    Display settings

    Follow-ups

    User avatar
    Yannis ROSSETTO (rossettoy)2019-05-24 14:22
    Integrated into Tuleap 11.1.99.132
    • Status changed from Under review to Closed
    • Connected artifacts
    • Close date set to 2019-05-24