lqdetect.c

#include <stdio.h>
#include <stdint.h>
#include <stdlib.h>
#include <stdbool.h>
#include <string.h>
#include <pthread.h>
#include <sys/time.h>
#include <assert.h>
#include <memcached/util.h>

#include "lqdetect.h"

#define LQ_THRESHOLD_DEFAULT 4000
#define LQ_QUERY_SIZE  (64*2+64) /* bop get (longest query) : "<longest bkey>..<longest bkey> efilter <offset> <count> delete" */
#define LQ_SAVE_CNT    20        /* save key count */
#define LQ_INPUT_SIZE  500       /* the size of input(time, ip, command, argument) */
#define LQ_STAT_STRLEN 300       /* max length of stats */

/* lqdetect state */
#define LQ_EXPLICIT_STOP 0       /* stop by user request */
#define LQ_OVERFLOW_STOP 1       /* stop by detected command overflow (buffer or count) */
#define LQ_RUNNING       2       /* long query is running */

/* lqdetect command */
enum lq_detect_command {
    LQCMD_SOP_GET=0,
    LQCMD_MOP_DELETE,
    LQCMD_MOP_GET,
    LQCMD_LOP_INSERT,
    LQCMD_LOP_DELETE,
    LQCMD_LOP_GET,
    LQCMD_BOP_DELETE,
    LQCMD_BOP_GET,
    LQCMD_BOP_COUNT,
    LQCMD_BOP_GBP
};
#define LQ_CMD_NUM (LQCMD_BOP_GBP+1) /* the number of command to detect */

static EXTENSION_LOGGER_DESCRIPTOR *mc_logger;
static const char *command_str[LQ_CMD_NUM] = {
    "sop get","mop delete", "mop get",
    "lop insert", "lop delete", "lop get",
    "bop delete", "bop get", "bop count", "bop gbp"
};

/* lqdetect stats structure */
struct lq_detect_stats {
    int bgndate, bgntime;
    int enddate, endtime;
    int total;  /* number of total long query command */
    int state;  /* lqdetect state */
    uint32_t threshold;
};

/* lqdetect argument structure */
struct lq_detect_argument {
    char query[LQ_QUERY_SIZE];
    uint32_t count;
    uint32_t overhead;
};

/* lqdetect buffer structure */
struct lq_detect_buffer {
    char *data;
    uint32_t offset;
    uint32_t ntotal;
    uint32_t nsaved;
    uint32_t keypos[LQ_SAVE_CNT];
    uint32_t keylen[LQ_SAVE_CNT];
};

/* lqdetect global structure */
struct lq_detect_global {
    pthread_mutex_t lock;
    struct lq_detect_argument arg[LQ_CMD_NUM][LQ_SAVE_CNT];
    struct lq_detect_buffer buffer[LQ_CMD_NUM];
    struct lq_detect_stats stats;
    int overflow_cnt;
    bool on_detect;
    uint16_t refcount; /* lqdetect show reference count */
};
struct lq_detect_global lqdetect;

/* lqdetect function */
static void do_lqdetect_stop(int cause)
{
    /* detect long query lock has already been held */
    lqdetect.stats.state = cause;
    lqdetect.stats.enddate = getnowdate_int();
    lqdetect.stats.endtime = getnowtime_int();
    lqdetect.on_detect = false;
}

int lqdetect_init(EXTENSION_LOGGER_DESCRIPTOR *logger)
{
    mc_logger = logger;
    pthread_mutex_init(&lqdetect.lock, NULL);
    lqdetect.on_detect = false;

    memset(lqdetect.buffer, 0, LQ_CMD_NUM * sizeof(struct lq_detect_buffer));
    memset(&lqdetect.stats, 0, sizeof(struct lq_detect_stats));
    for (int ii = 0; ii < LQ_CMD_NUM; ii++) {
        lqdetect.buffer[ii].data = malloc(LQ_SAVE_CNT * LQ_INPUT_SIZE);
        if (lqdetect.buffer[ii].data == NULL) {
            while (--ii >= 0) {
                free(lqdetect.buffer[ii].data);
            }
            return -1;
        }
        memset(lqdetect.arg[ii], 0, LQ_SAVE_CNT * sizeof(struct lq_detect_argument));
    }
    lqdetect.refcount = 0;
    return 0;
}

