that might explain what i'm seeing with my CPUs - they continued
being busy 18 hours after the indexing process completed. as i write, they're still plugging away.
my upgrade was from 1.4 to 2.1 , the indexing took 5 hours for 441,000+ records. the upgrade is in the DEV environment and i am going to leave it to run. at some point, we will have to upgrade the production version. is there any way of speeding thing up ?
Regards,
See-See
———————————————————————————-
Database : Oracle 10g
OS : RedHat
JVM values : -Xms129m -Xmx1024m -server -XX:MaxPermSize=128m
———————————————————————————-
LOGS :
10:45:18,226 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started: 441,549 transactions.
11:09:01,439 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 20 % complete.
11:26:44,001 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 30 % complete.
11:49:51,939 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 40 % complete.
12:18:07,786 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 50 % complete.
12:53:08,612 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 60 % complete.
13:30:53,164 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 70 % complete.
14:12:04,777 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 80 % complete.
15:03:15,351 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 90 % complete.
15:43:09,418 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 100 % complete.
15:43:09,420 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery completed.
Current Time : 09:24 (next day)
———————————————————————————-
CPU states: cpu user nice system irq softirq iowait idle
total 22.2% 0.0% 5.9% 0.0% 0.1% 0.0% 71.6%
cpu00 20.1% 0.0% 5.7% 0.0% 0.0% 0.0% 74.0%
cpu01 29.8% 0.0% 8.6% 0.0% 0.0% 0.0% 61.5%
cpu02 20.7% 0.0% 5.7% 0.0% 0.4% 0.0% 72.9%
cpu03 18.3% 0.0% 3.3% 0.0% 0.0% 0.0% 78.2%
———————————————————————————–
Indexes on the Alfresco schema
INDEX_NAME TABLE_NAME
—————————— ——————————
ADT_DATE_IDX ALF_AUDIT_DATE
ADT_DOM_IDX ALF_AUDIT_DATE
ADT_DOW_IDX ALF_AUDIT_DATE
ADT_DOY_IDX ALF_AUDIT_DATE
ADT_HY_IDX ALF_AUDIT_DATE
ADT_M_IDX ALF_AUDIT_DATE
ADT_Q_IDX ALF_AUDIT_DATE
ADT_STORE_IDX ALF_AUDIT_FACT
ADT_USER_IDX ALF_AUDIT_FACT
ADT_WOM_IDX ALF_AUDIT_DATE
ADT_WOY_IDX ALF_AUDIT_DATE
ADT_Y_IDX ALF_AUDIT_DATE
APP_SOURCE_APP_IDX ALF_AUDIT_SOURCE
APP_SOURCE_MET_IDX ALF_AUDIT_SOURCE
APP_SOURCE_SER_IDX ALF_AUDIT_SOURCE
FK335CAE262C5AB86C ALF_MAP_ATTRIBUTE_ENTRIES
FK335CAE26AEAC208C ALF_MAP_ATTRIBUTE_ENTRIES
FK44A37C8A6BD529F3 AVM_NODE_PROPERTIES_NEW
FK60EFB626B9553F6C ALF_NODE
FK60EFB626D24ADD25 ALF_NODE
FK71C2002B7F2C8017 ALF_NODE_STATUS
FK71C2002B9E57C13D ALF_NODE_STATUS
FK7D4CF8EC40E780DC ALF_NODE_PROPERTIES
FK7D4CF8EC7F2C8017 ALF_NODE_PROPERTIES
FK8A749A657B7FDE43 ALF_AUTH_EXT_KEYS
FKB8761A3A9AE340B7 ALF_TRANSACTION
FKBD4FF53D22DBA5BA ALF_STORE
FKC7D52FB02C5AB86C ALF_LIST_ATTRIBUTE_ENTRIES
FKC7D52FB0ACD8822C ALF_LIST_ATTRIBUTE_ENTRIES
FKD3FD9F95EDCD4A96 AVM_ASPECTS_NEW
FKD654E027F2C8017 ALF_NODE_ASPECTS
FKE1A550BCA8FC7769 ALF_NODE_ASSOC
FKE1A550BCB69C43F3 ALF_NODE_ASSOC
FKEAD1817484342E39 ALF_AUDIT_FACT
FKEAD18174A0F9B8D9 ALF_AUDIT_FACT
FKEAD18174F524CFD7 ALF_AUDIT_FACT
FKFFC5468E74173FF4 ALF_CHILD_ASSOC
FKFFC5468E8E50E582 ALF_CHILD_ASSOC
FKFFF41F9960601995 ALF_ACCESS_CONTROL_ENTRY
FKFFF41F99B25A50BF ALF_ACCESS_CONTROL_ENTRY
FKFFF41F99B9553F6C ALF_ACCESS_CONTROL_ENTRY
FK_ATTR_N_ACL ALF_ATTRIBUTES
FK_AVM_ASP_NODE AVM_ASPECTS
FK_AVM_CE_CHILD AVM_CHILD_ENTRIES
FK_AVM_CE_PARENT AVM_CHILD_ENTRIES
FK_AVM_HL_ANCESTOR AVM_HISTORY_LINKS
FK_AVM_HL_DESC AVM_HISTORY_LINKS
FK_AVM_ML_FROM AVM_MERGE_LINKS
FK_AVM_ML_TO AVM_MERGE_LINKS
FK_AVM_NP_NODE AVM_NODE_PROPERTIES
FK_AVM_N_ACL AVM_NODES
FK_AVM_N_STORE AVM_NODES
FK_AVM_SP_STORE AVM_STORE_PROPERTIES
FK_AVM_S_ROOT AVM_STORES
FK_AVM_VR_ROOT AVM_VERSION_ROOTS
FK_AVM_VR_STORE AVM_VERSION_ROOTS
IDX_ACTION_ACTNDL JBPM_ACTION
IDX_ACTION_EVENT JBPM_ACTION
IDX_ACTION_PROCDF JBPM_ACTION
IDX_ASSOC ALF_NODE_ASSOC
IDX_AVM_NP_NAME AVM_NODE_PROPERTIES
IDX_AVM_SP_NAME AVM_STORE_PROPERTIES
IDX_AVM_VR_VERSION AVM_VERSION_ROOTS
IDX_CHILD_NAMECRC ALF_CHILD_ASSOC
IDX_COMMENT_TOKEN JBPM_COMMENT
IDX_COMMENT_TSK JBPM_COMMENT
IDX_DELEG_PRCD JBPM_DELEGATION
IDX_JOB_PRINST JBPM_JOB
IDX_JOB_TOKEN JBPM_JOB
IDX_JOB_TSKINST JBPM_JOB
IDX_MODDEF_PROCDF JBPM_MODULEDEFINITION
IDX_MODINST_PRINST JBPM_MODULEINSTANCE
IDX_NODE_ACTION JBPM_NODE
IDX_NODE_PROCDEF JBPM_NODE
IDX_NODE_SUPRSTATE JBPM_NODE
IDX_PLDACTR_ACTID JBPM_POOLEDACTOR
IDX_PROCDEF_STRTST JBPM_PROCESSDEFINITION
IDX_PROCIN_PROCDEF JBPM_PROCESSINSTANCE
IDX_PROCIN_ROOTTK JBPM_PROCESSINSTANCE
IDX_PROCIN_SPROCTK JBPM_PROCESSINSTANCE
IDX_PSTATE_SBPRCDEF JBPM_NODE
IDX_RTACTN_ACTION JBPM_RUNTIMEACTION
IDX_RTACTN_PRCINST JBPM_RUNTIMEACTION
IDX_SWIMLINST_SL JBPM_SWIMLANEINSTANCE
IDX_TASKINST_TOKN JBPM_TASKINSTANCE
IDX_TASKINST_TSK JBPM_TASKINSTANCE
IDX_TASK_ACTORID JBPM_TASKINSTANCE
IDX_TASK_PROCDEF JBPM_TASK
IDX_TASK_TASKMGTDF JBPM_TASK
IDX_TASK_TSKNODE JBPM_TASK
IDX_TKVARMAP_CTXT JBPM_TOKENVARIABLEMAP
IDX_TKVVARMP_TOKEN JBPM_TOKENVARIABLEMAP
IDX_TOKEN_NODE JBPM_TOKEN
IDX_TOKEN_PARENT JBPM_TOKEN
IDX_TOKEN_PROCIN JBPM_TOKEN
IDX_TOKEN_SUBPI JBPM_TOKEN
IDX_TRANSIT_FROM JBPM_TRANSITION
IDX_TRANSIT_TO JBPM_TRANSITION
IDX_TRANS_PROCDEF JBPM_TRANSITION
IDX_TSKINST_SLINST JBPM_TASKINSTANCE
IDX_TSKINST_SWLANE JBPM_POOLEDACTOR
IDX_TSKINST_TMINST JBPM_TASKINSTANCE
IDX_VARINST_PRCINS JBPM_VARIABLEINSTANCE
IDX_VARINST_TK JBPM_VARIABLEINSTANCE
IDX_VARINST_TKVARMP JBPM_VARIABLEINSTANCE
SS_IDX_ALF_TRANSACTION ALF_TRANSACTION
SYS_C0021810 ALF_APPLIED_PATCH
SYS_C0022135 ALF_ACCESS_CONTROL_ENTRY
SYS_C0022136 ALF_ACCESS_CONTROL_ENTRY
SYS_C0022139 ALF_ACCESS_CONTROL_LIST
SYS_C0022142 ALF_AUTH_EXT_KEYS
SYS_C0022144 ALF_AUTHORITY
SYS_C0022148 ALF_CHILD_ASSOC
SYS_C0022154 ALF_NODE
SYS_C0022155 ALF_NODE
SYS_C0022159 ALF_NODE_ASSOC
SYS_C0022164 ALF_NODE_STATUS
SYS_C0022168 ALF_PERMISSION
SYS_C0022169 ALF_PERMISSION
SYS_C0022172 ALF_STORE
SYS_C0022176 ALF_VERSION_COUNT
SYS_C0022177 ALF_NODE_PROPERTIES
SYS_C0022197 ALF_SERVER
SYS_C0022198 ALF_SERVER
SYS_C0022201 ALF_TRANSACTION
SYS_C0022207 JBPM_ACTION
SYS_C0022209 JBPM_BYTEARRAY
SYS_C0022212 JBPM_BYTEBLOCK
SYS_C0022215 JBPM_COMMENT
SYS_C0022218 JBPM_DECISIONCONDITIONS
SYS_C0022220 JBPM_DELEGATION
SYS_C0022222 JBPM_EVENT
SYS_C0022224 JBPM_EXCEPTIONHANDLER
SYS_C0022227 JBPM_LOG
SYS_C0022230 JBPM_MESSAGE
SYS_C0022233 JBPM_MODULEDEFINITION
SYS_C0022236 JBPM_MODULEINSTANCE
SYS_C0022239 JBPM_NODE
SYS_C0022241 JBPM_POOLEDACTOR
SYS_C0022243 JBPM_PROCESSDEFINITION
SYS_C0022246 JBPM_PROCESSINSTANCE
SYS_C0022249 JBPM_RUNTIMEACTION
SYS_C0022251 JBPM_SWIMLANE
SYS_C0022253 JBPM_SWIMLANEINSTANCE
SYS_C0022255 JBPM_TASK
SYS_C0022258 JBPM_TASKACTORPOOL
SYS_C0022260 JBPM_TASKCONTROLLER
SYS_C0022263 JBPM_TASKINSTANCE
SYS_C0022265 JBPM_TIMER
SYS_C0022268 JBPM_TOKEN
SYS_C0022270 JBPM_TOKENVARIABLEMAP
SYS_C0022272 JBPM_TRANSITION
SYS_C0022274 JBPM_VARIABLEACCESS
SYS_C0022277 JBPM_VARIABLEINSTANCE
SYS_C0022280 ALF_AUDIT_CONFIG
SYS_C0022292 ALF_AUDIT_DATE
SYS_C0022302 ALF_AUDIT_FACT
SYS_C0022305 ALF_AUDIT_SOURCE
SYS_C0022402 JBPM_JOB
SYS_C0022406 ALF_ATTRIBUTES
SYS_C0022408 ALF_GLOBAL_ATTRIBUTES
SYS_C0022409 ALF_GLOBAL_ATTRIBUTES
SYS_C0022412 ALF_LIST_ATTRIBUTE_ENTRIES
SYS_C0022415 ALF_MAP_ATTRIBUTE_ENTRIES
SYS_C0022417 AVM_ASPECTS
SYS_C0022420 AVM_ASPECTS_NEW
SYS_C0022424 AVM_CHILD_ENTRIES
SYS_C0022427 AVM_HISTORY_LINKS
SYS_C0022430 AVM_MERGE_LINKS
SYS_C0022435 AVM_NODE_PROPERTIES
SYS_C0022441 AVM_NODE_PROPERTIES_NEW
SYS_C0022452 AVM_NODES
SYS_C0022457 AVM_STORE_PROPERTIES
SYS_C0022461 AVM_STORES
SYS_C0022462 AVM_STORES
SYS_C0022465 AVM_VERSION_LAYERED_NODE_ENTRY
SYS_C0022472 AVM_VERSION_ROOTS
SYS_C0022473 AVM_VERSION_ROOTS
178 rows selected