56,678
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE `tb_tree` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
`t` INT(11) NOT NULL COMMENT 't',
`lt` INT(11) NOT NULL COMMENT 'latency',
`ts` BIGINT(13) NOT NULL COMMENT 'Millisecond timestamp',
`s` VARCHAR(255) NOT NULL COMMENT 's',
`lb` VARCHAR(255) NOT NULL COMMENT 'label name',
`rc` VARCHAR(255) NOT NULL COMMENT 'response code ',
`rm` VARCHAR(2550) NOT NULL COMMENT 'response message',
`tn` VARCHAR(255) NOT NULL COMMENT 'thread name',
`dt` VARCHAR(255) NOT NULL COMMENT 'Content-Type ',
`bc` INT(11) NOT NULL COMMENT 'receiveBytes',
`assertion_name` VARCHAR(255) NULL DEFAULT NULL COMMENT 'raname',
`assertion_failure` VARCHAR(255) NULL DEFAULT NULL COMMENT 'rafailure',
`assertion_failure_message` VARCHAR(255) NULL DEFAULT NULL COMMENT 'assertion message',
`ng` INT(11) NOT NULL COMMENT 'number of active thread in the thread group',
`na` INT(11) NOT NULL COMMENT 'number of active thread in the test case',
`tgname` VARCHAR(255) NULL DEFAULT NULL COMMENT 'thread group name',
`machine_ip` VARCHAR(255) NULL DEFAULT NULL COMMENT 'the agent ip',
`response_data` LONGTEXT NULL COMMENT 'responsedata',
`sent_bytes` INT(11) NULL DEFAULT NULL COMMENT 'sentBytes',
`num_threads` INT(10) NULL DEFAULT NULL,
`ramp_time` INT(10) NULL DEFAULT NULL,
`script_name` VARCHAR(250) NULL DEFAULT NULL,
`url` VARCHAR(250) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX `ts` (`ts`),
INDEX `t` (`t`),
INDEX `ts_lb` (`ts`, `lb`)
)
COMMENT='this is results of one test xml data'
COLLATE='utf8_general_ci'
ENGINE=InnoDB;
select avg(t),floor(ts/1000),lb
from tb_tree
where ts<>0
group by floor(ts),lb;