void lqdetect_final()
{
    for (int ii = 0; ii < LQ_CMD_NUM; ii++) {
        free(lqdetect.buffer[ii].data);
        lqdetect.buffer[ii].data = NULL;
    }
}

int lqdetect_start(uint32_t threshold, bool *already_started)
{
    int ret = 0;
    pthread_mutex_lock(&lqdetect.lock);
    do {
        if (lqdetect.on_detect) {
            *already_started = true;
            break;
        }

        /* if lqdetect showing, start is fail */
        if (lqdetect.refcount != 0) {
            ret = -1;
            break;
        }

        /* prepare detect long query buffer, argument and counts*/
        for (int ii = 0; ii < LQ_CMD_NUM; ii++) {
            lqdetect.buffer[ii].ntotal = 0;
            lqdetect.buffer[ii].nsaved = 0;
            lqdetect.buffer[ii].offset = 0;
        }

        /* prepare detect long query stats */
        memset(&lqdetect.stats, 0, sizeof(struct lq_detect_stats));
        lqdetect.stats.bgndate = getnowdate_int();
        lqdetect.stats.bgntime = getnowtime_int();
        lqdetect.stats.state = LQ_RUNNING;
        lqdetect.stats.threshold = (threshold == 0 ? LQ_THRESHOLD_DEFAULT : threshold);

        lqdetect.overflow_cnt = 0;
        lqdetect.on_detect = true;
        ret = 0;
    } while(0);
    pthread_mutex_unlock(&lqdetect.lock);
    return ret;
}

void lqdetect_stop(bool *already_stopped)
{
    pthread_mutex_lock(&lqdetect.lock);
    if (lqdetect.on_detect == true) {
        do_lqdetect_stop(LQ_EXPLICIT_STOP);
    } else {
        *already_stopped = true;
    }
    pthread_mutex_unlock(&lqdetect.lock);
}

char *lqdetect_stats(void)
{
    char *str = (char*)malloc(LQ_STAT_STRLEN);
    if (str) {
        char *state_str[3] = {
            "stopped by explicit request",          // LQ_EXPLICIT_STOP
            "stopped by internal buffer overflow",  // LQ_OVERFLOW_STOP
            "running"                               // LQ_RUNNING
        };
        struct lq_detect_stats stats = lqdetect.stats;

        if (lqdetect.on_detect) {
            stats.enddate = 0;
            stats.endtime = 0;
        }

        stats.total = 0;
        for (int i=0; i < LQ_CMD_NUM; i++) {
            stats.total += lqdetect.buffer[i].ntotal;
        }

        snprintf(str, LQ_STAT_STRLEN,
                "\t" "Long query detection stats : %s" "\n"
                "\t" "The last running time : %d_%d ~ %d_%d" "\n"
                "\t" "The number of total long query commands : %d" "\n"
                "\t" "The detection threshold : %u" "\n",
                (stats.state >= 0 && stats.state <= 2 ?
                 state_str[stats.state] : "unknown"),
                stats.bgndate, stats.bgntime, stats.enddate, stats.endtime,
                stats.total, stats.threshold);
    }
    return str;
}

field_t *lqdetect_result_get(int *size)
{
    int hdrlen = 32;
    int fldarr_size = LQ_CMD_NUM * 2 * sizeof(field_t);
    int hdrarr_size = LQ_CMD_NUM * hdrlen; /* command, ntotal */
    /* field_t and header string array */
    field_t *fldarr = (field_t*)malloc(fldarr_size + hdrarr_size);
    if (fldarr == NULL) {
        return NULL;
    }
    char *hdrptr = (char*)fldarr + fldarr_size;
    int fldcnt = 0;

    pthread_mutex_lock(&lqdetect.lock);
    /* Each result consists of header and body. */
    for (int i = 0; i < LQ_CMD_NUM; i++) {
        struct lq_detect_buffer ldb = lqdetect.buffer[i];
        /* header */
        fldarr[fldcnt].length = snprintf(hdrptr, hdrlen, "%s : %u\n", command_str[i], ldb.ntotal);
        fldarr[fldcnt].value = hdrptr;
        hdrptr += hdrlen;
        fldcnt++;
        /* body */
        if (ldb.ntotal != 0) {
            fldarr[fldcnt].length = ldb.offset;
            fldarr[fldcnt].value = ldb.data;
            fldcnt++;
        }
    }
    lqdetect.refcount++;
    pthread_mutex_unlock(&lqdetect.lock);
    *size = fldcnt;
    return fldarr;
}

