Re: [google-cloud-sql-discuss] App Engine fetching data from google cloud instance very slow

Glad to hear that things are working now. :-)

-- Razvan ME

On Thu, Nov 26, 2015 at 7:34 AM, Kürsat Aydinli <kuersat.aydinli@uzh.ch> wrote:

I think I figured out the problem...I always forgot to close the established connection like you said...now I closed every connection after the data fetch was successful...and now the links works fine...It`s a bit slow but at least it does not break the connection after 1 minute....thanks so much for your help

Kind Regards

Am Mittwoch, 25. November 2015 23:23:12 UTC+1 schrieb Razvan Musaloiu-E.:

An example is here:

https://cloud.google.com/appengine/docs/java/cloud-sql/

At the bottom there are some links to some more examples on GitHub.

-- Razvan ME

On Wed, Nov 25, 2015 at 2:21 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

How can I make sure the app is not leaking the Cloud Sql connection? Can I somehow reset my used connection? I didn´t get your answer I think

Am Mittwoch, 25. November 2015 23:16:40 UTC+1 schrieb Razvan Musaloiu-E.:

Can you please make sure the app is not leaking the Cloud SQL connections? Each GAE instance is not allowed to use more than 12 connections and the one I looked was already hitting that limit.

-- Razvan ME

On Wed, Nov 25, 2015 at 2:08 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

This is my connection link:

url = "jdbc:google:mysql://moviedatabase-1113:moviedatabase/moviedatabase?user=root";

Am Mittwoch, 25. November 2015 22:55:48 UTC+1 schrieb Razvan Musaloiu-E.:

How are you connecting to Cloud SQL from GAE? Are you using a JDBC URL that has a 'jdbc:google:mysql://' prefix?

-- Razvan ME

On Wed, Nov 25, 2015 at 1:50 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

Hi,

I have written a GWT App which visualizes moviedata (database with 80000 rows/entries) on the Web in different manners (Table, Worldmap, Piechart, Columnchart). For my local development I use Wamp Server and local MySQL database which works really fine and fast. But when I host the App to GAE (using same database which is on Google Cloud SQL) the fetching time from the database is very slow...it even seems to crash after 1 minute. After the first deployment of the App to GAE the App seems to work, but when I try to reload or filter the table view of the data, the connection to Google Cloud Sql seems to crash.

My App is authorized on Google Cloud and has access to my database on Google CLoud SQL. But After I use my App for like 1 minute the database connections seems to be interrupted.

I have gone through every possible setting opportunities on Google Developers.

Could you please give me some help or advice? If needed, I can post my App Engine Link for you to try out the App.

Thanks and Kind Regards

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/4fbb6c80-2975-46ab-a269-df95bda66928%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3dc6416f-ada2-4925-b1fc-fe12f20d0cee%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6e481a4e-9e0b-4106-a1f7-e721f75ae702%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/c2b8f48a-2a0a-4863-b77f-81e14919d05d%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CA%2BUvTg2FQP_JETTPsY7pi6mu0fQpiRrFxEg_mTRgs4Gmj1-TBQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Connect to Cloud SQL from Visaul Studio 2013

Hi Javier,

Could you give a bit more information into what you're looking into? Because if what you need is a connector, then you can look into stack overflow answers, some of them contain what you want.

If you have a connector or something and you're looking into how to connect to your application, then please let me know if you have a Cloud SQL instance, or a MySQL instance you put in your Compute Engine instance. Also, which connector are you using?

Cheers!

On Wednesday, November 25, 2015 at 6:28:20 PM UTC-5, Javier Alexander Baires Lopez wrote:

Hi, how can i connect to MySQL instance from visual studio 2013?, what is the string connection?

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/aee8f60e-b047-4630-aa43-0e8a8cd6f729%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] App Engine fetching data from google cloud instance very slow

I think I figured out the problem...I always forgot to close the established connection like you said...now I closed every connection after the data fetch was successful...and now the links works fine...It`s a bit slow but at least it does not break the connection after 1 minute....thanks so much for your help

