1
/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
* vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
4
* Copyright (C) 2009 Sun Microsystems
5
* Copyright (C) 2010 Mark Atwood
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.
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.
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
25
#include <sys/types.h>
29
#include <boost/date_time.hpp>
31
#include <drizzled/gettext.h>
32
#include <drizzled/session.h>
37
namespace drizzle_plugin
40
logging::Syslog::Syslog(const std::string &facility,
41
const std::string &priority,
42
uint64_t threshold_slow,
43
uint64_t threshold_big_resultset,
44
uint64_t threshold_big_examined) :
45
drizzled::plugin::Logging("Syslog Logging"),
46
_facility(WrapSyslog::getFacilityByName(facility.c_str())),
47
_priority(WrapSyslog::getPriorityByName(priority.c_str())),
48
_threshold_slow(threshold_slow),
49
_threshold_big_resultset(threshold_big_resultset),
50
_threshold_big_examined(threshold_big_examined)
54
drizzled::errmsg_printf(ERRMSG_LVL_WARN,
55
_("syslog facility \"%s\" not known, using \"local0\""),
57
_facility= WrapSyslog::getFacilityByName("local0");
62
drizzled::errmsg_printf(ERRMSG_LVL_WARN,
63
_("syslog priority \"%s\" not known, using \"info\""),
65
_priority= WrapSyslog::getPriorityByName("info");
70
bool logging::Syslog::post(drizzled::Session *session)
72
assert(session != NULL);
74
// return if query was not too small
75
if (session->sent_row_count < _threshold_big_resultset)
77
if (session->examined_row_count < _threshold_big_examined)
80
/* TODO, the session object should have a "utime command completed"
81
inside itself, so be more accurate, and so this doesnt have to
82
keep calling current_utime, which can be slow */
84
boost::posix_time::ptime mytime(boost::posix_time::microsec_clock::local_time());
85
boost::posix_time::ptime epoch(boost::gregorian::date(1970,1,1));
86
uint64_t t_mark= (mytime-epoch).total_microseconds();
88
// return if query was not too slow
89
if ((t_mark - session->start_utime) < _threshold_slow)
92
drizzled::Session::QueryString query_string(session->getQueryString());
93
drizzled::util::string::const_shared_ptr schema(session->schema());
95
WrapSyslog::singleton()
96
.log(_facility, _priority,
97
"thread_id=%ld query_id=%ld"
101
" t_connect=%lld t_start=%lld t_lock=%lld"
102
" rows_sent=%ld rows_examined=%ld"
103
" tmp_table=%ld total_warn_count=%ld\n",
104
(unsigned long) session->thread_id,
105
(unsigned long) session->getQueryId(),
106
(int) schema->size(),
107
schema->empty() ? "" : schema->c_str(),
108
(int) query_string->length(),
109
query_string->empty() ? "" : query_string->c_str(),
110
(int) drizzled::command_name[session->command].length,
111
drizzled::command_name[session->command].str,
112
(unsigned long long) (t_mark - session->getConnectMicroseconds()),
113
(unsigned long long) (t_mark - session->start_utime),
114
(unsigned long long) (t_mark - session->utime_after_lock),
115
(unsigned long) session->sent_row_count,
116
(unsigned long) session->examined_row_count,
117
(unsigned long) session->tmp_table,
118
(unsigned long) session->total_warn_count);
123
} /* namespsace drizzle_plugin */