void lqdetect_result_release(field_t *results)
{
    free(results);
    pthread_mutex_lock(&lqdetect.lock);
    lqdetect.refcount--;
    pthread_mutex_unlock(&lqdetect.lock);
}

static bool lqdetect_dupcheck(char *key, enum lq_detect_command cmd, struct lq_detect_argument *arg)
{
    int count = lqdetect.buffer[cmd].nsaved;

    switch (cmd) {
    case LQCMD_LOP_INSERT:
    case LQCMD_LOP_DELETE:
    case LQCMD_LOP_GET:
    case LQCMD_BOP_GBP:
    case LQCMD_BOP_GET:
    case LQCMD_BOP_COUNT:
    case LQCMD_BOP_DELETE:
        for (int ii = 0; ii < count; ii++) {
            if (strcmp(lqdetect.arg[cmd][ii].query, arg->query) == 0) {
                return true;
            }
        }
        break;
    case LQCMD_MOP_DELETE:
    case LQCMD_MOP_GET:
    case LQCMD_SOP_GET:
        for (int ii = 0; ii < count; ii++) {
            if (arg->count == 0) {
                uint32_t offset = lqdetect.buffer[cmd].keypos[ii];
                uint32_t cmplen = lqdetect.buffer[cmd].keylen[ii];
                if (cmplen == strlen(key) &&
                    memcmp(lqdetect.buffer[cmd].data+offset, key, cmplen) == 0) {
                    return true;
                }
            } else {
                if (strcmp(lqdetect.arg[cmd][ii].query, arg->query) == 0) {
                    return true;
                }
            }
        }
        break;
    }
    return false;
}

static void lqdetect_write(char client_ip[], char *key,
                           enum lq_detect_command cmd, struct lq_detect_argument *arg)
{
    struct   tm *ptm;
    struct   timeval val;
    struct   lq_detect_buffer *buffer = &lqdetect.buffer[cmd];
    uint32_t offset = buffer->offset;
    uint32_t nsaved = buffer->nsaved;
    char     *bufptr = buffer->data + buffer->offset;
    uint32_t nwrite;
    uint32_t length;

    gettimeofday(&val, NULL);
    ptm = localtime(&val.tv_sec);
    length = ((nsaved+1) * LQ_INPUT_SIZE) - offset - 1;

    snprintf(bufptr, length, "%02d:%02d:%02d.%06ld %s <%u> %s ",
        ptm->tm_hour, ptm->tm_min, ptm->tm_sec, (long)val.tv_usec, client_ip,
        arg->overhead, command_str[cmd]);

    nwrite = strlen(bufptr);
    buffer->keypos[nsaved] = offset + nwrite;
    buffer->keylen[nsaved] = strlen(key);
    length -= nwrite;
    bufptr += nwrite;

    snprintf(bufptr, length, "%s %s\n", key, arg->query);
    nwrite += strlen(bufptr);
    buffer->offset += nwrite;
    lqdetect.arg[cmd][nsaved] = *arg;
    buffer->nsaved += 1;
}

static bool lqdetect_save_cmd(char client_ip[], char* key,
                              enum lq_detect_command cmd, struct lq_detect_argument *arg)
{
    bool ret = true;

    assert(cmd >= LQCMD_SOP_GET && cmd <= LQCMD_BOP_GBP);
    pthread_mutex_lock(&lqdetect.lock);
    do {
        if (! lqdetect.on_detect) {
            ret = false;
            break;
        }

        lqdetect.buffer[cmd].ntotal++;
        if (lqdetect.buffer[cmd].nsaved >= LQ_SAVE_CNT) break;

        if (lqdetect_dupcheck(key, cmd, arg))
            break; /* duplication query */

        /* write to buffer */
        lqdetect_write(client_ip, key, cmd, arg);

        /* internal stop */
        if (lqdetect.buffer[cmd].nsaved >= LQ_SAVE_CNT) {
            lqdetect.overflow_cnt++;
            if (lqdetect.overflow_cnt >= LQ_CMD_NUM) {
                do_lqdetect_stop(LQ_OVERFLOW_STOP);
                ret = false;
            }
        }
    } while(0);
    pthread_mutex_unlock(&lqdetect.lock);