Kind Regards

Am Mittwoch, 25. November 2015 23:23:12 UTC+1 schrieb Razvan Musaloiu-E.:

An example is here:

https://cloud.google.com/appengine/docs/java/cloud-sql/

At the bottom there are some links to some more examples on GitHub.

-- Razvan ME

On Wed, Nov 25, 2015 at 2:21 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

How can I make sure the app is not leaking the Cloud Sql connection? Can I somehow reset my used connection? I didn´t get your answer I think

Am Mittwoch, 25. November 2015 23:16:40 UTC+1 schrieb Razvan Musaloiu-E.:

Can you please make sure the app is not leaking the Cloud SQL connections? Each GAE instance is not allowed to use more than 12 connections and the one I looked was already hitting that limit.

-- Razvan ME

On Wed, Nov 25, 2015 at 2:08 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

This is my connection link:

url = "jdbc:google:mysql://moviedatabase-1113:moviedatabase/moviedatabase?user=root";

Am Mittwoch, 25. November 2015 22:55:48 UTC+1 schrieb Razvan Musaloiu-E.:

How are you connecting to Cloud SQL from GAE? Are you using a JDBC URL that has a 'jdbc:google:mysql://' prefix?

-- Razvan ME

On Wed, Nov 25, 2015 at 1:50 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

Hi,

I have written a GWT App which visualizes moviedata (database with 80000 rows/entries) on the Web in different manners (Table, Worldmap, Piechart, Columnchart). For my local development I use Wamp Server and local MySQL database which works really fine and fast. But when I host the App to GAE (using same database which is on Google Cloud SQL) the fetching time from the database is very slow...it even seems to crash after 1 minute. After the first deployment of the App to GAE the App seems to work, but when I try to reload or filter the table view of the data, the connection to Google Cloud Sql seems to crash.

My App is authorized on Google Cloud and has access to my database on Google CLoud SQL. But After I use my App for like 1 minute the database connections seems to be interrupted.

I have gone through every possible setting opportunities on Google Developers.

Could you please give me some help or advice? If needed, I can post my App Engine Link for you to try out the App.

Thanks and Kind Regards

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/4fbb6c80-2975-46ab-a269-df95bda66928%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3dc6416f-ada2-4925-b1fc-fe12f20d0cee%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6e481a4e-9e0b-4106-a1f7-e721f75ae702%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/c2b8f48a-2a0a-4863-b77f-81e14919d05d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] App Engine fetching data from google cloud instance very slow

This is my method in the class which establishes a database connection to Cloud SQL. The first method is the connection establishing method and the second method is a sample method I use during my RPC calls to fetch data from the database:

public void connect() throws ClassNotFoundException {

if (SystemProperty.environment.value() == SystemProperty.Environment.Value.Production) {

Class.forName("com.mysql.jdbc.GoogleDriver");

url = "jdbc:google:mysql://moviedatabase-1113:moviedatabase/moviedatabase?user=root";

} else {

Class.forName("com.mysql.jdbc.Driver");

url = "jdbc:mysql://localhost:3306/moviedatabase-neu?user=root";

}

}

/**

* fetches data from the database depending on the SQL query. Returns an

* arraylist of movie data instances in order to visualize them in different

* manners

*/

