Uploaded image for project: 'HBase'
  1. HBase
  2. HBASE-4542

add filter info to slow query logging

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.89.20100924
    • Fix Version/s: 0.94.0, 0.95.0
    • Component/s: None
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      Slow query log doesn't report filters in effect.

      For example:

      (operationTooSlow): \
      {"processingtimems":3468,"client":"10.138.43.206:40035","timeRange": [0,9223372036854775807],\
      "starttimems":1317772005821,"responsesize":42411, \
      "class":"HRegionServer","table":"myTable","families":{"CF1":"ALL"]},\
      "row":"6c3b8efa132f0219b7621ed1e5c8c70b","queuetimems":0,\
      "method":"get","totalColumns":1,"maxVersions":1,"storeLimit":-1}
      

      the above would suggest that all columns of myTable:CF1 are being requested for the given row. But in reality there could be filters in effect (such as ColumnPrefixFilter, ColumnRangeFilter, TimestampsFilter() etc.). We should enhance the slow query log to capture & report this information.

        Attachments

          Activity

            People

            • Assignee:
              madhuvaidya Madhuwanti Vaidya
              Reporter:
              kannanm Kannan Muthukkaruppan
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: