Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-12403

Slow query detecting

Agile BoardAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    Description

      Hello,

      In cassandra production environment, users sometimes build anti-pattern tables and throw queries in inefficient manners.
      So I would like to suggest a feature that enables to log slow query.
      The feature can help cassandra operators to identify bad query patterns.
      Then operators can give advices about queries and data model to users who don't know cassandra so much.

      This ticket is related to CASSANDRA-6226, and I focus on detecting bad query patterns, not aborting them.

      Attachments

        1. slow_query.patch
          6 kB
          Shogo Hoshii
        2. slow_query.patch
          26 kB
          Shogo Hoshii
        3. sample.log
          0.9 kB
          Shogo Hoshii

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            shoshii Shogo Hoshii Assign to me
            shoshii Shogo Hoshii
            Shogo Hoshii
            Stefania Alborghetti
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment