Wednesday, February 13, 2013

Re: java.sql.SQLNonTransientException: Instance has too many concurrent requests: 100

You might find this useful.



Amit

On Wed, Feb 13, 2013 at 6:42 PM, tom hill <tom.hill.fellow@gmail.com> wrote:
we have built  a benchmark [tpc c] and simulator under a Google Research grant.

the benchmark [a client python program] generates the following number of concurrent users
[accepted by a frontend java program(multiple instances) that sends SQL statements to CloudSQL database instances of varying sizes]:
number of concurrent users:
10,
20,
40,
160,
320,
1,200,
7,500    

the  frontend java program uses: 
1. conn = DriverManager.getConnection("jdbc:google:rdbms://instance:xxxxx/tpcc32")
2. conn.prepareStatements
3. xxxxxxx.executeUpdate()   AND
4. yyyyyy.executeQuery()
to communicate with the CloudSQL instance

thanks for your help

tom 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

No comments:

Post a Comment