MySQL Forums
Forum List  »  InnoDB

InnoDB out of memory when using ORDER BY on some queries
Posted by: Eric Milles
Date: May 27, 2005 12:10PM

I am getting an out of memory problem (see exception snippet below). When I dig in a bit, I find that the query in question ends with an ORDER BY clause. When I remove the ORDER BY clause, no more problem. The table being sorted is about 14.1 MB and the requested size below is 16 MB. Problem is, I don't know where in MySQL it is trying to allocate this buffer. Does someone know exactly where I need to make a change in the memory settings of MySQL to avoid this issue?

Caused by: java.sql.SQLException: Out of memory (Needed 16777216 bytes)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1347)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:958)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)

Eric M

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB out of memory when using ORDER BY on some queries
3216
May 27, 2005 12:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.