title: SQL Developer freezing with GC overhead limit exceeded error on MySQL database
body: <p>I am trying to use Oracle SQL Developer with a MySQL database. I can connect just fine and I can execute queries, I can see the tables, and with a table selected I can click on all tabs fine with the exception of the "Data" tab. When I click on the "Data" tab, I get a message "Waiting for Editor to initialize" and SQL Developer freezes. After a few minutes I get a message "GC overhead limit exceeded" with the following stack</p>
  
  <pre><code>java.lang.OutOfMemoryError: GC overhead limit exceeded
  at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:2114)
  at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1921)
  at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3278)
  at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:462)
  at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2997)
  at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2245)
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2638)
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
  at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
  at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030)
  at oracle.dbtools.raptor.controls.grid.ResultSetTableModel.openResultSet(ResultSetTableModel.java:490)
  at oracle.dbtools.raptor.controls.grid.ResultSetTableModel.fetchNext(ResultSetTableModel.java:274)
  at oracle.dbtools.raptor.controls.grid.ResultSetTableModel$4.doWork(ResultSetTableModel.java:686)
  at oracle.dbtools.raptor.controls.grid.ResultSetTableModel$4.doWork(ResultSetTableModel.java:670)
  at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
  at java.util.concurrent.FutureTask.run(FutureTask.java:262)
  at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:554)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
  at java.util.concurrent.FutureTask.run(FutureTask.java:262)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  at java.lang.Thread.run(Thread.java:745)
  </code></pre>
  
  <p>I looked around stackoverflow andn google but I could not finf anything that works for me. I am running this on Windows 7 64bit, SQL Developer version 4.0.3.16, MySQL server version 5.5. I have added a line </p>
  
  <pre><code>AddVMOption -Xmx1024M
  </code></pre>
  
  <p>in the sqldeveloper\sqldeveloper\bin\sqldeveloper.conf file, as suggested here </p>
  
  <p><a href="https://codechief.wordpress.com/2008/07/30/configuring-oracle-sql-developer-for-large-files-fix-out-of-memory-errors/" rel="noreferrer">https://codechief.wordpress.com/2008/07/30/configuring-oracle-sql-developer-for-large-files-fix-out-of-memory-errors/</a></p>
  
  <p>and also added changed the initial and max memory allocation pool sizes in the 
  C:\Users\\AppData\Roaming\sqldeveloper\1.0.0.0.0\product.conf file to </p>
  
  <pre><code>AddVMOption -Xms512m
  </code></pre>
  
  <p>and</p>
  
  <pre><code>AddVMOption -Xmx1024m
  </code></pre>
  
  <p>respectively. I am monitoring the performance and I am not running out of memory, but the CPU utilization rate goes above 90%.</p>
  
  <p>Thanks!</p>