    return ret;
}

static int lqdetect_make_bkeystring(char *buffer, const bkey_range *bkrange, const eflag_filter *efilter) {
    char *bufptr = buffer;
    /* bkey */
    if (bkrange->from_nbkey > 0) { /* hexadecimal */
        memcpy(bufptr, "0x", 2); bufptr += 2;
        safe_hexatostr(bkrange->from_bkey, bkrange->from_nbkey, bufptr);
        bufptr += strlen(bufptr);
        if (bkrange->to_nbkey != BKEY_NULL) { /* range */
            memcpy(bufptr, "..0x", 4); bufptr += 4;
            safe_hexatostr(bkrange->to_bkey, bkrange->to_nbkey, bufptr);
            bufptr += strlen(bufptr);
        }
    } else { /* 64bit unsigned integer */
        const unsigned char* bkptr = bkrange->from_bkey;
        bufptr += sprintf(bufptr, "%"PRIu64"", *(uint64_t*)bkptr);
        if (bkrange->to_nbkey != BKEY_NULL) { /* range */
            bkptr = bkrange->to_bkey;
            bufptr += sprintf(bufptr, "..%"PRIu64"", *(uint64_t*)bkptr);
        }
    }
    /* efilter */
    if (efilter != NULL) {
        strcpy(bufptr, " efilter");
        bufptr += strlen(bufptr);
    }
    return (bufptr - buffer);
}

bool lqdetect_lop_insert(char *client_ip, char *key, int coll_index)
{
    uint32_t overhead = coll_index >= 0 ? coll_index+1 : -(coll_index);
    if (overhead >= lqdetect.stats.threshold) {
        struct lq_detect_argument argument;
        snprintf(argument.query, LQ_QUERY_SIZE, "%d", coll_index);
        argument.overhead = overhead;
        if (! lqdetect_save_cmd(client_ip, key, LQCMD_LOP_INSERT, &argument)) {
            return false;
        }
    }
    return true;
}

bool lqdetect_lop_delete(char *client_ip, char *key, uint32_t del_count,
                         int32_t from_index, int32_t to_index, const bool drop_if_empty)
{
    uint32_t overhead = del_count + (from_index >= 0 ? from_index+1 : -(from_index));
    if (overhead >= lqdetect.stats.threshold) {
        struct lq_detect_argument argument;
        snprintf(argument.query, LQ_QUERY_SIZE, "%d..%d%s", from_index, to_index,
                 drop_if_empty ? " drop" : "");
        argument.overhead = overhead;
        if (! lqdetect_save_cmd(client_ip, key, LQCMD_LOP_DELETE, &argument)) {
            return false;
        }
    }
    return true;
}

bool lqdetect_lop_get(char *client_ip, char *key, uint32_t elem_count,
                      int32_t from_index, int32_t to_index, const bool delete, const bool drop_if_empty)
{
    uint32_t overhead = elem_count + (from_index >= 0 ? from_index+1 : -(from_index));
    if (overhead >= lqdetect.stats.threshold) {
        struct lq_detect_argument argument;
        snprintf(argument.query, LQ_QUERY_SIZE, "%d..%d%s", from_index, to_index,
                 drop_if_empty ? " drop" : (delete ? " delete" : ""));
        argument.overhead = overhead;
        if (! lqdetect_save_cmd(client_ip, key, LQCMD_LOP_GET, &argument)) {
            return false;
        }
    }
    return true;
}

bool lqdetect_sop_get(char *client_ip, char *key, uint32_t elem_count,
                      uint32_t count, const bool delete, const bool drop_if_empty)
{
    if (elem_count >= lqdetect.stats.threshold) {
        struct lq_detect_argument argument;
        snprintf(argument.query, LQ_QUERY_SIZE, "%u%s", count,
                 drop_if_empty ? " drop" : (delete ? " delete" : ""));
        argument.overhead = elem_count;
        argument.count = count;
        if (! lqdetect_save_cmd(client_ip, key, LQCMD_SOP_GET, &argument)) {
            return false;
        }
    }
    return true;
}

