AnsweredAssumed Answered

very slow importing via cifs

Question asked by stegbth on Jan 2, 2013
Latest reply on Jan 2, 2013 by stegbth
hi,

i upgraded an Alfresco Commuity 3.4b to 4.0e, still with lucene index.
The machine is a Ubuntu 10.04 with Mysql database.

i have to import about 20000PDF documents (each aboul 200kb).
This should (and is currently) run via cifs.

in the last 3hours it imported about 20files.

I already defined background indexing:

#
# Index Recovery Mode
#————-
index.recovery.mode=AUTO
#index.recovery.mode=FULL


### Solr indexing ###
#index.subsystem.name=solr
#dir.keystore=${dir.root}/keystore
#solr.port.ssl=8443

index.subsystem.name=lucene
dir.keystore=${dir.root}/keystore
# scaleup Bulkload, see: http://de.slideshare.net/alfresco/scale-your-alfresco-solutions
index.tracking.disableInTransactionIndexing=true
lucene.maxAtomicTransformationTime=0
index.tracking.cronExpression=0/5 * * * * ?
system.enableTimestampPropagation=false

but after importing the load of mysql grows up and stays at 199% CPU usage and aboud 2GB VirtMemory usage.

But i assume there must be some Mysql performancetuning i forgot. here are some parts from my.cnf.


key_buffer              = 1024M
max_allowed_packet      = 32M
thread_stack            = 256K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit       = 192M
query_cache_size        = 768M


hopefully somebody can point me to my error.
thomas

Outcomes