Listening for slow queries?


(Otis Gospodnetić) #1

Hello,

Is there any way to hook up to ES and listed for slow queries? By slow
queries I mean
http://www.elasticsearch.org/guide/reference/index-modules/slowlog.html .
I'd love to be able to have some sort of a listener and do something
custom (e.g. log elsewhere, index, analyze, rewrite, etc.) with slow
queries.

If there is no way to do that, should I open an issue?

Thanks,
Otis

ElasticSearch Performance Monitoring - http://sematext.com/spm/index.html


(Igor Motov) #2

Otis,

Slow queries are logged by a standard ES logger. The logging.xml file
configures this logger to use DailyRollingFileAppender to log slow query
messages to a separate file. You can replace DailyRollingFileAppender with
your own custom appender by adding your appender to the elasticsearch
classpath and specifying your appender's class name in

appender:
index_search_slow_log_file:
type: com.sematext.YourCustomAppender
...

Igor

On Thursday, April 26, 2012 3:47:21 PM UTC-4, Otis Gospodnetic wrote:

Hello,

Is there any way to hook up to ES and listed for slow queries? By slow
queries I mean
http://www.elasticsearch.org/guide/reference/index-modules/slowlog.html .
I'd love to be able to have some sort of a listener and do something
custom (e.g. log elsewhere, index, analyze, rewrite, etc.) with slow
queries.

If there is no way to do that, should I open an issue?

Thanks,
Otis

ElasticSearch Performance Monitoring - http://sematext.com/spm/index.html


(Shay Banon) #3

As igore pointed out, an appender is the only way to go. We could allow for
plugins to register custom listeners for it.

On Sat, Apr 28, 2012 at 8:24 AM, Igor Motov imotov@gmail.com wrote:

Otis,

Slow queries are logged by a standard ES logger. The logging.xml file
configures this logger to use DailyRollingFileAppender to log slow query
messages to a separate file. You can replace DailyRollingFileAppender with
your own custom appender by adding your appender to the elasticsearch
classpath and specifying your appender's class name in

appender:
index_search_slow_log_file:
type: com.sematext.YourCustomAppender
...

Igor

On Thursday, April 26, 2012 3:47:21 PM UTC-4, Otis Gospodnetic wrote:

Hello,

Is there any way to hook up to ES and listed for slow queries? By slow
queries I mean http://www.elasticsearch.org/guide/reference/index-
modules/slowlog.htmlhttp://www.elasticsearch.org/guide/reference/index-modules/slowlog.html .
I'd love to be able to have some sort of a listener and do something
custom (e.g. log elsewhere, index, analyze, rewrite, etc.) with slow
queries.

If there is no way to do that, should I open an issue?

Thanks,
Otis

ElasticSearch Performance Monitoring - http://sematext.com/spm/index.**
html http://sematext.com/spm/index.html


(system) #4