MySolr

One DataImportHandler(DIH) configuration people may overlook is the batchSize attribute.  If you start your JVM with enough memory to store the entire table, you won’t even need to set batchSize at all.  batchSize basically tells DIH to call setFetchSize through JDBC to bring back certain number of records at once.  If you use MySQL, you may still run out of memory even when you set the batchSize attribute.  That’s due to a limitation in MySQL’s drive where the setting is ignored.  The workaround is setting batchSize to “-1″.  This will pass Integer.MIN_VALUE to MySQL as fetch size and prevent the driver from running out of memory.

<dataSource driver="org.gjt.mm.mysql.Driver" url="jdbc:mysql://localhost/db"
user="root" password="root" batchSize="-1"/>

Read original blog post