+1 (Experience the same) -----Original Message----- From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf Of Yang Li Sent: Friday, November 04, 2011 08:56 AM To: XWiki Users Subject: [xwiki-users] Activity performance is slow Hi all, I have XE3.2 installed on an Win2003 Server within an intranet (Tomcat+MySQL, both latest versions), the hardware is good and enough memory for the jvm. However, I found pages with activity (like the dashboard and user profile pages) are very slow to load, usually 6-10 seconds, whereas the other pages can be lowed with 2 seconds (satisfied). Little has been found when I searched the Internet inlcluding the mailing list archive. Is it normal or abnormal? Are there any profiling tools to identify the time-consuming part? Any suggestions are welcome! _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

于 2011/11/4 19:18, Edo Beutler 写道: Hi slow query log has nothing.... But the general query log shows that there are a large number of queries when I tried to load the user profile page (only once), as follows: ------------------------------**------------------------------** ------------ ikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=695792571 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_**LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_**UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_**AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_**TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_**SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=409221033 4 Query select xwikiattac0_.XWA_ID as XWA1_6_, xwikiattac0_.XWA_DOC_ID as XWA2_6_, xwikiattac0_.XWA_FILENAME as XWA3_6_, xwikiattac0_.XWA_SIZE as XWA4_6_, xwikiattac0_.XWA_DATE as XWA5_6_, xwikiattac0_.XWA_AUTHOR as XWA6_6_, xwikiattac0_.XWA_VERSION as XWA7_6_, xwikiattac0_.XWA_COMMENT as XWA8_6_ from xwikiattachment xwikiattac0_ where xwikiattac0_.XWA_DOC_ID=**409221033 4 Query select baseobject0_.XWO_ID as XWO1_19_, baseobject0_.XWO_NUMBER as XWO2_19_, baseobject0_.XWO_NAME as XWO3_19_, baseobject0_.XWO_CLASSNAME as XWO4_19_, baseobject0_.XWO_GUID as XWO5_19_ from xwikiobjects baseobject0_ where baseobject0_.XWO_NAME='项 目：GPS项目.常规组会：Kalman滤波入门' order by baseobject0_.XWO_NUMBER 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-797339379 4 Query select dbstringli0_.XWL_ID as XWP1_9_0_, dbstringli0_.XWL_NAME as XWP2_9_0_, dbstringli0_1_.XWP_CLASSTYPE as XWP3_9_0_ from xwikilists dbstringli0_ inner join xwikiproperties dbstringli0_1_ on dbstringli0_.XWL_ID=**dbstringli0_1_.XWP_ID and dbstringli0_.XWL_NAME=**dbstringli0_1_.XWP_NAME where dbstringli0_.XWL_ID=-797339379 and dbstringli0_.XWL_NAME='tags' 4 Query select list0_.XWL_ID as XWL1_9_0_, list0_.XWL_NAME as XWL2_9_0_, list0_.XWL_VALUE as XWL3_0_, list0_.XWL_NUMBER as XWL4_0_ from xwikilistitems list0_ where list0_.XWL_ID=-797339379 and list0_.XWL_NAME='tags' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=428854445 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=**stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=**stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=428854445 and stringprop0_.XWS_NAME='author' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=**largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=**largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=428854445 and largestrin0_.XWL_NAME='**comment' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=**dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=**dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=428854445 and dateproper0_.XWS_NAME='date' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=**integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=**integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=428854445 and integerpro0_.XWI_NAME='**replyto' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-187735777 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=**stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=**stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=-187735777 and stringprop0_.XWS_NAME='author' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=**largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=**largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=-187735777 and largestrin0_.XWL_NAME='** comment' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=**dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=**dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=-187735777 and dateproper0_.XWS_NAME='date' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=**integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=**integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=-187735777 and integerpro0_.XWI_NAME='** replyto' 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_**LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_**UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_**AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_**TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_**SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=239404830 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_**LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_**UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_**AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_**TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_**SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=-230703309 4 Query select xwikiattac0_.XWA_ID as XWA1_6_, xwikiattac0_.XWA_DOC_ID as XWA2_6_, xwikiattac0_.XWA_FILENAME as XWA3_6_, xwikiattac0_.XWA_SIZE as XWA4_6_, xwikiattac0_.XWA_DATE as XWA5_6_, xwikiattac0_.XWA_AUTHOR as XWA6_6_, xwikiattac0_.XWA_VERSION as XWA7_6_, xwikiattac0_.XWA_COMMENT as XWA8_6_ from xwikiattachment xwikiattac0_ where xwikiattac0_.XWA_DOC_ID=-**230703309 4 Query select baseobject0_.XWO_ID as XWO1_19_, baseobject0_.XWO_NUMBER as XWO2_19_, baseobject0_.XWO_NAME as XWO3_19_, baseobject0_.XWO_CLASSNAME as XWO4_19_, baseobject0_.XWO_GUID as XWO5_19_ from xwikiobjects baseobject0_ where baseobject0_.XWO_NAME='科 研：讨论班和学术报告.讨论班：**基于添加短环设计有限长LDPC码' order by baseobject0_.XWO_NUMBER 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-194765033 4 Query select dbstringli0_.XWL_ID as XWP1_9_0_, dbstringli0_.XWL_NAME as XWP2_9_0_, dbstringli0_1_.XWP_CLASSTYPE as XWP3_9_0_ from xwikilists dbstringli0_ inner join xwikiproperties dbstringli0_1_ on dbstringli0_.XWL_ID=**dbstringli0_1_.XWP_ID and dbstringli0_.XWL_NAME=**dbstringli0_1_.XWP_NAME where dbstringli0_.XWL_ID=-194765033 and dbstringli0_.XWL_NAME='tags' 4 Query select list0_.XWL_ID as XWL1_9_0_, list0_.XWL_NAME as XWL2_9_0_, list0_.XWL_VALUE as XWL3_0_, list0_.XWL_NUMBER as XWL4_0_ from xwikilistitems list0_ where list0_.XWL_ID=-194765033 and list0_.XWL_NAME='tags' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=958297315 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=**stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=**stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=958297315 and stringprop0_.XWS_NAME='author' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=**largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=**largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=958297315 and largestrin0_.XWL_NAME='**comment' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=**dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=**dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=958297315 and dateproper0_.XWS_NAME='date' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=**integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=**integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=958297315 and integerpro0_.XWI_NAME='**replyto' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=1800721365 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=**stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=**stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=1800721365 and stringprop0_.XWS_NAME='author' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=**largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=**largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=1800721365 and largestrin0_.XWL_NAME='** comment' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=**dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=**dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=1800721365 and dateproper0_.XWS_NAME='date' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=**integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=**integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=1800721365 and integerpro0_.XWI_NAME='** replyto' 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_**LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_**UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_**AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_**TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_**SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=2100328150 4 Query select xwikiattac0_.XWA_ID as XWA1_6_, xwikiattac0_.XWA_DOC_ID as XWA2_6_, xwikiattac0_.XWA_FILENAME as XWA3_6_, xwikiattac0_.XWA_SIZE as XWA4_6_, xwikiattac0_.XWA_DATE as XWA5_6_, xwikiattac0_.XWA_AUTHOR as XWA6_6_, xwikiattac0_.XWA_VERSION as XWA7_6_, xwikiattac0_.XWA_COMMENT as XWA8_6_ from xwikiattachment xwikiattac0_ where xwikiattac0_.XWA_DOC_ID=**2100328150 4 Query select baseobject0_.XWO_ID as XWO1_19_, baseobject0_.XWO_NUMBER as XWO2_19_, baseobject0_.XWO_NAME as XWO3_19_, baseobject0_.XWO_CLASSNAME as XWO4_19_, baseobject0_.XWO_GUID as XWO5_19_ from xwikiobjects baseobject0_ where baseobject0_.XWO_NAME='Blog.**信院首届研究生“让运动成为习惯，让生活更加精 彩”校园定向' order by baseobject0_.XWO_NUMBER 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_**LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_**UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_**AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_**TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_**SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=-**1017299478 4 Query select baseobject0_.XWO_ID as XWO1_19_, baseobject0_.XWO_NUMBER as XWO2_19_, baseobject0_.XWO_NAME as XWO3_19_, baseobject0_.XWO_CLASSNAME as XWO4_19_, baseobject0_.XWO_GUID as XWO5_19_ from xwikiobjects baseobject0_ where baseobject0_.XWO_NAME='Blog.**BlogPostClass' order by baseobject0_.XWO_NUMBER 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-**1789160402 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=**stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=**stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=-**1789160402 and stringprop0_.XWS_NAME='sheet' 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_**LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_**UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_**AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_**TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_**SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=-564295929 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-**1399729039 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=**stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=**stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=-**1399729039 and stringprop0_.XWS_NAME='sheet' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-905319616 4 Query select dbstringli0_.XWL_ID as XWP1_9_0_, dbstringli0_.XWL_NAME as XWP2_9_0_, dbstringli0_1_.XWP_CLASSTYPE as XWP3_9_0_ from xwikilists dbstringli0_ inner join xwikiproperties dbstringli0_1_ on dbstringli0_.XWL_ID=**dbstringli0_1_.XWP_ID and dbstringli0_.XWL_NAME=**dbstringli0_1_.XWP_NAME where dbstringli0_.XWL_ID=-905319616 and dbstringli0_.XWL_NAME='**category' 4 Query select list0_.XWL_ID as XWL1_9_0_, list0_.XWL_NAME as XWL2_9_0_, list0_.XWL_VALUE as XWL3_0_, list0_.XWL_NUMBER as XWL4_0_ from xwikilistitems list0_ where list0_.XWL_ID=-905319616 and list0_.XWL_NAME='category' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=**largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=**largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=-905319616 and largestrin0_.XWL_NAME='** content' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=**largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=**largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=-905319616 and largestrin0_.XWL_NAME='** extract' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=**integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=**integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=-905319616 and integerpro0_.XWI_NAME='hidden' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=**dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=**dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=-905319616 and dateproper0_.XWS_NAME='** publishDate' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=**integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=**integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=-905319616 and integerpro0_.XWI_NAME='** published' 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=**stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=**stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=-905319616 and stringprop0_.XWS_NAME='title' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-**1804084128 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=**stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=**stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=-**1804084128 and stringprop0_.XWS_NAME='author' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=**largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=**largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=-**1804084128 and largestrin0_.XWL_NAME='** comment' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=**dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=**dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=-**1804084128 and dateproper0_.XWS_NAME='date' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=**integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=**integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=-**1804084128 and integerpro0_.XWI_NAME='** replyto' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-**1426244230 4 Query select dbstringli0_.XWL_ID as XWP1_9_0_, dbstringli0_.XWL_NAME as XWP2_9_0_, dbstringli0_1_.XWP_CLASSTYPE as XWP3_9_0_ from xwikilists dbstringli0_ inner join xwikiproperties dbstringli0_1_ on dbstringli0_.XWL_ID=**dbstringli0_1_.XWP_ID and dbstringli0_.XWL_NAME=**dbstringli0_1_.XWP_NAME where dbstringli0_.XWL_ID=-**1426244230 and dbstringli0_.XWL_NAME='tags' 4 Query select list0_.XWL_ID as XWL1_9_0_, list0_.XWL_NAME as XWL2_9_0_, list0_.XWL_VALUE as XWL3_0_, list0_.XWL_NUMBER as XWL4_0_ from xwikilistitems list0_ where list0_.XWL_ID=-1426244230 and list0_.XWL_NAME='tags' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=1441943570 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=**stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=**stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=1441943570 and stringprop0_.XWS_NAME='author' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=**largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=**largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=1441943570 and largestrin0_.XWL_NAME='** comment' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=**dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=**dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=1441943570 and dateproper0_.XWS_NAME='date' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=**integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=**integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=1441943570 and integerpro0_.XWI_NAME='** replyto' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=1441943571 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=**stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=**stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=1441943571 and stringprop0_.XWS_NAME='author' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=**largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=**largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=1441943571 and largestrin0_.XWL_NAME='** comment' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=**dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=**dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=1441943571 and dateproper0_.XWS_NAME='date' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=**integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=**integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=1441943571 and integerpro0_.XWI_NAME='** replyto' 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_**LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_**UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_**AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_**TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_**SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=-221079827 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_**LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_**UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_**AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_**TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_**SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=-754891244 4 Query select xwikiattac0_.XWA_ID as XWA1_6_, xwikiattac0_.XWA_DOC_ID as XWA2_6_, xwikiattac0_.XWA_FILENAME as XWA3_6_, xwikiattac0_.XWA_SIZE as XWA4_6_, xwikiattac0_.XWA_DATE as XWA5_6_, xwikiattac0_.XWA_AUTHOR as XWA6_6_, xwikiattac0_.XWA_VERSION as XWA7_6_, xwikiattac0_.XWA_COMMENT as XWA8_6_ from xwikiattachment xwikiattac0_ where xwikiattac0_.XWA_DOC_ID=-**754891244 4 Query select baseobject0_.XWO_ID as XWO1_19_, baseobject0_.XWO_NUMBER as XWO2_19_, baseobject0_.XWO_NAME as XWO3_19_, baseobject0_.XWO_CLASSNAME as XWO4_19_, baseobject0_.XWO_GUID as XWO5_19_ from xwikiobjects baseobject0_ where baseobject0_.XWO_NAME='**Sandbox.测试页面2' order by baseobject0_.XWO_NUMBER 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_**LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_**UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_**AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_**TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_**SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=-304499542 4 Query select baseobject0_.XWO_ID as XWO1_19_, baseobject0_.XWO_NUMBER as XWO2_19_, baseobject0_.XWO_NAME as XWO3_19_, baseobject0_.XWO_CLASSNAME as XWO4_19_, baseobject0_.XWO_GUID as XWO5_19_ from xwikiobjects baseobject0_ where baseobject0_.XWO_NAME='** Presentation.**PresentationClass' order by baseobject0_.XWO_NUMBER 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=409306478 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=**stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=**stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=409306478 and stringprop0_.XWS_NAME='sheet' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-**1844699202 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=**stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=**stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=-**1844699202 and stringprop0_.XWS_NAME='layout' 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=**stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=**stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=-**1844699202 and stringprop0_.XWS_NAME='theme' 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_**LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_**UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_**AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_**TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_**SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=-**1148819671 4 Query select xwikiattac0_.XWA_ID as XWA1_6_, xwikiattac0_.XWA_DOC_ID as XWA2_6_, xwikiattac0_.XWA_FILENAME as XWA3_6_, xwikiattac0_.XWA_SIZE as XWA4_6_, xwikiattac0_.XWA_DATE as XWA5_6_, xwikiattac0_.XWA_AUTHOR as XWA6_6_, xwikiattac0_.XWA_VERSION as XWA7_6_, xwikiattac0_.XWA_COMMENT as XWA8_6_ from xwikiattachment xwikiattac0_ where xwikiattac0_.XWA_DOC_ID=-**1148819671 4 Query select baseobject0_.XWO_ID as XWO1_19_, baseobject0_.XWO_NUMBER as XWO2_19_, baseobject0_.XWO_NAME as XWO3_19_, baseobject0_.XWO_CLASSNAME as XWO4_19_, baseobject0_.XWO_GUID as XWO5_19_ from xwikiobjects baseobject0_ where baseobject0_.XWO_NAME='科 研：讨论班和学术报告.PPT制作技巧' order by baseobject0_.XWO_NUMBER 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-**2041405299 4 Query select dbstringli0_.XWL_ID as XWP1_9_0_, dbstringli0_.XWL_NAME as XWP2_9_0_, dbstringli0_1_.XWP_CLASSTYPE as XWP3_9_0_ from xwikilists dbstringli0_ inner join xwikiproperties dbstringli0_1_ on dbstringli0_.XWL_ID=**dbstringli0_1_.XWP_ID and dbstringli0_.XWL_NAME=**dbstringli0_1_.XWP_NAME where dbstringli0_.XWL_ID=-**2041405299 and dbstringli0_.XWL_NAME='tags' 4 Query select list0_.XWL_ID as XWL1_9_0_, list0_.XWL_NAME as XWL2_9_0_, list0_.XWL_VALUE as XWL3_0_, list0_.XWL_NUMBER as XWL4_0_ from xwikilistitems list0_ where list0_.XWL_ID=-2041405299 and list0_.XWL_NAME='tags' 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_**LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_**UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_**AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_**TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_**SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=1201235099 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 ------------------------------**------------------------------** ------------ Not good at SQL, but it seems to me that each even involves almost 20 queries....and there are a lot of events out there... Is this all right? Hope this helps ______________________________**_________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/m…

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 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

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 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://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 :) Check" ______________________________**_________________ 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…

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

in the URL. This is the core activity stream time Yes, I found that, no sensable improvement of the performance in an

This won't do much. How fast is the activity page with ?xpage=contentview intranet. My profile page with ?xpage=contentview is loaded about 4 seconds. Much better than 10 or 20.... ______________________________****_________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/****mailman/listinfo/users<http://lists.xwiki .org/**mailman/listinfo/users> <http://**lists.xwiki.org/mailman/**listinfo/users<http://lists.xwik i.org/mailman/listinfo/users>

only remove part of it. You might have added data to additional tables and missing indexes show the problem. Using the Admin.Tools indexes in addition to the default ones my help. Ludovic

You probably should script deleting the feed documents. Otherwise you'll sanitycheck script and found there are some rows selected, which is not desirable. What I'm supposed to do? ______________________________****_________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/****mailman/listinfo/users<http://lists.xwiki.org… <http://**lists.xwiki.org/mailman/**listinfo/users<http://lists.xwiki.org/mailman/listinfo/users>

to explain because it really depends which one is showing up as wrong Ludovic I failed the following two queries:

于 2011/11/7 22:03, Ludovic Dubost 写道:

1 where tdoc.xwd_translation = 1 and doc.xwd_translation IS NULL;