title: Pentaho PDI (Spoon): MySQL table output very slow (~2000 rows/s)
body: <p>My table output step is terribly slow (~2.000 rows/second), compared to the input (100.000-200.000 rows/second). The MySQL server is not the problem, using native MySQL, e.g. with the "Execute SQL script" step, I get something in the 100thousands/second. I already tried (without success) the common solution of extending the SQL options by:</p>
  
  <pre><code>useServerPrepStmts=false
  rewriteBatchedStatements=true
  useCompression=true
  </code></pre>
  
  <p>I also varied the commit size parameter (100, 1.000, 10.000) and <code>Use batch updates for inserts</code> is enabled, also without success. What else can I do? I have tables with ~10.000.000 rows and Pentaho runs on a very potent machine, so this is not acceptable. </p>