5 Replies Latest reply on Jun 7, 2007 4:01 AM by it2000

    Problems with site slow down

      We have Clearspace installed and after 2-3 days of usage it begins to slow down. We restart clearspace and it works fine for another few days. We have approx 45 users with 20 or so using it very frequently. Before restarting it, it get's to the point where it takes 45 seconds or more to load a 3-4 line wiki entry.

       

      What configuration information do you need to diagnose the problem?

        • Re: Problems with site slow down

          hi Drew,

           

          Can you post some of the system information here (or email me: aaron@jivesoftware.com). You can get all the meaty stuff by going here:

           

          Admin Console --> System --> Management --> System Information. 

           

          Also, can you please enable query logging via the admin console:

           

          Admin Console --> System --> Management --> Query Stats

           

          and then report back anything that's taking over 50ms.

           

          Cheers,

           

          AJ

            • Re: Problems with site slow down

              I changed the amount of memory that Tomcat can use from 64MB to 256MB (this morning) in an effort to make things better.

               

              I will get that information if the problem recurs.

               

               

              What would be wonderful is a guide to setting up Tomcat in a way that works well for clearspace, or a recommendation to use JBoss or something else (and a guide to setting that up in a way that works well for clearspace).

              • Re: Problems with site slow down

                Here's my configs

                 

                 

                Clearspace

                Clearspace 1.1.0

                Logged in as admin - Logout

                View Site

                 

                   1. Dashboard

                   2. System

                   3. Spaces

                   4. Blogs

                   5. People

                   6. Reporting

                   7. Real-Time

                 

                     

                • Management

                     

                • Settings

                 

                System Information

                System Info

                Jive Home:      /usr/local/clearspace

                Uptime:      1 day 6 hours 30 minutes 10 seconds

                Clearspace Version:      1.1.0

                JVM Version and Vendor:      1.5.0_04 Sun Microsystems Inc.

                Application server:      Apache Tomcat/5.5.23

                Operating System:      Linux

                Hardware:      i386

                Country database version:      GeoIP Country Edition 01/2007    (Update Country Database)

                User Manager:      com.jivesoftware.base.database.DbUserManager (Default)

                Group Manager:      com.jivesoftware.base.database.DbGroupManager (Default)

                Auth Manager:      com.jivesoftware.base.database.DbAuthFactory (Default)

                 

                Datasource Info

                Database Name and Version:      MySQL 5.0.22-standard-log

                JDBC Driver and Version:      MySQL-AB JDBC Driver mysql-connector-java-5.0.5 ( $Date: 2007-03-01 00:01:06 +0100 (Thu, 01 Mar 2007) $, $Revision: 6329 $ )

                Subqueries supported:      Yes

                Transactions supported:      No

                Connection Pool:      Default Clearspace Connection Pool

                Min DB Connections:      5      

                Max DB Connections:      15

                DB Connections Open:      5

                Active DB Connections:      1

                DB User:      clearspace

                DB Password      Hidden

                Connection URL:      jdbc:mysql://mysql.easystreet.com:3306/clearspace

                Connection Timeout (days):      1.0

                 

                Java System Properties - hidden by default, click to show

                catalina.base      /usr/local/tomcat

                catalina.home      /usr/local/tomcat

                catalina.useNaming      true

                common.loader      ${catalina.home}/common/classes, ${catalina.home}/common/i18n/.jar, ${catalina.home}/common/endorsed/.jar, ${catalina.home}/common/lib/*.jar

                file.encoding      UTF-8

                file.encoding.pkg      sun.io

                file.separator      /

                httpclient.useragent      Clearspace Admin Console: v1.1.0

                java.awt.graphicsenv      sun.awt.X11GraphicsEnvironment

                java.awt.headless      true

                java.awt.printerjob      sun.print.PSPrinterJob

                java.class.path      : /usr/local/tomcat/bin/bootstrap.jar: /usr/local/tomcat/bin/commons-logging-api.jar

                java.class.version      49.0

                java.endorsed.dirs      /usr/local/tomcat/common/endorsed

                java.ext.dirs      /usr/local/jdk1.5.0_04/jre/lib/ext

                java.home      /usr/local/jdk1.5.0_04/jre

                java.io.tmpdir      /usr/local/tomcat/temp

                java.library.path      /usr/local/jdk1.5.0_04/jre/lib/i386/server: /usr/local/jdk1.5.0_04/jre/lib/i386: /usr/local/jdk1.5.0_04/jre/../lib/i386

                java.naming.factory.initial      org.apache.naming.java.javaURLContextFactory

                java.naming.factory.url.pkgs      org.apache.naming

                java.runtime.name      Java(TM) 2 Runtime Environment, Standard Edition

                java.runtime.version      1.5.0_04-b05

                java.specification.name      Java Platform API Specification

                java.specification.vendor      Sun Microsystems Inc.

                java.specification.version      1.5

                java.util.logging.config.file      /usr/local/tomcat/conf/logging.properties

                java.util.logging.manager      org.apache.juli.ClassLoaderLogManager

                java.vendor      Sun Microsystems Inc.

                java.vendor.url      http: //java.sun.com/

                java.vendor.url.bug      http: //java.sun.com/cgi-bin/bugreport.cgi

                java.version      1.5.0_04

                java.vm.info      mixed mode

                java.vm.name      Java HotSpot(TM) Server VM

                java.vm.specification.name      Java Virtual Machine Specification

                java.vm.specification.vendor      Sun Microsystems Inc.

                java.vm.specification.version      1.0

                java.vm.vendor      Sun Microsystems Inc.

                java.vm.version      1.5.0_04-b05

                line.separator      \n

                os.arch      i386

                os.name      Linux

                os.version      2.6.9-42.0.10.ELsmp

                package.access      sun., org.apache.catalina., org.apache.coyote., org.apache.tomcat., org.apache.jasper., sun.beans.

                package.definition      sun., java., org.apache.catalina., org.apache.coyote., org.apache.tomcat., org.apache.jasper.

                path.separator      :

                rome.fetcher.version      0.9

                server.loader      ${catalina.home}/server/classes, ${catalina.home}/server/lib/*.jar

                shared.loader      ${catalina.base}/shared/classes, ${catalina.base}/shared/lib/*.jar

                sun.arch.data.model      32

                sun.boot.class.path      /usr/local/jdk1.5.0_04/jre/lib/rt.jar: /usr/local/jdk1.5.0_04/jre/lib/i18n.jar: /usr/local/jdk1.5.0_04/jre/lib/sunrsasign.jar: /usr/local/jdk1.5.0_04/jre/lib/jsse.jar: /usr/local/jdk1.5.0_04/jre/lib/jce.jar: /usr/local/jdk1.5.0_04/jre/lib/charsets.jar: /usr/local/jdk1.5.0_04/jre/classes

                sun.boot.library.path      /usr/local/jdk1.5.0_04/jre/lib/i386

                sun.cpu.endian      little

                sun.cpu.isalist      

                sun.io.unicode.encoding      UnicodeLittle

                sun.jnu.encoding      UTF-8

                sun.management.compiler      HotSpot Server Compiler

                sun.os.patch.level      unknown

                tomcat.util.buf.StringCache.byte.enabled      true

                user.country      US

                user.dir      /home/tomcat

                user.home      /home/tomcat

                user.language      en

                user.name      tomcat

                user.timezone      US/Pacific

                xwork.saxParserFactory      org.apache.xerces.jaxp.SAXParserFactoryImpl

                xwork.saxTransformerFactory      org.apache.xalan.processor.TransformerFactoryImpl

                 

                 

                     

                • System Information

                     

                • License Information

                     

                • System Properties

                     

                • Locale

                     

                • Log Viewer

                     

                • Query Stats

                     

                • Scheduled Tasks

                 

                Dashboard | System | Spaces | Blogs | People | Reporting | Real-Time

                © Jive Software

                  • Re: Problems with site slow down

                    Hi drewd -

                    LG is right - printing GC details will tell you definitively if you're spending a lot of time in gc, and resizing the perm gen can help a lot. Increasing the max heap was good - 64MB won't be enough.

                    For single processor boxes, setting the -Xincgc flag can help with gc pauses. For multiple processor boxes, setting -XX:UseParNewGC and -XX:UseConcMarkSweepGC instead of -Xincgc can help even more.

                    Additionally, some vm's can autodetect when to run in server mode, but I always set the -server flag anyway. I'm old fashioned like that.

                    If it seems like this is a lot of weird flags to set just to get a vm to run well, it's because  you really do need to set a lot of weird flags just to get a vm to run well. I'll file an issue to get some recommended settings for clearspace posted somewhere.

                     

                    Having said all that, if printing GC details tells you that is not the problem, let us know and we'll take it from there.

                • Re: Problems with site slow down
                  it2000

                  Hi,

                   

                  you should at least set "-XX:+PrintGCDetails" as a JVM parameter for Tomcat. The 'GC' information is very useful if you encounter performance problems. It will be logged to STDout/err or to a file if you specify one.

                   

                  http://wiki.igniterealtime.org/display/WILDFIRE/JVMSettingsand+Debugging discusses some more JVM parameters for Openfire and how to obtain a stack trace.

                   

                  For me it sounds a lot like very much "Full GC"s are running and thus the page takes long to load. If this happens again try to set also "-XX:MaxPermSize=96m".

                   

                  LG