Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save vincentbernat/7354644 to your computer and use it in GitHub Desktop.
Save vincentbernat/7354644 to your computer and use it in GitHub Desktop.
Non default Pinba SQL tables
CREATE TABLE IF NOT EXISTS `tag_info_counter` (
`tag_value` varchar(32) DEFAULT NULL,
`req_count` int(11) DEFAULT NULL,
`req_per_sec` float DEFAULT NULL,
`hit_count` int(11) DEFAULT NULL,
`hit_per_sec` float DEFAULT NULL,
`timer_value` float DEFAULT NULL
) ENGINE=PINBA COMMENT='tag_info:counter';
CREATE TABLE IF NOT EXISTS `tag_info_group` (
`tag_value` varchar(32) DEFAULT NULL,
`req_count` int(11) DEFAULT NULL,
`req_per_sec` float DEFAULT NULL,
`hit_count` int(11) DEFAULT NULL,
`hit_per_sec` float DEFAULT NULL,
`timer_value` float DEFAULT NULL
) ENGINE=PINBA COMMENT='tag_info:group';
CREATE TABLE IF NOT EXISTS `tag_report_counter` (
`script_name` varchar(128) DEFAULT NULL,
`tag_value` varchar(64) DEFAULT NULL,
`req_count` int(11) DEFAULT NULL,
`req_per_sec` float DEFAULT NULL,
`hit_count` int(11) DEFAULT NULL,
`hit_per_sec` float DEFAULT NULL,
`timer_value` float DEFAULT NULL
) ENGINE=PINBA COMMENT='tag_report:counter';
CREATE TABLE IF NOT EXISTS `tag_report_group` (
`script_name` varchar(128) DEFAULT NULL,
`tag_value` varchar(32) DEFAULT NULL,
`req_count` int(11) DEFAULT NULL,
`req_per_sec` float DEFAULT NULL,
`hit_count` int(11) DEFAULT NULL,
`hit_per_sec` float DEFAULT NULL,
`timer_value` float DEFAULT NULL
) ENGINE=PINBA COMMENT='tag_report:group';
CREATE TABLE `tag_report_group_method` (
`script_name` varchar(128) DEFAULT NULL,
`group_value` varchar(32) DEFAULT NULL,
`method_value` varchar(32) DEFAULT NULL,
`req_count` int(11) DEFAULT NULL,
`req_per_sec` float DEFAULT NULL,
`hit_count` int(11) DEFAULT NULL,
`hit_per_sec` float DEFAULT NULL,
`timer_value` float DEFAULT NULL
) ENGINE=PINBA COMMENT='tag2_report:group,method';
CREATE TABLE `tag_report_group_apimethod` (
`script_name` varchar(128) DEFAULT NULL,
`group_value` varchar(32) DEFAULT NULL,
`method_value` varchar(32) DEFAULT NULL,
`req_count` int(11) DEFAULT NULL,
`req_per_sec` float DEFAULT NULL,
`hit_count` int(11) DEFAULT NULL,
`hit_per_sec` float DEFAULT NULL,
`timer_value` float DEFAULT NULL
) ENGINE=PINBA COMMENT='tag2_report:group,apimethod';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment