[
https://issues.apache.org/jira/browse/PHOENIX-1081?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
yang ming updated PHOENIX-1081:
-------------------------------
Description:
The concurrent of the system is not highly,but CPU usage often up to 100%.
I had stopped the system,but regionserver's CPU usage is still high.
what can case this problem?
table row count：6000 million
table ddl：
create table if not exists summary
(
videoid integer not null,
date date not null,
platform varchar not null,
device varchar not null,
systemgroup varchar not null,
system varchar not null,
vv bigint,
ts bigint,
up bigint,
down bigint,
comment bigint,
favori bigint,
favord bigint,
quote bigint,
reply bigint
constraint pk primary key (videoid, date,platform, device, systemgroup,system)
)salt_buckets = 30,versions=1,compression='snappy';
query 1：
select sum(vv) as sumvv,sum(comment) as sumcomment,sum(up) as sumup,sum(down)
as sumdown,sum(reply) as sumreply,count(*) as count from summary(reply bigint)
where videoid
in(137102991,151113895,171559204,171559439,171573932,171573932,171573932,171574082,171574082,171574164,171677219,171794335,171902734,172364368,172475141,172700554,172700554,172700554,172716705,172784258,172835778,173112067,173165316,173165316,173379601,173448315,173503961,173692664,173911358,174077089,174099017,174349633,174349877,174651474,174651474,174759297,174883566,174883566,174987670,174987670,175131298)
and date>=to_date('2013-09-01','yyyy-MM-dd') and
date<=to_date('2014-07-07','yyyy-MM-dd')
was:
The system is not highly concurrent access,but CPU usage often 100%.
I had stopped the system,but regionserver's CPU usage is still high.
what can case this problem?
table row count：6000 million
table ddl：
create table if not exists summary
(
videoid integer not null,
date date not null,
platform varchar not null,
device varchar not null,
systemgroup varchar not null,
system varchar not null,
vv bigint,
ts bigint,
up bigint,
down bigint,
comment bigint,
favori bigint,
favord bigint,
quote bigint,
reply bigint
constraint pk primary key (videoid, date,platform, device, systemgroup,system)
)salt_buckets = 30,versions=1,compression='snappy';
query 1：
select sum(vv) as sumvv,sum(comment) as sumcomment,sum(up) as sumup,sum(down)
as sumdown,sum(reply) as sumreply,count(*) as count from summary(reply bigint)
where videoid
in(137102991,151113895,171559204,171559439,171573932,171573932,171573932,171574082,171574082,171574164,171677219,171794335,171902734,172364368,172475141,172700554,172700554,172700554,172716705,172784258,172835778,173112067,173165316,173165316,173379601,173448315,173503961,173692664,173911358,174077089,174099017,174349633,174349877,174651474,174651474,174759297,174883566,174883566,174987670,174987670,175131298)
and date>=to_date('2013-09-01','yyyy-MM-dd') and
date<=to_date('2014-07-07','yyyy-MM-dd')
> With phoenix case CPU usage 100%
> --------------------------------
>
> Key: PHOENIX-1081
> URL: https://issues.apache.org/jira/browse/PHOENIX-1081
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 3.0.0
> Reporter: yang ming
> Priority: Critical
>
> The concurrent of the system is not highly,but CPU usage often up to 100%.
> I had stopped the system,but regionserver's CPU usage is still high.
> what can case this problem?
> table row count：6000 million
> table ddl：
> create table if not exists summary
> (
> videoid integer not null,
> date date not null,
> platform varchar not null,
> device varchar not null,
> systemgroup varchar not null,
> system varchar not null,
> vv bigint,
> ts bigint,
> up bigint,
> down bigint,
> comment bigint,
> favori bigint,
> favord bigint,
> quote bigint,
> reply bigint
> constraint pk primary key (videoid, date,platform, device, systemgroup,system)
> )salt_buckets = 30,versions=1,compression='snappy';
> query 1：
> select sum(vv) as sumvv,sum(comment) as sumcomment,sum(up) as sumup,sum(down)
> as sumdown,sum(reply) as sumreply,count(*) as count from summary(reply
> bigint) where videoid
> in(137102991,151113895,171559204,171559439,171573932,171573932,171573932,171574082,171574082,171574164,171677219,171794335,171902734,172364368,172475141,172700554,172700554,172700554,172716705,172784258,172835778,173112067,173165316,173165316,173379601,173448315,173503961,173692664,173911358,174077089,174099017,174349633,174349877,174651474,174651474,174759297,174883566,174883566,174987670,174987670,175131298)
> and date>=to_date('2013-09-01','yyyy-MM-dd') and
> date<=to_date('2014-07-07','yyyy-MM-dd')
--
This message was sent by Atlassian JIRA
(v6.2#6252)