bool lqdetect_mop_get(char *client_ip, char *key, uint32_t elem_count,
                      uint32_t coll_numkeys, const bool delete, const bool drop_if_empty)
{
    if (elem_count >= lqdetect.stats.threshold) {
        struct lq_detect_argument argument;
        snprintf(argument.query, LQ_QUERY_SIZE, "%u%s", coll_numkeys,
                 drop_if_empty ? " drop" : (delete ? " delete" : ""));
        argument.overhead = elem_count;
        argument.count = coll_numkeys;
        if (! lqdetect_save_cmd(client_ip, key, LQCMD_MOP_GET, &argument)) {
            return false;
        }
    }
    return true;
}

bool lqdetect_mop_delete(char *client_ip, char *key, uint32_t del_count,
                         uint32_t coll_numkeys, const bool drop_if_empty)
{
    if (del_count >= lqdetect.stats.threshold) {
        struct lq_detect_argument argument;
        snprintf(argument.query, LQ_QUERY_SIZE, "%u%s", coll_numkeys,
                 drop_if_empty ? " drop" : "");
        argument.overhead = del_count;
        argument.count = coll_numkeys;
        if (! lqdetect_save_cmd(client_ip, key, LQCMD_MOP_DELETE, &argument)) {
            return false;
        }
    }
    return true;
}

bool lqdetect_bop_gbp(char *client_ip, char *key, uint32_t elem_count,
                      uint32_t from_posi, uint32_t to_posi, ENGINE_BTREE_ORDER order)
{
    if (elem_count >= lqdetect.stats.threshold) {
        struct lq_detect_argument argument;
        snprintf(argument.query, LQ_QUERY_SIZE, "%u..%u %s", from_posi, to_posi,
                 order == BTREE_ORDER_ASC ? "asc" : "desc");
        argument.overhead = elem_count;
        if (! lqdetect_save_cmd(client_ip, key, LQCMD_BOP_GBP, &argument)) {
            return false;
        }
    }
    return true;
}

bool lqdetect_bop_get(char *client_ip, char *key, uint32_t access_count,
                      const bkey_range *bkrange, const eflag_filter *efilter,
                      uint32_t offset, uint32_t count, const bool delete, const bool drop_if_empty)
{
    if (access_count >= lqdetect.stats.threshold) {
        struct lq_detect_argument argument;
        int nwrite = lqdetect_make_bkeystring(argument.query, bkrange, efilter);
        snprintf(argument.query + nwrite, LQ_QUERY_SIZE - nwrite, " %u %u%s",
                 offset, count, drop_if_empty ? " drop" : (delete ? " delete" : ""));
        argument.overhead = access_count;
        if (! lqdetect_save_cmd(client_ip, key, LQCMD_BOP_GET, &argument)) {
            return false;
        }
    }
    return true;
}

bool lqdetect_bop_count(char *client_ip, char *key, uint32_t access_count,
                        const bkey_range *bkrange, const eflag_filter *efilter)
{
    if (access_count >= lqdetect.stats.threshold) {
        struct lq_detect_argument argument;
        lqdetect_make_bkeystring(argument.query, bkrange, efilter);
        argument.overhead = access_count;
        if (! lqdetect_save_cmd(client_ip, key, LQCMD_BOP_COUNT, &argument)) {
            return false;
        }
    }
    return true;
}

bool lqdetect_bop_delete(char *client_ip, char *key, uint32_t access_count,
                         const bkey_range *bkrange, const eflag_filter *efilter,
                         uint32_t count, const bool drop_if_empty)
{
    if (access_count >= lqdetect.stats.threshold) {
        struct lq_detect_argument argument;
        int nwrite = lqdetect_make_bkeystring(argument.query, bkrange, efilter);
        snprintf(argument.query + nwrite, LQ_QUERY_SIZE - nwrite, " %u%s",
                 count, drop_if_empty ? " drop" : "");
        argument.count = count;
        argument.overhead = access_count;
        if (! lqdetect_save_cmd(client_ip, key, LQCMD_BOP_DELETE, &argument)) {
            return false;
        }
    }
    return true;
}