Wednesday, February 13, 2013

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

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.
 
 

No comments:

Post a Comment