Drizzled Public API Documentation

logging.cc
1 /* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2  * vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
3  *
4  * Copyright (C) 2009 Sun Microsystems, Inc.
5  * Copyright (C) 2010 Mark Atwood
6  *
7  * This program is free software; you can redistribute it and/or modify
8  * it under the terms of the GNU General Public License as published by
9  * the Free Software Foundation; version 2 of the License.
10  *
11  * This program is distributed in the hope that it will be useful,
12  * but WITHOUT ANY WARRANTY; without even the implied warranty of
13  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14  * GNU General Public License for more details.
15  *
16  * You should have received a copy of the GNU General Public License
17  * along with this program; if not, write to the Free Software
18  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
19  */
20 
21 #include <config.h>
22 
23 #include <cstdarg>
24 #include <limits.h>
25 #include <sys/types.h>
26 #include <sys/stat.h>
27 #include <fcntl.h>
28 
29 #include <boost/date_time.hpp>
30 
31 #include <drizzled/gettext.h>
32 #include <drizzled/session.h>
33 #include <drizzled/session/times.h>
34 #include <drizzled/sql_parse.h>
35 #include <drizzled/plugin.h>
36 #include <drizzled/error.h>
37 
38 #include "logging.h"
39 #include "wrap.h"
40 
41 namespace drizzle_plugin {
42 
43 logging::Syslog::Syslog(const std::string &facility,
44  uint64_t threshold_slow,
45  uint64_t threshold_big_resultset,
46  uint64_t threshold_big_examined) :
47  drizzled::plugin::Logging("syslog_query_log"),
48  _facility(WrapSyslog::getFacilityByName(facility.c_str())),
49  _threshold_slow(threshold_slow),
50  _threshold_big_resultset(threshold_big_resultset),
51  _threshold_big_examined(threshold_big_examined)
52 {
53  if (_facility < 0)
54  {
55  drizzled::errmsg_printf(drizzled::error::WARN,
56  _("syslog facility \"%s\" not known, using \"local0\""),
57  facility.c_str());
58  _facility= WrapSyslog::getFacilityByName("local0");
59  }
60 }
61 
62 
63 bool logging::Syslog::post(drizzled::Session *session)
64 {
65  assert(session != NULL);
66 
67  // return if query was not too small
68  if (session->sent_row_count < _threshold_big_resultset)
69  {
70  return false;
71  }
72 
73  if (session->examined_row_count < _threshold_big_examined)
74  {
75  return false;
76  }
77 
78  /*
79  TODO, the session object should have a "utime command completed"
80  inside itself, so be more accurate, and so this doesnt have to
81  keep calling current_utime, which can be slow.
82  */
83  uint64_t t_mark= session->times.getCurrentTimestamp(false);
84 
85  // return if query was not too slow
86  if (session->times.getElapsedTime() < _threshold_slow)
87  {
88  return false;
89  }
90 
91  drizzled::Session::QueryString query_string(session->getQueryString());
92  drizzled::util::string::ptr schema(session->schema());
93 
94  WrapSyslog::singleton()
95  .log(_facility, drizzled::error::INFO,
96  "thread_id=%ld query_id=%ld"
97  " db=\"%.*s\""
98  " query=\"%.*s\""
99  " command=\"%.*s\""
100  " t_connect=%lld t_start=%lld t_lock=%lld"
101  " rows_sent=%ld rows_examined=%ld"
102  " tmp_table=%ld total_warn_count=%ld\n",
103  (unsigned long) session->thread_id,
104  (unsigned long) session->getQueryId(),
105  (int) schema->size(),
106  schema->empty() ? "" : schema->c_str(),
107  (int) query_string->length(),
108  query_string->empty() ? "" : query_string->c_str(),
109  (int) drizzled::getCommandName(session->command).size(),
110  drizzled::getCommandName(session->command).c_str(),
111  (unsigned long long) (t_mark - session->times.getConnectMicroseconds()),
112  (unsigned long long) (session->times.getElapsedTime()),
113  (unsigned long long) (t_mark - session->times.utime_after_lock),
114  (unsigned long) session->sent_row_count,
115  (unsigned long) session->examined_row_count,
116  (unsigned long) session->tmp_table,
117  (unsigned long) session->total_warn_count);
118 
119  return false;
120 }
121 
122 } /* namespsace drizzle_plugin */