• Home
• com.ning
• metrics.collector
• 2.0.9
• source code
• collector_counter_events.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.mysql.collector_counter_events.sql Maven / Gradle / Ivy

CREATE TABLE `metrics_buffer` (
  `id` BIGINT NOT NULL AUTO_INCREMENT,
  `namespace` VARCHAR(32) NOT NULL,
  `metrics` VARCHAR(1024) NOT NULL,
  `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  INDEX `metrics_buffer_namespace_idx` (`namespace`),
  INDEX `metrics_buffer_name_and_time_idx` (`namespace`, `timestamp`))
  ENGINE = INNODB;

CREATE TABLE `metrics_daily` (
  `namespace` VARCHAR(32) NOT NULL,
  `datestamp` DATE NOT NULL,
  `counter_name` varchar(64) NOT NULL,
  `total_count` BIGINT NOT NULL,
  `unique_count` INT NOT NULL,
  `distribution` MEDIUMBLOB NOT NULL,
  PRIMARY KEY (`namespace`, `datestamp`, `counter_name`),
  INDEX `metrics_daily_namespace_idx` (`namespace`),
  INDEX `metrics_daily_name_and_date_idx` (`namespace`, `datestamp`))
  ENGINE = INNODB;