5 Nov
2011
5 Nov
'11
8:15 a.m.
于 2011/11/5 15:07, Ludovic Dubost 写道:
It is normal that there should be some queries for the
activity macro. The
results are real time.
The caching is for reading detailed document information. It's surprising
that you are getting queries for a normal view of a page particularly with
all panels removed.
What queries do you get in the mysql log on the activity stream with
?xpage=contentview
Ludovic
The logs in the mysql on the activity stream with ?xpage=contentview are
------------------------------------------------------------------------
111105 15:13:06 5 Query select parameters0_.eventId as
eventId32_0_, parameters0_.value as value0_, parameters0_.name as name0_
from activitystream_events_params parameters0_ where
parameters0_.eventId='734931887-1320309892000-gNirKOgu'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='55616298-1320309892000-18xovYho'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='55616298-1320309892000-18xovYho' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='734931887-1320309892000-gNirKOgu'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='55616298-1320309892000-18xovYho'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='55616298-1320309892000-18xovYho' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='734931887-1320309892000-gNirKOgu'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='55616298-1320309892000-18xovYho'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where activityev0_.ase_page='科研：讨
论班和学术报告.讨论班：异常值稀疏约束的动态系统双鲁棒平滑' and
activityev0_.ase_space<>'Scheduler' and 1=1 and
(activityev0_.ase_application='MessageStream' and
activityev0_.ase_type='directMessage' and
activityev0_.ase_param2='xwiki:XWiki.yangli^XWiki.XWikiUsers' or
activityev0_.ase_user in ('XWiki.yangli' , 'xwiki:XWiki.yangli')) and
(activityev0_.ase_wiki in ('xwiki')) and (activityev0_.ase_version like
'%.1' or activityev0_.ase_type<>'update') and
(activityev0_.ase_application<>'MessageStream' or
activityev0_.ase_application='MessageStream' and
(activityev0_.ase_type='publicMessage' or
activityev0_.ase_user='xwiki:XWiki.yangli' or
activityev0_.ase_type='directMessage' and
activityev0_.ase_param2='xwiki:XWiki.yangli^XWiki.XWikiUsers' or
activityev0_.ase_type='personalMessage' and (activityev0_.ase_user in
('xwiki:XWiki.jianjunyin' , 'xwiki:XWiki.DanickZhu' ,
'xwiki:XWiki.Essen' , 'xwiki:XWiki.Admin' ,
'xwiki:XWiki.solohorse' ,
'xwiki:XWiki.WangYouhua' , 'xwiki:XWiki.yangleecool' ,
'xwiki:XWiki.yueli' , 'xwiki:XWiki.streamxt' ,
'xwiki:XWiki.glygly' ,
'xwiki:XWiki.anywho' , 'xwiki:XWiki.xuxinlong' ,
'xwiki:XWiki.Rainbow' ,
'xwiki:XWiki.egg' , 'xwiki:XWiki.Zacry' , 'xwiki:XWiki.sicia')) or
activityev0_.ase_type='groupMessage' and (activityev0_.ase_param2 in
('xwiki:XWiki.ResearchSeminars^XWiki.XWikiGroups' ,
'xwiki:XWiki.GPSProject^XWiki.XWikiGroups' ,
'xwiki:XWiki.XWikiAllGroup^XWiki.XWikiGroups' ,
'xwiki:XWiki.ArrayProcessing^XWiki.XWikiGroups' ,
'xwiki:XWiki.LivingRecreation^XWiki.XWikiGroups' ,
'xwiki:XWiki.EMIMembers^XWiki.XWikiGroups' ,
'xwiki:XWiki.CoursesGradUndergrad^XWiki.XWikiGroups')))) and
day(activityev0_.ase_date)=3 and month(activityev0_.ase_date)=11 and
year(activityev0_.ase_date)=2011 order by activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1549011142-1320295738000-NTF5aHr7'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-rajqFj6C'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-NUCxYBP9'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-abQNXTuE'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-03jvUeLm'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295961000-WBXkyWmM'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='2062459027-1320295961000-WBXkyWmM' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295961000-WBXkyWmM'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='1472841318-1320295853000-abQNXTuE' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-rajqFj6C'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-NUCxYBP9'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-abQNXTuE'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-03jvUeLm'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='1472841318-1320295853000-abQNXTuE' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-rajqFj6C'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-NUCxYBP9'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-abQNXTuE'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-03jvUeLm'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='1472841318-1320295853000-abQNXTuE' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-rajqFj6C'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-NUCxYBP9'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-abQNXTuE'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-03jvUeLm'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='1472841318-1320295853000-abQNXTuE' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-rajqFj6C'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-NUCxYBP9'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-abQNXTuE'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-03jvUeLm'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='55616298-1320295738000-5xzd0YZr' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1549011142-1320295738000-NTF5aHr7'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='55616298-1320295738000-5xzd0YZr'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='2062459027-1320295961000-WBXkyWmM' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295961000-WBXkyWmM'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='2062459027-1320295961000-WBXkyWmM' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295961000-WBXkyWmM'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='1472841318-1320295853000-abQNXTuE' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-rajqFj6C'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-NUCxYBP9'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-abQNXTuE'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-03jvUeLm'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='1472841318-1320295853000-abQNXTuE' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-rajqFj6C'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-NUCxYBP9'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-abQNXTuE'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-03jvUeLm'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='55616298-1320295738000-5xzd0YZr' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1549011142-1320295738000-NTF5aHr7'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='55616298-1320295738000-5xzd0YZr'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='2062459027-1320295961000-WBXkyWmM' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295961000-WBXkyWmM'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='1472841318-1320295853000-abQNXTuE' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-rajqFj6C'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-NUCxYBP9'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-abQNXTuE'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-03jvUeLm'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='1472841318-1320295853000-abQNXTuE' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-rajqFj6C'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-NUCxYBP9'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-abQNXTuE'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-03jvUeLm'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='1472841318-1320295853000-abQNXTuE' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-rajqFj6C'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-NUCxYBP9'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-abQNXTuE'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-03jvUeLm'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='1472841318-1320295853000-abQNXTuE' order by
activityev0_.ase_date desc
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-rajqFj6C'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='2062459027-1320295853000-NUCxYBP9'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-abQNXTuE'
5 Query select parameters0_.eventId as eventId32_0_,
parameters0_.value as value0_, parameters0_.name as name0_ from
activitystream_events_params parameters0_ where
parameters0_.eventId='1472841318-1320295853000-03jvUeLm'
5 Query rollback
5 Query rollback
5 Query SET autocommit=1
5 Query SET autocommit=0
5 Query select activityev0_.ase_eventid as ase1_32_,
activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as
ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority
as ase5_32_, activityev0_.ase_type as ase6_32_,
activityev0_.ase_application as ase7_32_, activityev0_.ase_user as
ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as
ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_url as
ase12_32_, activityev0_.ase_title as ase13_32_, activityev0_.ase_body as
ase14_32_, activityev0_.ase_version as ase15_32_,
activityev0_.ase_param1 as ase16_32_, activityev0_.ase_param2 as
ase17_32_, activityev0_.ase_param3 as ase18_32_, activityev0_.ase_param4
as ase19_32_, activityev0_.ase_param5 as ase20_32_ from
activitystream_events activityev0_ where
activityev0_.ase_requestid='55616298-1320295738000-5xzd0YZr' order by
activityev0_.ase_date desc
2011/11/5 Yang Li<yang.lee.cool(a)gmail.com>
Wait!
I tried a simple page with ?xpage=contentview in the URL just now with no
more queries. However, when I tried my profile page with ?xpage=contentview
in the URL, there are still many mysql queries and took a long time! It
seems that the store.cache works for other pages without activity macro but
not pages with activity macro...
于 2011/11/5 13:56, Ludovic Dubost 写道:
I'm a bit confused. Is it the same install as
Yang Li or a different one ?
Are you seeing the queries in the mysql log when you reload a simple page
or a page with ?xpage=contentview in the URL ?
Ludovic
2011/11/4 Roman Muntyanu<rmuntyan@**softserveinc.com<rmuntyan@softserveinc.com>
Thanks. Example here
______________________________**_________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/m…
http://www.ow2.org/view/Admin/**CheckIndexes?viewer=code<http://www.ow2.…
places
requiring change (for those who might need it someday)
After updating the check index page it now says
* Indexes created for wiki xwiki_utf8_innodb
Request to Main.WebHome still takes 24 seconds for admin account.
-----Original Message-----
From: users-bounces(a)xwiki.org
[mailto:users-bounces@xwiki.**org<users-bounces@xwiki.org>]
On Behalf
Of Ludovic Dubost
Sent: Friday, November 04, 2011 23:14 PM
To: XWiki Users
Cc: users(a)xwiki.org
Subject: Re: [xwiki-users] Activity performance is slow
Cache is enabled by default. It's not ehcache but JBoss cache
This is probably because you don't have indexes. The Script has 3
occurrences ok 'xwiki' which you should change to your db name
Envoyé de mon iPhone
Le 4 nov. 2011 à 21:18,
coldserenity<rmuntyan@**softserveinc.com<rmuntyan@softserveinc.com>>
a écrit :
Ludovic, thanks for the handy tips, but ... I need some more :)
> I have installed the Admin Tool and it mentioned that indexes were not
> created.
> So before creating indexes I have decided to upgrade table engine from
> MyIsam to InnoDB as Sergiu has suggested in this post
> http://xwiki.475771.n2.nabble.**com/Upgrade-to-3-2-minor-**
>
issues-td688396<http://xwiki.475771.n2.nabble.com/Upgrade-to-3-2-minor-i…
> 5.html After the change the overall time to load main XWiki page as
> administrator has gone from 5 to 25 seconds. My wiki currently is 1100
> documents in count and 400M in size.
>
> Quick questions:
> * is caching enabled by default?
> * is caching limiting done simply by document count or by allocated
> memory (as most recent EHCache allows)?
>
> After the upgrade, I receive following error on "XWiki Database
> Indexes Check" page
> * Failed to check indexes for wiki xwiki: Table
> 'xwiki.xwikiattrecyclebin' doesn't exist I think this is related to
> fact that my database name is "xwiki_utf8_innodb"
> and not "xwiki", because I receive similar results on "MySQL Encoding
>
Check"
> page
> * Failed to check xwikidoc encoding for wiki xwiki: Unknown database
> 'xwiki'
> * Failed to check xwikidoc encoding or collation for wiki xwiki:
> Table 'xwiki.xwikidoc' doesn't exist but I don't know where to change
> that parameter to proper value - velocity scripts are overcrowded with
> 'xwiki' strings.
>
>
>
> --
> View this message in context:
> http://xwiki.475771.n2.nabble.**com/Activity-performance-is-**
>
slow-tp69618<http://xwiki.475771.n2.nabble.com/Activity-performance-is-s…
> 05p6964056.html Sent from the XWiki- Users mailing list archive at
> Nabble.com.
> ______________________________**_________________
> users mailing list
> users(a)xwiki.org
>
http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/m…
>
______________________________**_________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/m…
______________________________**_________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/m…