On Dec 14, 2010, at 7:21 PM, Feris Thia wrote:
> Hi Mark,
> On Wed, Dec 15, 2010 at 8:10 AM, Mark Matthews <mark.matthews@stripped>
> *How* are you writing, via batch statements with rewriting, or directly, or via LOAD
> DATA INFILE? It seems you're off by about a factor of 10-20x from what I've seen
> performance-wise for writes.
> I'm using ETL mean - for this case, it is a java application name Kettle (Pentaho
> Data Integration). And it use JDBC connection.
> Is it a JDBC driver configuration ?
I don't know what Kettle is doing under the hood, but if it's doing addBatch(),
executeBatch(), then adding "rewriteBatchedStatements=true" to your MySQL JDBC URL should
probably help quite a bit.
Principal Software Developer - MySQL Enterprise Tools