public List<DataRow> fetchData(String query) {

String SQLquery = query;

java.sql.ResultSet result = null;

ArrayList<DataRow> datarow = new ArrayList<DataRow>();

try {

this.connect();

Connection conn = DriverManager.getConnection(this.url, "root","root");

result = conn.createStatement().executeQuery(SQLquery);

int count = 0;

while (result.next()) {

datarow.add(new DataRow());

datarow.get(count).setWiki(result.getInt("WikipediaID"));

datarow.get(count).setFreebase(result.getString("FreebaseID"));

datarow.get(count).setName(result.getString("Name"));

datarow.get(count).setYear(result.getInt("Year"));

datarow.get(count).setRevenue(result.getInt("Revenue"));

datarow.get(count).setLength(result.getDouble("Length"));

datarow.get(count).setLanguage(cleanQuery(result.getString("Language")));

datarow.get(count).setCountry(cleanQuery(result.getString("Country")));

datarow.get(count).setGenre(cleanQuery(result.getString("Genre")));

count++;

}

} catch (SQLException e) {

e.printStackTrace();

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

/**

* returns arraylist of moviedata

*/

return datarow;

}

Did I forget to close established connections somewhere?

Thanks and Regards
Am Mittwoch, 25. November 2015 23:23:12 UTC+1 schrieb Razvan Musaloiu-E.:

An example is here:

https://cloud.google.com/appengine/docs/java/cloud-sql/

At the bottom there are some links to some more examples on GitHub.

-- Razvan ME

On Wed, Nov 25, 2015 at 2:21 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

How can I make sure the app is not leaking the Cloud Sql connection? Can I somehow reset my used connection? I didn´t get your answer I think

Am Mittwoch, 25. November 2015 23:16:40 UTC+1 schrieb Razvan Musaloiu-E.:

Can you please make sure the app is not leaking the Cloud SQL connections? Each GAE instance is not allowed to use more than 12 connections and the one I looked was already hitting that limit.

-- Razvan ME

On Wed, Nov 25, 2015 at 2:08 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

This is my connection link:

url = "jdbc:google:mysql://moviedatabase-1113:moviedatabase/moviedatabase?user=root";

Am Mittwoch, 25. November 2015 22:55:48 UTC+1 schrieb Razvan Musaloiu-E.:

How are you connecting to Cloud SQL from GAE? Are you using a JDBC URL that has a 'jdbc:google:mysql://' prefix?

-- Razvan ME

On Wed, Nov 25, 2015 at 1:50 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

Hi,

I have written a GWT App which visualizes moviedata (database with 80000 rows/entries) on the Web in different manners (Table, Worldmap, Piechart, Columnchart). For my local development I use Wamp Server and local MySQL database which works really fine and fast. But when I host the App to GAE (using same database which is on Google Cloud SQL) the fetching time from the database is very slow...it even seems to crash after 1 minute. After the first deployment of the App to GAE the App seems to work, but when I try to reload or filter the table view of the data, the connection to Google Cloud Sql seems to crash.

My App is authorized on Google Cloud and has access to my database on Google CLoud SQL. But After I use my App for like 1 minute the database connections seems to be interrupted.

I have gone through every possible setting opportunities on Google Developers.

Could you please give me some help or advice? If needed, I can post my App Engine Link for you to try out the App.

Thanks and Kind Regards

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/4fbb6c80-2975-46ab-a269-df95bda66928%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3dc6416f-ada2-4925-b1fc-fe12f20d0cee%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6e481a4e-9e0b-4106-a1f7-e721f75ae702%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/0438705e-5e60-46ef-b562-693961e800cd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] App Engine fetching data from google cloud instance very slow

The link you sent me statet to always close established connection...where exactly do I have to close established connections? After each RPC Call or after the Connection method you got my link from?

Am Mittwoch, 25. November 2015 23:23:12 UTC+1 schrieb Razvan Musaloiu-E.:

An example is here:

https://cloud.google.com/appengine/docs/java/cloud-sql/

At the bottom there are some links to some more examples on GitHub.

-- Razvan ME

On Wed, Nov 25, 2015 at 2:21 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

How can I make sure the app is not leaking the Cloud Sql connection? Can I somehow reset my used connection? I didn´t get your answer I think

Am Mittwoch, 25. November 2015 23:16:40 UTC+1 schrieb Razvan Musaloiu-E.:

Can you please make sure the app is not leaking the Cloud SQL connections? Each GAE instance is not allowed to use more than 12 connections and the one I looked was already hitting that limit.

-- Razvan ME

On Wed, Nov 25, 2015 at 2:08 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

This is my connection link:

url = "jdbc:google:mysql://moviedatabase-1113:moviedatabase/moviedatabase?user=root";

