I used to face this issue more often when I used CachedSqlEntityProcessor in DIH.
I then started indexing in batches (by including where condition) instead of indexing everything at once.. You can refer to other available options for mysql driver http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html I also included the below stuff in datasource settings.. <dataSource type="JdbcDataSource" name="ds-2" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:8889/mysqldatabase" batchSize="-1" user="root" password="root"/> -- View this message in context: http://lucene.472066.n3.nabble.com/Indexing-Heavy-dataset-tp4068279p4068460.html Sent from the Solr - User mailing list archive at Nabble.com.
