Re: CPU spikes and performance problems with Connector/J 5.1.12
Posted by: Mark Matthews
Date: January 06, 2014 01:26PM

Juliano DeCarvalho Wrote:
-------------------------------------------------------
> We are still seeing this problem daily. We have a
> very high number of threads at the following lines
> of code in PreparedStatement.ParseInfo()
> constructor:
>
> for (i = statementStartPos; i <
> this.statementLength; ++i) {
> char c = sql.charAt(i);
>
> The String.charAt() call is taking forever to
> return in some cases, and I'm not sure why. To me
> this seems like a fairly simple char array lookup.
> We are using JDK 1.6.0_45. Any help or ideas
> would be greatly appreciated.

Juliano,

There are known concurrent bottlenecks in Java's character encode/decode functionality, in this case, caching prepared statements (adding cachePrepStmts=true as a JDBC connection URL property) could help.

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html

Options: ReplyQuote


Subject
Written By
Posted
Re: CPU spikes and performance problems with Connector/J 5.1.12
January 06, 2014 01:26PM


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.