Am Mittwoch, 25. November 2015 22:55:48 UTC+1 schrieb Razvan Musaloiu-E.:

How are you connecting to Cloud SQL from GAE? Are you using a JDBC URL that has a 'jdbc:google:mysql://' prefix?

-- Razvan ME

On Wed, Nov 25, 2015 at 1:50 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

Hi,

I have written a GWT App which visualizes moviedata (database with 80000 rows/entries) on the Web in different manners (Table, Worldmap, Piechart, Columnchart). For my local development I use Wamp Server and local MySQL database which works really fine and fast. But when I host the App to GAE (using same database which is on Google Cloud SQL) the fetching time from the database is very slow...it even seems to crash after 1 minute. After the first deployment of the App to GAE the App seems to work, but when I try to reload or filter the table view of the data, the connection to Google Cloud Sql seems to crash.

My App is authorized on Google Cloud and has access to my database on Google CLoud SQL. But After I use my App for like 1 minute the database connections seems to be interrupted.

I have gone through every possible setting opportunities on Google Developers.

Could you please give me some help or advice? If needed, I can post my App Engine Link for you to try out the App.

Thanks and Kind Regards

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/4fbb6c80-2975-46ab-a269-df95bda66928%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3dc6416f-ada2-4925-b1fc-fe12f20d0cee%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6e481a4e-9e0b-4106-a1f7-e721f75ae702%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/8e175af6-0f68-4ac7-a59c-5bb606c001ea%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] App Engine fetching data from google cloud instance very slow

