I had the same issue (very slow activity stream), and last week-end it
suddenly became horribly slow (few minutes for the home page).
I added missing index, checked it was ok (request indicated from 2s to 0s),
increased the document store cache to 2000, but it's still horribly slow.
There are
I had the same issue (very slow activity stream), and last week-end it
suddenly became horribly slow (few minutes for the home page).
I added missing index, checked it was ok (request indicated from 2s to 0s),
increased the document store cache to 2000, but it's still horribly slow.
There are
I had the same issue (very slow activity stream), and last week-end it
suddenly became horribly slow (few minutes for the home page).
I added missing index, checked it was ok (request indicated from 2s to 0s),
increased the document store cache to 2000, but it's still horribly slow.
There are
于 2011/11/7 19:29, Edo Beutler 写道:
Hi
I know, the page cache was not the problem in this case, but since
Ludovic mentioned it I wanted to share our experiences on page cache.
Around spring / summer while migrating old servers to (fewer) new ones
we ran into performance problems. We found the
You might be missing indexes for the reader table, which could cause your
issues.
You'll find information about XWiki Feed Plugin indexes here:
http://extensions.xwiki.org/xwiki/bin/view/Extension/XWikiWatchSpeedup
Ludovic
2011/11/7 jerem jeremie.bousq...@gmail.com
I had the same issue (very
I created the missing indexes for Reader as indicated, but no real change.
I also noticed that though there are only 148 feed entries total, there are
4500 rows about Reader space in the activitystream_events table !
Seems that the home page of a feed source is updated and a major
version is set
于 2011/11/7 22:03, Ludovic Dubost 写道:
You probably should script deleting the feed documents. Otherwise you'll
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.
Well you would need to delete the unnecessary data. It's a bit complicated
to explain because it really depends which one is showing up as wrong
Ludovic
2011/11/7 Yang Li yang.lee.c...@gmail.com
于 2011/11/7 22:03, Ludovic Dubost 写道:
You probably should script deleting the feed documents.
于 2011/11/7 22:10, Ludovic Dubost 写道:
Well you would need to delete the unnecessary data. It's a bit complicated
to explain because it really depends which one is showing up as wrong
Ludovic
I failed the following two queries:
select Checking original documents that are marked translated AS
On my side, removing the Reader.* pages programmatically, and removing
all related entries in activitystream_events table, solved my issue. Home
page now shows up normally, and displays correct events in activity stream
:)
I think the Reader was generated too much entries too fast.
Thanks for
2011/11/7 Yang Li yang.lee.c...@gmail.com
于 2011/11/7 22:10, Ludovic Dubost 写道:
Well you would need to delete the unnecessary data. It's a bit complicated
to explain because it really depends which one is showing up as wrong
Ludovic
I failed the following two queries:
select Checking
As you are mentionning Chinese, if you have some time you should help
completing the chinese translations of XWiki
http://l10n.xwiki.org/xwiki/bin/view/XE/XWikiCoreResources?language=zh
http://l10n.xwiki.org/xwiki/bin/view/XE/XWikiCoreResources?language=zh_TW
Ludovic
2011/11/7 Yang Li
于 2011/11/7 22:41, Ludovic Dubost 写道:
2011/11/7 Yang Li yang.lee.c...@gmail.com
于 2011/11/7 22:10, Ludovic Dubost 写道:
Well you would need to delete the unnecessary data. It's a bit complicated
to explain because it really depends which one is showing up as wrong
Ludovic
I failed the
Sure. Actually, I found some incorrect translations in the latest stable
XE3.2.
于 2011/11/7 22:45, Ludovic Dubost 写道:
As you are mentionning Chinese, if you have some time you should help
completing the chinese translations of XWiki
still takes 24 seconds for admin account.
-Original Message-
From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf
Of Ludovic Dubost
Sent: Friday, November 04, 2011 23:14 PM
To: XWiki Users
Cc: users@xwiki.org
Subject: Re: [xwiki-users] Activity performance is slow
Cache
to Main.WebHome still takes 24 seconds for admin account.
-Original Message-
From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf
Of Ludovic Dubost
Sent: Friday, November 04, 2011 23:14 PM
To: XWiki Users
Cc: users@xwiki.org
Subject: Re: [xwiki-users] Activity performance
: users-boun...@xwiki.org
[mailto:users-bounces@xwiki.**orgusers-boun...@xwiki.org]
On Behalf
Of Ludovic Dubost
Sent: Friday, November 04, 2011 23:14 PM
To: XWiki Users
Cc: users@xwiki.org
Subject: Re: [xwiki-users] Activity performance is slow
Cache is enabled by default. It's not ehcache
: users@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/11/5 15:08, Ludovic Dubost 写道:
This won't do much. How fast is the activity page with ?xpage=contentview
in the URL. This is the core activity stream time
Yes, I found that, no sensable improvement of the performance in an
intranet.
My profile page with ?xpage=contentview is loaded
于 2011/11/5 15:24, Ludovic Dubost 写道:
So that means there would be additional time consumed by something else
than the activity stream.
Do you have anything special in the skin ? What does the speed look like
with ?skin=colibri in the URL
Ludovic
I use an round corner skin extension. Just a
Oh, it is so weird, after logout and login, the ?xpage=contentview load
time increased from 4 to 10
and almost another 2 seconds with the skin...
于 2011/11/5 15:24, Ludovic Dubost 写道:
So that means there would be additional time consumed by something else
than the activity stream.
Do you
You might be fooled by the caches. Depending on what other visitors visit
and the mysql query cache, the time to redraw the page might take more or
less.
I suggest you look at the mysql queries and you run them manually with the
NO CACHE setting to see if the volume of data creates the slowness
-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of
Ludovic Dubost
Sent: Saturday, November 05, 2011 10:09 AM
To: XWiki Users
Subject: Re: [xwiki-users] Activity performance is slow
You might be fooled by the caches. Depending on what other visitors visit and
the mysql query cache
Thanks a lot!
The initial indexes are
TABLE_NAMENON_UNIQUEINDEX_NAMESEQ_IN_INDEXCOLUMN_NAME
activitystream_events0PRIMARY1ase_eventid
activitystream_events1EVENT_TYPE1
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
+1 (Experience the same)
-Original Message-
From: users-boun...@xwiki.org [mailto:users-boun...@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
[mailto:users-boun...@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
[mailto:users-boun...@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
-boun...@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
Hi,
This is really weird. Do you get this log of queries also when you reload
the page after a first load.
Because just the first query should not show up again a second time:
11 Query select xwikidocum0_.XWD_ID as XWD1_0_0_,
xwikidocum0_.XWD_FULLNAME as XWD2_0_0_,
I removed all the pannels, and tried to load a simple page serveral
times, but every time there are many queries
2011/11/5, Ludovic Dubost ludo...@xwiki.com:
Hi,
This is really weird. Do you get this log of queries also when you reload
the page after a first load.
Because just the
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
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 rmunt...@softserveinc.com a écrit :
Ludovic,
for admin account.
-Original Message-
From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of
Ludovic Dubost
Sent: Friday, November 04, 2011 23:14 PM
To: XWiki Users
Cc: users@xwiki.org
Subject: Re: [xwiki-users] Activity performance is slow
Cache is enabled by default
-
From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf
Of Ludovic Dubost
Sent: Friday, November 04, 2011 23:14 PM
To: XWiki Users
Cc: users@xwiki.org
Subject: Re: [xwiki-users] Activity performance is slow
Cache is enabled by default. It's not ehcache but JBoss cache
35 matches
Mail list logo