[HBASE-4117] Slow Query Log

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.92.0
• Component/s: IPC/RPC
• Labels: client ipc
• Hadoop Flags: Reviewed

Release Note

Exposes JSON-parseable fingerprint and details for queries that take longer than a configurable threshold time. The exposure is currently to the main regionserver log, along with a (queryTooSlow) tag which allows it to be grepped out and easily aggregated and/or monitored in adminstrator scripts.

The patch also provides a standard way to extract fingerprint and detail information of interest by requiring each "DatabaseCommand" to provide a fingerprint map and a details map, which will be a superset of the fingerprint.

• Assignee: Riley Patterson
• Reporter: Riley Patterson
• Created: 19/Jul/11 21:58
• Updated: 20/Nov/15 11:55
• Resolved: 27/Aug/11 04:02

Description

Produce log messages for slow queries. The RPC server will decide what is slow based on a configurable "warn response time" parameter. Queries designated as slow will then output a "response too slow" message followed by a fingerprint of the query, and a summary limited in size by another configurable parameter (to limit log spamming).