I somehow can`t connect to the Google CLoud SQL Instance in the properties menu from my app. However, I get acces to my data when I deploy the first time. I have attached a screenshot of my configuration. On Cloud SQL, I use root as user and password...

No mather which combination I try to enter to the dialog box i always get an error...I also tried to enter the IPV6-Address as instance name

Am Mittwoch, 25. November 2015 23:23:12 UTC+1 schrieb Razvan Musaloiu-E.:

An example is here:

https://cloud.google.com/appengine/docs/java/cloud-sql/

At the bottom there are some links to some more examples on GitHub.

-- Razvan ME

On Wed, Nov 25, 2015 at 2:21 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

How can I make sure the app is not leaking the Cloud Sql connection? Can I somehow reset my used connection? I didn´t get your answer I think

Am Mittwoch, 25. November 2015 23:16:40 UTC+1 schrieb Razvan Musaloiu-E.:

Can you please make sure the app is not leaking the Cloud SQL connections? Each GAE instance is not allowed to use more than 12 connections and the one I looked was already hitting that limit.

-- Razvan ME

On Wed, Nov 25, 2015 at 2:08 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

This is my connection link:

url = "jdbc:google:mysql://moviedatabase-1113:moviedatabase/moviedatabase?user=root";

Am Mittwoch, 25. November 2015 22:55:48 UTC+1 schrieb Razvan Musaloiu-E.:

How are you connecting to Cloud SQL from GAE? Are you using a JDBC URL that has a 'jdbc:google:mysql://' prefix?

-- Razvan ME

On Wed, Nov 25, 2015 at 1:50 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

Hi,

I have written a GWT App which visualizes moviedata (database with 80000 rows/entries) on the Web in different manners (Table, Worldmap, Piechart, Columnchart). For my local development I use Wamp Server and local MySQL database which works really fine and fast. But when I host the App to GAE (using same database which is on Google Cloud SQL) the fetching time from the database is very slow...it even seems to crash after 1 minute. After the first deployment of the App to GAE the App seems to work, but when I try to reload or filter the table view of the data, the connection to Google Cloud Sql seems to crash.

My App is authorized on Google Cloud and has access to my database on Google CLoud SQL. But After I use my App for like 1 minute the database connections seems to be interrupted.

I have gone through every possible setting opportunities on Google Developers.

Could you please give me some help or advice? If needed, I can post my App Engine Link for you to try out the App.

Thanks and Kind Regards

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/4fbb6c80-2975-46ab-a269-df95bda66928%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3dc6416f-ada2-4925-b1fc-fe12f20d0cee%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6e481a4e-9e0b-4106-a1f7-e721f75ae702%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/29b2a52d-d184-4690-8c29-f81ca95143b4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Connect to Cloud SQL from Visaul Studio 2013

Hi, how can i connect to MySQL instance from visual studio 2013?, what is the string connection?

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/538cb701-c395-456d-b89f-03fc7e8cdcd6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] App Engine fetching data from google cloud instance very slow

An example is here:

https://cloud.google.com/appengine/docs/java/cloud-sql/

At the bottom there are some links to some more examples on GitHub.

-- Razvan ME

On Wed, Nov 25, 2015 at 2:21 PM, Kürsat Aydinli <kuersat.aydinli@uzh.ch> wrote:

How can I make sure the app is not leaking the Cloud Sql connection? Can I somehow reset my used connection? I didn´t get your answer I think

Am Mittwoch, 25. November 2015 23:16:40 UTC+1 schrieb Razvan Musaloiu-E.:

Can you please make sure the app is not leaking the Cloud SQL connections? Each GAE instance is not allowed to use more than 12 connections and the one I looked was already hitting that limit.

-- Razvan ME

On Wed, Nov 25, 2015 at 2:08 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

This is my connection link:

url = "jdbc:google:mysql://moviedatabase-1113:moviedatabase/moviedatabase?user=root";

Am Mittwoch, 25. November 2015 22:55:48 UTC+1 schrieb Razvan Musaloiu-E.:

How are you connecting to Cloud SQL from GAE? Are you using a JDBC URL that has a 'jdbc:google:mysql://' prefix?

-- Razvan ME

On Wed, Nov 25, 2015 at 1:50 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

Hi,

I have written a GWT App which visualizes moviedata (database with 80000 rows/entries) on the Web in different manners (Table, Worldmap, Piechart, Columnchart). For my local development I use Wamp Server and local MySQL database which works really fine and fast. But when I host the App to GAE (using same database which is on Google Cloud SQL) the fetching time from the database is very slow...it even seems to crash after 1 minute. After the first deployment of the App to GAE the App seems to work, but when I try to reload or filter the table view of the data, the connection to Google Cloud Sql seems to crash.

My App is authorized on Google Cloud and has access to my database on Google CLoud SQL. But After I use my App for like 1 minute the database connections seems to be interrupted.

I have gone through every possible setting opportunities on Google Developers.

Could you please give me some help or advice? If needed, I can post my App Engine Link for you to try out the App.

Thanks and Kind Regards

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/4fbb6c80-2975-46ab-a269-df95bda66928%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3dc6416f-ada2-4925-b1fc-fe12f20d0cee%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6e481a4e-9e0b-4106-a1f7-e721f75ae702%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CA%2BUvTg2qt3A6aC%3DaFy%2BN9toxZ3vXc9dPAdppt82LhrHw5X787w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] App Engine fetching data from google cloud instance very slow

How can I make sure the app is not leaking the Cloud Sql connection? Can I somehow reset my used connection? I didn´t get your answer I think

Am Mittwoch, 25. November 2015 23:16:40 UTC+1 schrieb Razvan Musaloiu-E.:

Can you please make sure the app is not leaking the Cloud SQL connections? Each GAE instance is not allowed to use more than 12 connections and the one I looked was already hitting that limit.

-- Razvan ME

On Wed, Nov 25, 2015 at 2:08 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

This is my connection link:

url = "jdbc:google:mysql://moviedatabase-1113:moviedatabase/moviedatabase?user=root";

Am Mittwoch, 25. November 2015 22:55:48 UTC+1 schrieb Razvan Musaloiu-E.:

How are you connecting to Cloud SQL from GAE? Are you using a JDBC URL that has a 'jdbc:google:mysql://' prefix?

-- Razvan ME

On Wed, Nov 25, 2015 at 1:50 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

Hi,

I have written a GWT App which visualizes moviedata (database with 80000 rows/entries) on the Web in different manners (Table, Worldmap, Piechart, Columnchart). For my local development I use Wamp Server and local MySQL database which works really fine and fast. But when I host the App to GAE (using same database which is on Google Cloud SQL) the fetching time from the database is very slow...it even seems to crash after 1 minute. After the first deployment of the App to GAE the App seems to work, but when I try to reload or filter the table view of the data, the connection to Google Cloud Sql seems to crash.

My App is authorized on Google Cloud and has access to my database on Google CLoud SQL. But After I use my App for like 1 minute the database connections seems to be interrupted.

I have gone through every possible setting opportunities on Google Developers.

Could you please give me some help or advice? If needed, I can post my App Engine Link for you to try out the App.

Thanks and Kind Regards

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/4fbb6c80-2975-46ab-a269-df95bda66928%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3dc6416f-ada2-4925-b1fc-fe12f20d0cee%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6e481a4e-9e0b-4106-a1f7-e721f75ae702%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] App Engine fetching data from google cloud instance very slow

Can you please make sure the app is not leaking the Cloud SQL connections? Each GAE instance is not allowed to use more than 12 connections and the one I looked was already hitting that limit.

-- Razvan ME

On Wed, Nov 25, 2015 at 2:08 PM, Kürsat Aydinli <kuersat.aydinli@uzh.ch> wrote:

This is my connection link:

url = "jdbc:google:mysql://moviedatabase-1113:moviedatabase/moviedatabase?user=root";

Am Mittwoch, 25. November 2015 22:55:48 UTC+1 schrieb Razvan Musaloiu-E.:

How are you connecting to Cloud SQL from GAE? Are you using a JDBC URL that has a 'jdbc:google:mysql://' prefix?

-- Razvan ME

On Wed, Nov 25, 2015 at 1:50 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

Hi,

I have written a GWT App which visualizes moviedata (database with 80000 rows/entries) on the Web in different manners (Table, Worldmap, Piechart, Columnchart). For my local development I use Wamp Server and local MySQL database which works really fine and fast. But when I host the App to GAE (using same database which is on Google Cloud SQL) the fetching time from the database is very slow...it even seems to crash after 1 minute. After the first deployment of the App to GAE the App seems to work, but when I try to reload or filter the table view of the data, the connection to Google Cloud Sql seems to crash.

My App is authorized on Google Cloud and has access to my database on Google CLoud SQL. But After I use my App for like 1 minute the database connections seems to be interrupted.

I have gone through every possible setting opportunities on Google Developers.

Could you please give me some help or advice? If needed, I can post my App Engine Link for you to try out the App.

Thanks and Kind Regards

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/4fbb6c80-2975-46ab-a269-df95bda66928%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3dc6416f-ada2-4925-b1fc-fe12f20d0cee%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CA%2BUvTg38vPu9uDFVNHo5z%3DyYDqEkaBy7gNa2eiFnE9fDJb3qYg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] App Engine fetching data from google cloud instance very slow

This is my connection link:

url = "jdbc:google:mysql://moviedatabase-1113:moviedatabase/moviedatabase?user=root";

Am Mittwoch, 25. November 2015 22:55:48 UTC+1 schrieb Razvan Musaloiu-E.:

How are you connecting to Cloud SQL from GAE? Are you using a JDBC URL that has a 'jdbc:google:mysql://' prefix?

-- Razvan ME

On Wed, Nov 25, 2015 at 1:50 PM, Kürsat Aydinli <kuersat...@uzh.ch> wrote:

Hi,

I have written a GWT App which visualizes moviedata (database with 80000 rows/entries) on the Web in different manners (Table, Worldmap, Piechart, Columnchart). For my local development I use Wamp Server and local MySQL database which works really fine and fast. But when I host the App to GAE (using same database which is on Google Cloud SQL) the fetching time from the database is very slow...it even seems to crash after 1 minute. After the first deployment of the App to GAE the App seems to work, but when I try to reload or filter the table view of the data, the connection to Google Cloud Sql seems to crash.

My App is authorized on Google Cloud and has access to my database on Google CLoud SQL. But After I use my App for like 1 minute the database connections seems to be interrupted.

I have gone through every possible setting opportunities on Google Developers.

Could you please give me some help or advice? If needed, I can post my App Engine Link for you to try out the App.

Thanks and Kind Regards

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/4fbb6c80-2975-46ab-a269-df95bda66928%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3dc6416f-ada2-4925-b1fc-fe12f20d0cee%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] App Engine fetching data from google cloud instance very slow

How are you connecting to Cloud SQL from GAE? Are you using a JDBC URL that has a 'jdbc:google:mysql://' prefix?

-- Razvan ME

On Wed, Nov 25, 2015 at 1:50 PM, Kürsat Aydinli <kuersat.aydinli@uzh.ch> wrote:

Hi,

I have written a GWT App which visualizes moviedata (database with 80000 rows/entries) on the Web in different manners (Table, Worldmap, Piechart, Columnchart). For my local development I use Wamp Server and local MySQL database which works really fine and fast. But when I host the App to GAE (using same database which is on Google Cloud SQL) the fetching time from the database is very slow...it even seems to crash after 1 minute. After the first deployment of the App to GAE the App seems to work, but when I try to reload or filter the table view of the data, the connection to Google Cloud Sql seems to crash.

My App is authorized on Google Cloud and has access to my database on Google CLoud SQL. But After I use my App for like 1 minute the database connections seems to be interrupted.

I have gone through every possible setting opportunities on Google Developers.

Could you please give me some help or advice? If needed, I can post my App Engine Link for you to try out the App.

Thanks and Kind Regards

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/4fbb6c80-2975-46ab-a269-df95bda66928%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CA%2BUvTg0whU-6EOcG4W77MP7PwHrErZwaQh-Ej-69%3DJU126cpwg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] App Engine fetching data from google cloud instance very slow

Hi,

I have written a GWT App which visualizes moviedata (database with 80000 rows/entries) on the Web in different manners (Table, Worldmap, Piechart, Columnchart). For my local development I use Wamp Server and local MySQL database which works really fine and fast. But when I host the App to GAE (using same database which is on Google Cloud SQL) the fetching time from the database is very slow...it even seems to crash after 1 minute. After the first deployment of the App to GAE the App seems to work, but when I try to reload or filter the table view of the data, the connection to Google Cloud Sql seems to crash.

My App is authorized on Google Cloud and has access to my database on Google CLoud SQL. But After I use my App for like 1 minute the database connections seems to be interrupted.

I have gone through every possible setting opportunities on Google Developers.

Could you please give me some help or advice? If needed, I can post my App Engine Link for you to try out the App.

Thanks and Kind Regards

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/4fbb6c80-2975-46ab-a269-df95bda66928%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Very slow fetch

To begin with, we have to be clear that comparing Cloud SQL to any other product or service is not an exact comparison, as there are different features, implementations, etc. between any two surface-similar SQL services. Nonetheless, we can still reason about Cloud SQL without needing to bring in a technical analysis of a third-party service.

There are many factors which could influence the fetch time on a query. You say that there's no issue in executing the queries, and I'm assuming this means that you've checked on-instance statistics to see that your indexes are enabling a fast query time. The issue is in "fetching" as separated from the execution of the query. The definition of "fetch" is important here: there could be other variables influencing perceived "fetch" time depending on how you measure it, whether, due to your benchmark's methodology, you might also be including the time necessary to transform the data into programming-language objects, etc.

I'm curious how you diagnose this latency; how are you fetching the data? What network topology is involved? Is the computer fetching the data far from the instance? You could see wildly different network transfer times depending on this factor. There's also the issue of the performance statistics of the fetching computer, and the manner in which the "fetch" is triggered. 

Feel free to update the thread with some information which responds to the above questions, and we should be able to narrow-down what the issue is. 23 seconds can even in fact be a reasonable time, all things dependent. We can't know until we speak more specifically about how everything is being done.

On Thursday, November 19, 2015 at 9:52:17 AM UTC-5, Elia Palme wrote:

Hi,

we just migrated our DB from Amazon RDS to Google SQL. On Amazon our instance was a (db.r3.large  2 CPU  15GB of RAM) on Google SQL we have selected the D32 with 16GB of RAM.

The migration worked ok and we transferred 40GB of data from AWS to Google Cloud. The two DBs have been set up with the same flags (innodb_flush_log_at_trx_commit=2,innodb_file_per_table=ON, etc.)

The problem is that we are experiencing very slow data fetch. The issue in not in executing the queries, almost all our queries can use indexes and are very quick to execute.

The issue in in the fetching, some time a query need 23 seconds of fetch time, if we re-run the same query the second time is very fast less than a second (I assume because data have been loaded in memory).

On Amazon RS we did not have this kind of issue, however we did have the Provisioned IOPS option which was probably helping a lot. 

How can we improve the fetch time? Is it possible to have a SQL instance with  Provisioned IOPS or running on SSD disks?

Thanks

Elia 

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/71b0caea-cb3e-41d1-b0ad-db19e722e7ed%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Very slow fetch

Hi,

we just migrated our DB from Amazon RDS to Google SQL. On Amazon our instance was a (db.r3.large  2 CPU  15GB of RAM) on Google SQL we have selected the D32 with 16GB of RAM.

The migration worked ok and we transferred 40GB of data from AWS to Google Cloud. The two DBs have been set up with the same flags (innodb_flush_log_at_trx_commit=2,innodb_file_per_table=ON, etc.)

The problem is that we are experiencing very slow data fetch. The issue in not in executing the queries, almost all our queries can use indexes and are very quick to execute.

The issue in in the fetching, some time a query need 23 seconds of fetch time, if we re-run the same query the second time is very fast less than a second (I assume because data have been loaded in memory).

On Amazon RS we did not have this kind of issue, however we did have the Provisioned IOPS option which was probably helping a lot. 

How can we improve the fetch time? Is it possible to have a SQL instance with  Provisioned IOPS or running on SSD disks?

Thanks

Elia 

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/14a98048-024d-4776-961a-4b698bcd0f69%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: connecting from app engine to an external database via JDBC

You're correct that JDBC connections on arbitrary ports are not going to work on App Engine, without seriously patching the driver and having it use the Sockets API, which is not the same as general sockets. However, JDBC connections to Cloud SQL are possible, as described in the docs. On Managed VMs, you have unrestricted access to the filesystem, network interfaces, process control, etc., so the App Engine sandbox doesn't apply and standard JDBC will easily function.

I hope this has helped answer your question, and feel free to browse the docs to learn more about the App Engine runtime, or Managed VMs on the other hand.

On Tuesday, November 17, 2015 at 1:08:00 PM UTC-5, Robert Dyas wrote:

From App Engine is it possible to make a JDBC connection to a remote database in another cloud or on-premises?

I see that your sockets API is limited, so wondering if this would work.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/59136848-e514-4440-b064-65717788e4ba%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Google Cloud Billing account closed

Hi,

The best way to get help with billing is to reach out via https://support.google.com/cloud/contact/cloud_platform_billing. This list is specifically for help with Cloud SQL itself.

Yours,

David

On Wed, Nov 18, 2015 at 8:45 AM, <sathyanarayanan.kumar88@gmail.com> wrote:

Hi,

 For a cloud training, I have signed up for Free trail starting yesterday [11/17/2015]. Created few instances.

Today when I tried to access my VM instances, it asks me to Enable Billing. I can see my Free trail expires by Jan-16-2016.

Any help would be appreciated

Billing id : 008295-9D7FF5-9A0230

Project ID : solrproject1

Project number : 488811110245

Best Regards,

Sathya

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/a8f8d269-cd42-4041-bfc7-a425d32641ad%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bZuPWxLLdcRFmvThxtQMDnfnY2fnMaQduj3j02znSergA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.